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

Line 143: When hr_api.check_integrity_violated Then

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

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

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

Line 148: When hr_api.parent_integrity_violated Then

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

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

148: When hr_api.parent_integrity_violated Then
149: -- Parent integrity has been violated
150: per_add_shd.g_api_dml := false; -- Unset the api dml status
151: per_add_shd.constraint_error
152: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
153: When hr_api.unique_integrity_violated Then
154: -- Unique integrity has been violated
155: per_add_shd.g_api_dml := false; -- Unset the api dml status
156: per_add_shd.constraint_error

Line 153: When hr_api.unique_integrity_violated Then

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

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

153: When hr_api.unique_integrity_violated Then
154: -- Unique integrity has been violated
155: per_add_shd.g_api_dml := false; -- Unset the api dml status
156: per_add_shd.constraint_error
157: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
158: When Others Then
159: per_add_shd.g_api_dml := false; -- Unset the api dml status
160: Raise;
161: End update_dml;

Line 454: when hr_api.cannot_find_prog_unit then

450: ,p_party_id_o -- HR/TCA merge
451: => per_add_shd.g_old_rec.party_id
452: );
453: exception
454: when hr_api.cannot_find_prog_unit then
455: hr_api.cannot_find_prog_unit_error
456: (p_module_name => 'PER_ADDRESSES'
457: ,p_hook_type => 'AU'
458: );

Line 455: hr_api.cannot_find_prog_unit_error

451: => per_add_shd.g_old_rec.party_id
452: );
453: exception
454: when hr_api.cannot_find_prog_unit then
455: hr_api.cannot_find_prog_unit_error
456: (p_module_name => 'PER_ADDRESSES'
457: ,p_hook_type => 'AU'
458: );
459: end;

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

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

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

551: If (p_rec.business_group_id = hr_api.g_number) then
552: p_rec.business_group_id :=
553: per_add_shd.g_old_rec.business_group_id;
554: End If;
555: If (p_rec.person_id = hr_api.g_number) then
556: p_rec.person_id :=
557: per_add_shd.g_old_rec.person_id;
558: End If;
559: If (p_rec.date_from = hr_api.g_date) then

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

555: If (p_rec.person_id = hr_api.g_number) then
556: p_rec.person_id :=
557: per_add_shd.g_old_rec.person_id;
558: End If;
559: If (p_rec.date_from = hr_api.g_date) then
560: p_rec.date_from :=
561: per_add_shd.g_old_rec.date_from;
562: End If;
563: If (p_rec.primary_flag = hr_api.g_varchar2) then

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

559: If (p_rec.date_from = hr_api.g_date) then
560: p_rec.date_from :=
561: per_add_shd.g_old_rec.date_from;
562: End If;
563: If (p_rec.primary_flag = hr_api.g_varchar2) then
564: p_rec.primary_flag :=
565: per_add_shd.g_old_rec.primary_flag;
566: End If;
567: If (p_rec.style = hr_api.g_varchar2) then

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

563: If (p_rec.primary_flag = hr_api.g_varchar2) then
564: p_rec.primary_flag :=
565: per_add_shd.g_old_rec.primary_flag;
566: End If;
567: If (p_rec.style = hr_api.g_varchar2) then
568: p_rec.style :=
569: per_add_shd.g_old_rec.style;
570: End If;
571: If (p_rec.address_line1 = hr_api.g_varchar2) then

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

567: If (p_rec.style = hr_api.g_varchar2) then
568: p_rec.style :=
569: per_add_shd.g_old_rec.style;
570: End If;
571: If (p_rec.address_line1 = hr_api.g_varchar2) then
572: p_rec.address_line1 :=
573: per_add_shd.g_old_rec.address_line1;
574: End If;
575: If (p_rec.address_line2 = hr_api.g_varchar2) then

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

571: If (p_rec.address_line1 = hr_api.g_varchar2) then
572: p_rec.address_line1 :=
573: per_add_shd.g_old_rec.address_line1;
574: End If;
575: If (p_rec.address_line2 = hr_api.g_varchar2) then
576: p_rec.address_line2 :=
577: per_add_shd.g_old_rec.address_line2;
578: End If;
579: If (p_rec.address_line3 = hr_api.g_varchar2) then

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

575: If (p_rec.address_line2 = hr_api.g_varchar2) then
576: p_rec.address_line2 :=
577: per_add_shd.g_old_rec.address_line2;
578: End If;
579: If (p_rec.address_line3 = hr_api.g_varchar2) then
580: p_rec.address_line3 :=
581: per_add_shd.g_old_rec.address_line3;
582: End If;
583: If (p_rec.address_type = hr_api.g_varchar2) then

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

579: If (p_rec.address_line3 = hr_api.g_varchar2) then
580: p_rec.address_line3 :=
581: per_add_shd.g_old_rec.address_line3;
582: End If;
583: If (p_rec.address_type = hr_api.g_varchar2) then
584: p_rec.address_type :=
585: per_add_shd.g_old_rec.address_type;
586: End If;
587: If (p_rec.comments = hr_api.g_varchar2) then

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

583: If (p_rec.address_type = hr_api.g_varchar2) then
584: p_rec.address_type :=
585: per_add_shd.g_old_rec.address_type;
586: End If;
587: If (p_rec.comments = hr_api.g_varchar2) then
588: p_rec.comments :=
589: per_add_shd.g_old_rec.comments;
590: End If;
591: If (p_rec.country = hr_api.g_varchar2) then

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

587: If (p_rec.comments = hr_api.g_varchar2) then
588: p_rec.comments :=
589: per_add_shd.g_old_rec.comments;
590: End If;
591: If (p_rec.country = hr_api.g_varchar2) then
592: p_rec.country :=
593: per_add_shd.g_old_rec.country;
594: End If;
595: If (p_rec.date_to = hr_api.g_date) then

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

591: If (p_rec.country = hr_api.g_varchar2) then
592: p_rec.country :=
593: per_add_shd.g_old_rec.country;
594: End If;
595: If (p_rec.date_to = hr_api.g_date) then
596: p_rec.date_to :=
597: per_add_shd.g_old_rec.date_to;
598: End If;
599: If (p_rec.postal_code = hr_api.g_varchar2) then

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

595: If (p_rec.date_to = hr_api.g_date) then
596: p_rec.date_to :=
597: per_add_shd.g_old_rec.date_to;
598: End If;
599: If (p_rec.postal_code = hr_api.g_varchar2) then
600: p_rec.postal_code :=
601: per_add_shd.g_old_rec.postal_code;
602: End If;
603: If (p_rec.region_1 = hr_api.g_varchar2) then

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

599: If (p_rec.postal_code = hr_api.g_varchar2) then
600: p_rec.postal_code :=
601: per_add_shd.g_old_rec.postal_code;
602: End If;
603: If (p_rec.region_1 = hr_api.g_varchar2) then
604: p_rec.region_1 :=
605: per_add_shd.g_old_rec.region_1;
606: End If;
607: If (p_rec.region_2 = hr_api.g_varchar2) then

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

603: If (p_rec.region_1 = hr_api.g_varchar2) then
604: p_rec.region_1 :=
605: per_add_shd.g_old_rec.region_1;
606: End If;
607: If (p_rec.region_2 = hr_api.g_varchar2) then
608: p_rec.region_2 :=
609: per_add_shd.g_old_rec.region_2;
610: End If;
611: If (p_rec.region_3 = hr_api.g_varchar2) then

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

607: If (p_rec.region_2 = hr_api.g_varchar2) then
608: p_rec.region_2 :=
609: per_add_shd.g_old_rec.region_2;
610: End If;
611: If (p_rec.region_3 = hr_api.g_varchar2) then
612: p_rec.region_3 :=
613: per_add_shd.g_old_rec.region_3;
614: End If;
615: If (p_rec.telephone_number_1 = hr_api.g_varchar2) then

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

611: If (p_rec.region_3 = hr_api.g_varchar2) then
612: p_rec.region_3 :=
613: per_add_shd.g_old_rec.region_3;
614: End If;
615: If (p_rec.telephone_number_1 = hr_api.g_varchar2) then
616: p_rec.telephone_number_1 :=
617: per_add_shd.g_old_rec.telephone_number_1;
618: End If;
619: If (p_rec.telephone_number_2 = hr_api.g_varchar2) then

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

615: If (p_rec.telephone_number_1 = hr_api.g_varchar2) then
616: p_rec.telephone_number_1 :=
617: per_add_shd.g_old_rec.telephone_number_1;
618: End If;
619: If (p_rec.telephone_number_2 = hr_api.g_varchar2) then
620: p_rec.telephone_number_2 :=
621: per_add_shd.g_old_rec.telephone_number_2;
622: End If;
623: If (p_rec.telephone_number_3 = hr_api.g_varchar2) then

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

619: If (p_rec.telephone_number_2 = hr_api.g_varchar2) then
620: p_rec.telephone_number_2 :=
621: per_add_shd.g_old_rec.telephone_number_2;
622: End If;
623: If (p_rec.telephone_number_3 = hr_api.g_varchar2) then
624: p_rec.telephone_number_3 :=
625: per_add_shd.g_old_rec.telephone_number_3;
626: End If;
627: If (p_rec.town_or_city = hr_api.g_varchar2) then

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

623: If (p_rec.telephone_number_3 = hr_api.g_varchar2) then
624: p_rec.telephone_number_3 :=
625: per_add_shd.g_old_rec.telephone_number_3;
626: End If;
627: If (p_rec.town_or_city = hr_api.g_varchar2) then
628: p_rec.town_or_city :=
629: per_add_shd.g_old_rec.town_or_city;
630: End If;
631: If (p_rec.request_id = hr_api.g_number) then

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

627: If (p_rec.town_or_city = hr_api.g_varchar2) then
628: p_rec.town_or_city :=
629: per_add_shd.g_old_rec.town_or_city;
630: End If;
631: If (p_rec.request_id = hr_api.g_number) then
632: p_rec.request_id :=
633: per_add_shd.g_old_rec.request_id;
634: End If;
635: If (p_rec.program_application_id = hr_api.g_number) then

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

631: If (p_rec.request_id = hr_api.g_number) then
632: p_rec.request_id :=
633: per_add_shd.g_old_rec.request_id;
634: End If;
635: If (p_rec.program_application_id = hr_api.g_number) then
636: p_rec.program_application_id :=
637: per_add_shd.g_old_rec.program_application_id;
638: End If;
639: If (p_rec.program_id = hr_api.g_number) then

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

635: If (p_rec.program_application_id = hr_api.g_number) then
636: p_rec.program_application_id :=
637: per_add_shd.g_old_rec.program_application_id;
638: End If;
639: If (p_rec.program_id = hr_api.g_number) then
640: p_rec.program_id :=
641: per_add_shd.g_old_rec.program_id;
642: End If;
643: If (p_rec.program_update_date = hr_api.g_date) then

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

639: If (p_rec.program_id = hr_api.g_number) then
640: p_rec.program_id :=
641: per_add_shd.g_old_rec.program_id;
642: End If;
643: If (p_rec.program_update_date = hr_api.g_date) then
644: p_rec.program_update_date :=
645: per_add_shd.g_old_rec.program_update_date;
646: End If;
647: If (p_rec.addr_attribute_category = hr_api.g_varchar2) then

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

643: If (p_rec.program_update_date = hr_api.g_date) then
644: p_rec.program_update_date :=
645: per_add_shd.g_old_rec.program_update_date;
646: End If;
647: If (p_rec.addr_attribute_category = hr_api.g_varchar2) then
648: p_rec.addr_attribute_category :=
649: per_add_shd.g_old_rec.addr_attribute_category;
650: End If;
651: If (p_rec.addr_attribute1 = hr_api.g_varchar2) then

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

647: If (p_rec.addr_attribute_category = hr_api.g_varchar2) then
648: p_rec.addr_attribute_category :=
649: per_add_shd.g_old_rec.addr_attribute_category;
650: End If;
651: If (p_rec.addr_attribute1 = hr_api.g_varchar2) then
652: p_rec.addr_attribute1 :=
653: per_add_shd.g_old_rec.addr_attribute1;
654: End If;
655: If (p_rec.addr_attribute2 = hr_api.g_varchar2) then

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

651: If (p_rec.addr_attribute1 = hr_api.g_varchar2) then
652: p_rec.addr_attribute1 :=
653: per_add_shd.g_old_rec.addr_attribute1;
654: End If;
655: If (p_rec.addr_attribute2 = hr_api.g_varchar2) then
656: p_rec.addr_attribute2 :=
657: per_add_shd.g_old_rec.addr_attribute2;
658: End If;
659: If (p_rec.addr_attribute3 = hr_api.g_varchar2) then

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

655: If (p_rec.addr_attribute2 = hr_api.g_varchar2) then
656: p_rec.addr_attribute2 :=
657: per_add_shd.g_old_rec.addr_attribute2;
658: End If;
659: If (p_rec.addr_attribute3 = hr_api.g_varchar2) then
660: p_rec.addr_attribute3 :=
661: per_add_shd.g_old_rec.addr_attribute3;
662: End If;
663: If (p_rec.addr_attribute4 = hr_api.g_varchar2) then

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

659: If (p_rec.addr_attribute3 = hr_api.g_varchar2) then
660: p_rec.addr_attribute3 :=
661: per_add_shd.g_old_rec.addr_attribute3;
662: End If;
663: If (p_rec.addr_attribute4 = hr_api.g_varchar2) then
664: p_rec.addr_attribute4 :=
665: per_add_shd.g_old_rec.addr_attribute4;
666: End If;
667: If (p_rec.addr_attribute5 = hr_api.g_varchar2) then

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

663: If (p_rec.addr_attribute4 = hr_api.g_varchar2) then
664: p_rec.addr_attribute4 :=
665: per_add_shd.g_old_rec.addr_attribute4;
666: End If;
667: If (p_rec.addr_attribute5 = hr_api.g_varchar2) then
668: p_rec.addr_attribute5 :=
669: per_add_shd.g_old_rec.addr_attribute5;
670: End If;
671: If (p_rec.addr_attribute6 = hr_api.g_varchar2) then

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

667: If (p_rec.addr_attribute5 = hr_api.g_varchar2) then
668: p_rec.addr_attribute5 :=
669: per_add_shd.g_old_rec.addr_attribute5;
670: End If;
671: If (p_rec.addr_attribute6 = hr_api.g_varchar2) then
672: p_rec.addr_attribute6 :=
673: per_add_shd.g_old_rec.addr_attribute6;
674: End If;
675: If (p_rec.addr_attribute7 = hr_api.g_varchar2) then

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

671: If (p_rec.addr_attribute6 = hr_api.g_varchar2) then
672: p_rec.addr_attribute6 :=
673: per_add_shd.g_old_rec.addr_attribute6;
674: End If;
675: If (p_rec.addr_attribute7 = hr_api.g_varchar2) then
676: p_rec.addr_attribute7 :=
677: per_add_shd.g_old_rec.addr_attribute7;
678: End If;
679: If (p_rec.addr_attribute8 = hr_api.g_varchar2) then

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

675: If (p_rec.addr_attribute7 = hr_api.g_varchar2) then
676: p_rec.addr_attribute7 :=
677: per_add_shd.g_old_rec.addr_attribute7;
678: End If;
679: If (p_rec.addr_attribute8 = hr_api.g_varchar2) then
680: p_rec.addr_attribute8 :=
681: per_add_shd.g_old_rec.addr_attribute8;
682: End If;
683: If (p_rec.addr_attribute9 = hr_api.g_varchar2) then

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

679: If (p_rec.addr_attribute8 = hr_api.g_varchar2) then
680: p_rec.addr_attribute8 :=
681: per_add_shd.g_old_rec.addr_attribute8;
682: End If;
683: If (p_rec.addr_attribute9 = hr_api.g_varchar2) then
684: p_rec.addr_attribute9 :=
685: per_add_shd.g_old_rec.addr_attribute9;
686: End If;
687: If (p_rec.addr_attribute10 = hr_api.g_varchar2) then

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

683: If (p_rec.addr_attribute9 = hr_api.g_varchar2) then
684: p_rec.addr_attribute9 :=
685: per_add_shd.g_old_rec.addr_attribute9;
686: End If;
687: If (p_rec.addr_attribute10 = hr_api.g_varchar2) then
688: p_rec.addr_attribute10 :=
689: per_add_shd.g_old_rec.addr_attribute10;
690: End If;
691: If (p_rec.addr_attribute11 = hr_api.g_varchar2) then

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

687: If (p_rec.addr_attribute10 = hr_api.g_varchar2) then
688: p_rec.addr_attribute10 :=
689: per_add_shd.g_old_rec.addr_attribute10;
690: End If;
691: If (p_rec.addr_attribute11 = hr_api.g_varchar2) then
692: p_rec.addr_attribute11 :=
693: per_add_shd.g_old_rec.addr_attribute11;
694: End If;
695: If (p_rec.addr_attribute12 = hr_api.g_varchar2) then

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

691: If (p_rec.addr_attribute11 = hr_api.g_varchar2) then
692: p_rec.addr_attribute11 :=
693: per_add_shd.g_old_rec.addr_attribute11;
694: End If;
695: If (p_rec.addr_attribute12 = hr_api.g_varchar2) then
696: p_rec.addr_attribute12 :=
697: per_add_shd.g_old_rec.addr_attribute12;
698: End If;
699: If (p_rec.addr_attribute13 = hr_api.g_varchar2) then

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

695: If (p_rec.addr_attribute12 = hr_api.g_varchar2) then
696: p_rec.addr_attribute12 :=
697: per_add_shd.g_old_rec.addr_attribute12;
698: End If;
699: If (p_rec.addr_attribute13 = hr_api.g_varchar2) then
700: p_rec.addr_attribute13 :=
701: per_add_shd.g_old_rec.addr_attribute13;
702: End If;
703: If (p_rec.addr_attribute14 = hr_api.g_varchar2) then

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

699: If (p_rec.addr_attribute13 = hr_api.g_varchar2) then
700: p_rec.addr_attribute13 :=
701: per_add_shd.g_old_rec.addr_attribute13;
702: End If;
703: If (p_rec.addr_attribute14 = hr_api.g_varchar2) then
704: p_rec.addr_attribute14 :=
705: per_add_shd.g_old_rec.addr_attribute14;
706: End If;
707: If (p_rec.addr_attribute15 = hr_api.g_varchar2) then

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

703: If (p_rec.addr_attribute14 = hr_api.g_varchar2) then
704: p_rec.addr_attribute14 :=
705: per_add_shd.g_old_rec.addr_attribute14;
706: End If;
707: If (p_rec.addr_attribute15 = hr_api.g_varchar2) then
708: p_rec.addr_attribute15 :=
709: per_add_shd.g_old_rec.addr_attribute15;
710: End If;
711: If (p_rec.addr_attribute16 = hr_api.g_varchar2) then

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

707: If (p_rec.addr_attribute15 = hr_api.g_varchar2) then
708: p_rec.addr_attribute15 :=
709: per_add_shd.g_old_rec.addr_attribute15;
710: End If;
711: If (p_rec.addr_attribute16 = hr_api.g_varchar2) then
712: p_rec.addr_attribute16 :=
713: per_add_shd.g_old_rec.addr_attribute16;
714: End If;
715: If (p_rec.addr_attribute17 = hr_api.g_varchar2) then

Line 715: If (p_rec.addr_attribute17 = hr_api.g_varchar2) then

711: If (p_rec.addr_attribute16 = hr_api.g_varchar2) then
712: p_rec.addr_attribute16 :=
713: per_add_shd.g_old_rec.addr_attribute16;
714: End If;
715: If (p_rec.addr_attribute17 = hr_api.g_varchar2) then
716: p_rec.addr_attribute17 :=
717: per_add_shd.g_old_rec.addr_attribute17;
718: End If;
719: If (p_rec.addr_attribute18 = hr_api.g_varchar2) then

Line 719: If (p_rec.addr_attribute18 = hr_api.g_varchar2) then

715: If (p_rec.addr_attribute17 = hr_api.g_varchar2) then
716: p_rec.addr_attribute17 :=
717: per_add_shd.g_old_rec.addr_attribute17;
718: End If;
719: If (p_rec.addr_attribute18 = hr_api.g_varchar2) then
720: p_rec.addr_attribute18 :=
721: per_add_shd.g_old_rec.addr_attribute18;
722: End If;
723: If (p_rec.addr_attribute19 = hr_api.g_varchar2) then

Line 723: If (p_rec.addr_attribute19 = hr_api.g_varchar2) then

719: If (p_rec.addr_attribute18 = hr_api.g_varchar2) then
720: p_rec.addr_attribute18 :=
721: per_add_shd.g_old_rec.addr_attribute18;
722: End If;
723: If (p_rec.addr_attribute19 = hr_api.g_varchar2) then
724: p_rec.addr_attribute19 :=
725: per_add_shd.g_old_rec.addr_attribute19;
726: End If;
727: If (p_rec.addr_attribute20 = hr_api.g_varchar2) then

Line 727: If (p_rec.addr_attribute20 = hr_api.g_varchar2) then

723: If (p_rec.addr_attribute19 = hr_api.g_varchar2) then
724: p_rec.addr_attribute19 :=
725: per_add_shd.g_old_rec.addr_attribute19;
726: End If;
727: If (p_rec.addr_attribute20 = hr_api.g_varchar2) then
728: p_rec.addr_attribute20 :=
729: per_add_shd.g_old_rec.addr_attribute20;
730: End If;
731: If (p_rec.add_information13 = hr_api.g_varchar2) then

Line 731: If (p_rec.add_information13 = hr_api.g_varchar2) then

727: If (p_rec.addr_attribute20 = hr_api.g_varchar2) then
728: p_rec.addr_attribute20 :=
729: per_add_shd.g_old_rec.addr_attribute20;
730: End If;
731: If (p_rec.add_information13 = hr_api.g_varchar2) then
732: p_rec.add_information13 :=
733: per_add_shd.g_old_rec.add_information13;
734: End If;
735: If (p_rec.add_information14 = hr_api.g_varchar2) then

Line 735: If (p_rec.add_information14 = hr_api.g_varchar2) then

731: If (p_rec.add_information13 = hr_api.g_varchar2) then
732: p_rec.add_information13 :=
733: per_add_shd.g_old_rec.add_information13;
734: End If;
735: If (p_rec.add_information14 = hr_api.g_varchar2) then
736: p_rec.add_information14 :=
737: per_add_shd.g_old_rec.add_information14;
738: End If;
739: If (p_rec.add_information15 = hr_api.g_varchar2) then

Line 739: If (p_rec.add_information15 = hr_api.g_varchar2) then

735: If (p_rec.add_information14 = hr_api.g_varchar2) then
736: p_rec.add_information14 :=
737: per_add_shd.g_old_rec.add_information14;
738: End If;
739: If (p_rec.add_information15 = hr_api.g_varchar2) then
740: p_rec.add_information15 :=
741: per_add_shd.g_old_rec.add_information15;
742: End If;
743: If (p_rec.add_information16 = hr_api.g_varchar2) then

Line 743: If (p_rec.add_information16 = hr_api.g_varchar2) then

739: If (p_rec.add_information15 = hr_api.g_varchar2) then
740: p_rec.add_information15 :=
741: per_add_shd.g_old_rec.add_information15;
742: End If;
743: If (p_rec.add_information16 = hr_api.g_varchar2) then
744: p_rec.add_information16 :=
745: per_add_shd.g_old_rec.add_information16;
746: End If;
747: If (p_rec.add_information17 = hr_api.g_varchar2) then

Line 747: If (p_rec.add_information17 = hr_api.g_varchar2) then

743: If (p_rec.add_information16 = hr_api.g_varchar2) then
744: p_rec.add_information16 :=
745: per_add_shd.g_old_rec.add_information16;
746: End If;
747: If (p_rec.add_information17 = hr_api.g_varchar2) then
748: p_rec.add_information17 :=
749: per_add_shd.g_old_rec.add_information17;
750: End If;
751: If (p_rec.add_information18 = hr_api.g_varchar2) then

Line 751: If (p_rec.add_information18 = hr_api.g_varchar2) then

747: If (p_rec.add_information17 = hr_api.g_varchar2) then
748: p_rec.add_information17 :=
749: per_add_shd.g_old_rec.add_information17;
750: End If;
751: If (p_rec.add_information18 = hr_api.g_varchar2) then
752: p_rec.add_information18 :=
753: per_add_shd.g_old_rec.add_information18;
754: End If;
755: If (p_rec.add_information19 = hr_api.g_varchar2) then

Line 755: If (p_rec.add_information19 = hr_api.g_varchar2) then

751: If (p_rec.add_information18 = hr_api.g_varchar2) then
752: p_rec.add_information18 :=
753: per_add_shd.g_old_rec.add_information18;
754: End If;
755: If (p_rec.add_information19 = hr_api.g_varchar2) then
756: p_rec.add_information19 :=
757: per_add_shd.g_old_rec.add_information19;
758: End If;
759: If (p_rec.add_information20 = hr_api.g_varchar2) then

Line 759: If (p_rec.add_information20 = hr_api.g_varchar2) then

755: If (p_rec.add_information19 = hr_api.g_varchar2) then
756: p_rec.add_information19 :=
757: per_add_shd.g_old_rec.add_information19;
758: End If;
759: If (p_rec.add_information20 = hr_api.g_varchar2) then
760: p_rec.add_information20 :=
761: per_add_shd.g_old_rec.add_information20;
762: End If;
763: If (p_rec.party_id = hr_api.g_number) then -- HR/TCA merge

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

759: If (p_rec.add_information20 = hr_api.g_varchar2) then
760: p_rec.add_information20 :=
761: per_add_shd.g_old_rec.add_information20;
762: End If;
763: If (p_rec.party_id = hr_api.g_number) then -- HR/TCA merge
764: p_rec.party_id :=
765: per_add_shd.g_old_rec.party_id;
766: End If;
767:

Line 848: Raise HR_Api.Validate_Enabled;

844: --
845: -- If we are validating then raise the Validate_Enabled exception
846: --
847: If p_validate then
848: Raise HR_Api.Validate_Enabled;
849: End If;
850: --
851: hr_utility.set_location(' Leaving:'||l_proc, 10);
852: Exception

Line 853: When HR_Api.Validate_Enabled Then

849: End If;
850: --
851: hr_utility.set_location(' Leaving:'||l_proc, 10);
852: Exception
853: When HR_Api.Validate_Enabled Then
854: --
855: -- As the Validate_Enabled exception has been raised
856: -- we must rollback to the savepoint
857: --

Line 867: ,p_business_group_id in number default hr_api.g_number

863: -- ----------------------------------------------------------------------------
864: Procedure upd
865: (
866: p_address_id in number
867: ,p_business_group_id in number default hr_api.g_number
868: ,p_person_id in number default hr_api.g_number
869: -- 70.2 change a start.
870: ,p_date_from in date default hr_api.g_date
871: -- 70.2 change a end.

Line 868: ,p_person_id in number default hr_api.g_number

864: Procedure upd
865: (
866: p_address_id in number
867: ,p_business_group_id in number default hr_api.g_number
868: ,p_person_id in number default hr_api.g_number
869: -- 70.2 change a start.
870: ,p_date_from in date default hr_api.g_date
871: -- 70.2 change a end.
872: -- Start of fix for Bug #2431588

Line 870: ,p_date_from in date default hr_api.g_date

866: p_address_id in number
867: ,p_business_group_id in number default hr_api.g_number
868: ,p_person_id in number default hr_api.g_number
869: -- 70.2 change a start.
870: ,p_date_from in date default hr_api.g_date
871: -- 70.2 change a end.
872: -- Start of fix for Bug #2431588
873: ,p_primary_flag in varchar2 default hr_api.g_varchar2
874: -- End of fix for Bug #2431588

Line 873: ,p_primary_flag in varchar2 default hr_api.g_varchar2

869: -- 70.2 change a start.
870: ,p_date_from in date default hr_api.g_date
871: -- 70.2 change a end.
872: -- Start of fix for Bug #2431588
873: ,p_primary_flag in varchar2 default hr_api.g_varchar2
874: -- End of fix for Bug #2431588
875: ,p_address_line1 in varchar2 default hr_api.g_varchar2
876: ,p_address_line2 in varchar2 default hr_api.g_varchar2
877: ,p_address_line3 in varchar2 default hr_api.g_varchar2

Line 875: ,p_address_line1 in varchar2 default hr_api.g_varchar2

871: -- 70.2 change a end.
872: -- Start of fix for Bug #2431588
873: ,p_primary_flag in varchar2 default hr_api.g_varchar2
874: -- End of fix for Bug #2431588
875: ,p_address_line1 in varchar2 default hr_api.g_varchar2
876: ,p_address_line2 in varchar2 default hr_api.g_varchar2
877: ,p_address_line3 in varchar2 default hr_api.g_varchar2
878: ,p_address_type in varchar2 default hr_api.g_varchar2
879: ,p_comments in clob default hr_api.g_varchar2 -- Bug#13362792

Line 876: ,p_address_line2 in varchar2 default hr_api.g_varchar2

872: -- Start of fix for Bug #2431588
873: ,p_primary_flag in varchar2 default hr_api.g_varchar2
874: -- End of fix for Bug #2431588
875: ,p_address_line1 in varchar2 default hr_api.g_varchar2
876: ,p_address_line2 in varchar2 default hr_api.g_varchar2
877: ,p_address_line3 in varchar2 default hr_api.g_varchar2
878: ,p_address_type in varchar2 default hr_api.g_varchar2
879: ,p_comments in clob default hr_api.g_varchar2 -- Bug#13362792
880: ,p_country in varchar2 default hr_api.g_varchar2

Line 877: ,p_address_line3 in varchar2 default hr_api.g_varchar2

873: ,p_primary_flag in varchar2 default hr_api.g_varchar2
874: -- End of fix for Bug #2431588
875: ,p_address_line1 in varchar2 default hr_api.g_varchar2
876: ,p_address_line2 in varchar2 default hr_api.g_varchar2
877: ,p_address_line3 in varchar2 default hr_api.g_varchar2
878: ,p_address_type in varchar2 default hr_api.g_varchar2
879: ,p_comments in clob default hr_api.g_varchar2 -- Bug#13362792
880: ,p_country in varchar2 default hr_api.g_varchar2
881: ,p_date_to in date default hr_api.g_date

Line 878: ,p_address_type in varchar2 default hr_api.g_varchar2

874: -- End of fix for Bug #2431588
875: ,p_address_line1 in varchar2 default hr_api.g_varchar2
876: ,p_address_line2 in varchar2 default hr_api.g_varchar2
877: ,p_address_line3 in varchar2 default hr_api.g_varchar2
878: ,p_address_type in varchar2 default hr_api.g_varchar2
879: ,p_comments in clob default hr_api.g_varchar2 -- Bug#13362792
880: ,p_country in varchar2 default hr_api.g_varchar2
881: ,p_date_to in date default hr_api.g_date
882: ,p_postal_code in varchar2 default hr_api.g_varchar2

Line 879: ,p_comments in clob default hr_api.g_varchar2 -- Bug#13362792

875: ,p_address_line1 in varchar2 default hr_api.g_varchar2
876: ,p_address_line2 in varchar2 default hr_api.g_varchar2
877: ,p_address_line3 in varchar2 default hr_api.g_varchar2
878: ,p_address_type in varchar2 default hr_api.g_varchar2
879: ,p_comments in clob default hr_api.g_varchar2 -- Bug#13362792
880: ,p_country in varchar2 default hr_api.g_varchar2
881: ,p_date_to in date default hr_api.g_date
882: ,p_postal_code in varchar2 default hr_api.g_varchar2
883: ,p_region_1 in varchar2 default hr_api.g_varchar2

Line 880: ,p_country in varchar2 default hr_api.g_varchar2

876: ,p_address_line2 in varchar2 default hr_api.g_varchar2
877: ,p_address_line3 in varchar2 default hr_api.g_varchar2
878: ,p_address_type in varchar2 default hr_api.g_varchar2
879: ,p_comments in clob default hr_api.g_varchar2 -- Bug#13362792
880: ,p_country in varchar2 default hr_api.g_varchar2
881: ,p_date_to in date default hr_api.g_date
882: ,p_postal_code in varchar2 default hr_api.g_varchar2
883: ,p_region_1 in varchar2 default hr_api.g_varchar2
884: ,p_region_2 in varchar2 default hr_api.g_varchar2

Line 881: ,p_date_to in date default hr_api.g_date

877: ,p_address_line3 in varchar2 default hr_api.g_varchar2
878: ,p_address_type in varchar2 default hr_api.g_varchar2
879: ,p_comments in clob default hr_api.g_varchar2 -- Bug#13362792
880: ,p_country in varchar2 default hr_api.g_varchar2
881: ,p_date_to in date default hr_api.g_date
882: ,p_postal_code in varchar2 default hr_api.g_varchar2
883: ,p_region_1 in varchar2 default hr_api.g_varchar2
884: ,p_region_2 in varchar2 default hr_api.g_varchar2
885: ,p_region_3 in varchar2 default hr_api.g_varchar2

Line 882: ,p_postal_code in varchar2 default hr_api.g_varchar2

878: ,p_address_type in varchar2 default hr_api.g_varchar2
879: ,p_comments in clob default hr_api.g_varchar2 -- Bug#13362792
880: ,p_country in varchar2 default hr_api.g_varchar2
881: ,p_date_to in date default hr_api.g_date
882: ,p_postal_code in varchar2 default hr_api.g_varchar2
883: ,p_region_1 in varchar2 default hr_api.g_varchar2
884: ,p_region_2 in varchar2 default hr_api.g_varchar2
885: ,p_region_3 in varchar2 default hr_api.g_varchar2
886: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2

Line 883: ,p_region_1 in varchar2 default hr_api.g_varchar2

879: ,p_comments in clob default hr_api.g_varchar2 -- Bug#13362792
880: ,p_country in varchar2 default hr_api.g_varchar2
881: ,p_date_to in date default hr_api.g_date
882: ,p_postal_code in varchar2 default hr_api.g_varchar2
883: ,p_region_1 in varchar2 default hr_api.g_varchar2
884: ,p_region_2 in varchar2 default hr_api.g_varchar2
885: ,p_region_3 in varchar2 default hr_api.g_varchar2
886: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
887: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2

Line 884: ,p_region_2 in varchar2 default hr_api.g_varchar2

880: ,p_country in varchar2 default hr_api.g_varchar2
881: ,p_date_to in date default hr_api.g_date
882: ,p_postal_code in varchar2 default hr_api.g_varchar2
883: ,p_region_1 in varchar2 default hr_api.g_varchar2
884: ,p_region_2 in varchar2 default hr_api.g_varchar2
885: ,p_region_3 in varchar2 default hr_api.g_varchar2
886: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
887: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
888: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2

Line 885: ,p_region_3 in varchar2 default hr_api.g_varchar2

881: ,p_date_to in date default hr_api.g_date
882: ,p_postal_code in varchar2 default hr_api.g_varchar2
883: ,p_region_1 in varchar2 default hr_api.g_varchar2
884: ,p_region_2 in varchar2 default hr_api.g_varchar2
885: ,p_region_3 in varchar2 default hr_api.g_varchar2
886: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
887: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
888: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
889: ,p_town_or_city in varchar2 default hr_api.g_varchar2

Line 886: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2

882: ,p_postal_code in varchar2 default hr_api.g_varchar2
883: ,p_region_1 in varchar2 default hr_api.g_varchar2
884: ,p_region_2 in varchar2 default hr_api.g_varchar2
885: ,p_region_3 in varchar2 default hr_api.g_varchar2
886: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
887: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
888: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
889: ,p_town_or_city in varchar2 default hr_api.g_varchar2
890: ,p_request_id in number default hr_api.g_number

Line 887: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2

883: ,p_region_1 in varchar2 default hr_api.g_varchar2
884: ,p_region_2 in varchar2 default hr_api.g_varchar2
885: ,p_region_3 in varchar2 default hr_api.g_varchar2
886: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
887: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
888: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
889: ,p_town_or_city in varchar2 default hr_api.g_varchar2
890: ,p_request_id in number default hr_api.g_number
891: ,p_program_application_id in number default hr_api.g_number

Line 888: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2

884: ,p_region_2 in varchar2 default hr_api.g_varchar2
885: ,p_region_3 in varchar2 default hr_api.g_varchar2
886: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
887: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
888: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
889: ,p_town_or_city in varchar2 default hr_api.g_varchar2
890: ,p_request_id in number default hr_api.g_number
891: ,p_program_application_id in number default hr_api.g_number
892: ,p_program_id in number default hr_api.g_number

Line 889: ,p_town_or_city in varchar2 default hr_api.g_varchar2

885: ,p_region_3 in varchar2 default hr_api.g_varchar2
886: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
887: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
888: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
889: ,p_town_or_city in varchar2 default hr_api.g_varchar2
890: ,p_request_id in number default hr_api.g_number
891: ,p_program_application_id in number default hr_api.g_number
892: ,p_program_id in number default hr_api.g_number
893: ,p_program_update_date in date default hr_api.g_date

Line 890: ,p_request_id in number default hr_api.g_number

886: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
887: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
888: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
889: ,p_town_or_city in varchar2 default hr_api.g_varchar2
890: ,p_request_id in number default hr_api.g_number
891: ,p_program_application_id in number default hr_api.g_number
892: ,p_program_id in number default hr_api.g_number
893: ,p_program_update_date in date default hr_api.g_date
894: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2

Line 891: ,p_program_application_id in number default hr_api.g_number

887: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
888: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
889: ,p_town_or_city in varchar2 default hr_api.g_varchar2
890: ,p_request_id in number default hr_api.g_number
891: ,p_program_application_id in number default hr_api.g_number
892: ,p_program_id in number default hr_api.g_number
893: ,p_program_update_date in date default hr_api.g_date
894: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
895: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2

Line 892: ,p_program_id in number default hr_api.g_number

888: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
889: ,p_town_or_city in varchar2 default hr_api.g_varchar2
890: ,p_request_id in number default hr_api.g_number
891: ,p_program_application_id in number default hr_api.g_number
892: ,p_program_id in number default hr_api.g_number
893: ,p_program_update_date in date default hr_api.g_date
894: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
895: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
896: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2

Line 893: ,p_program_update_date in date default hr_api.g_date

889: ,p_town_or_city in varchar2 default hr_api.g_varchar2
890: ,p_request_id in number default hr_api.g_number
891: ,p_program_application_id in number default hr_api.g_number
892: ,p_program_id in number default hr_api.g_number
893: ,p_program_update_date in date default hr_api.g_date
894: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
895: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
896: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
897: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2

Line 894: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2

890: ,p_request_id in number default hr_api.g_number
891: ,p_program_application_id in number default hr_api.g_number
892: ,p_program_id in number default hr_api.g_number
893: ,p_program_update_date in date default hr_api.g_date
894: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
895: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
896: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
897: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
898: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2

Line 895: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2

891: ,p_program_application_id in number default hr_api.g_number
892: ,p_program_id in number default hr_api.g_number
893: ,p_program_update_date in date default hr_api.g_date
894: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
895: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
896: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
897: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
898: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
899: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2

Line 896: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2

892: ,p_program_id in number default hr_api.g_number
893: ,p_program_update_date in date default hr_api.g_date
894: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
895: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
896: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
897: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
898: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
899: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
900: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2

Line 897: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2

893: ,p_program_update_date in date default hr_api.g_date
894: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
895: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
896: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
897: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
898: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
899: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
900: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
901: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2

Line 898: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2

894: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
895: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
896: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
897: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
898: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
899: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
900: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
901: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
902: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2

Line 899: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2

895: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
896: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
897: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
898: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
899: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
900: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
901: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
902: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
903: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2

Line 900: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2

896: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
897: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
898: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
899: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
900: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
901: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
902: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
903: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
904: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2

Line 901: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2

897: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
898: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
899: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
900: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
901: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
902: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
903: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
904: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
905: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2

Line 902: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2

898: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
899: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
900: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
901: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
902: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
903: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
904: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
905: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
906: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2

Line 903: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2

899: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
900: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
901: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
902: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
903: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
904: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
905: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
906: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
907: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2

Line 904: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2

900: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
901: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
902: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
903: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
904: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
905: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
906: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
907: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
908: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2

Line 905: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2

901: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
902: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
903: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
904: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
905: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
906: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
907: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
908: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
909: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2

Line 906: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2

902: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
903: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
904: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
905: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
906: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
907: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
908: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
909: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
910: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2

Line 907: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2

903: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
904: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
905: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
906: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
907: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
908: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
909: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
910: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
911: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2

Line 908: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2

904: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
905: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
906: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
907: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
908: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
909: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
910: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
911: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
912: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2

Line 909: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2

905: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
906: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
907: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
908: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
909: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
910: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
911: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
912: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
913: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2

Line 910: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2

906: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
907: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
908: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
909: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
910: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
911: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
912: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
913: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
914: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2

Line 911: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2

907: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
908: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
909: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
910: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
911: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
912: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
913: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
914: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
915: ,p_add_information13 in varchar2 default hr_api.g_varchar2

Line 912: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2

908: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
909: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
910: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
911: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
912: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
913: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
914: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
915: ,p_add_information13 in varchar2 default hr_api.g_varchar2
916: ,p_add_information14 in varchar2 default hr_api.g_varchar2

Line 913: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2

909: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
910: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
911: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
912: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
913: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
914: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
915: ,p_add_information13 in varchar2 default hr_api.g_varchar2
916: ,p_add_information14 in varchar2 default hr_api.g_varchar2
917: ,p_add_information15 in varchar2 default hr_api.g_varchar2

Line 914: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2

910: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
911: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
912: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
913: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
914: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
915: ,p_add_information13 in varchar2 default hr_api.g_varchar2
916: ,p_add_information14 in varchar2 default hr_api.g_varchar2
917: ,p_add_information15 in varchar2 default hr_api.g_varchar2
918: ,p_add_information16 in varchar2 default hr_api.g_varchar2

Line 915: ,p_add_information13 in varchar2 default hr_api.g_varchar2

911: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
912: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
913: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
914: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
915: ,p_add_information13 in varchar2 default hr_api.g_varchar2
916: ,p_add_information14 in varchar2 default hr_api.g_varchar2
917: ,p_add_information15 in varchar2 default hr_api.g_varchar2
918: ,p_add_information16 in varchar2 default hr_api.g_varchar2
919: ,p_add_information17 in varchar2 default hr_api.g_varchar2

Line 916: ,p_add_information14 in varchar2 default hr_api.g_varchar2

912: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
913: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
914: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
915: ,p_add_information13 in varchar2 default hr_api.g_varchar2
916: ,p_add_information14 in varchar2 default hr_api.g_varchar2
917: ,p_add_information15 in varchar2 default hr_api.g_varchar2
918: ,p_add_information16 in varchar2 default hr_api.g_varchar2
919: ,p_add_information17 in varchar2 default hr_api.g_varchar2
920: ,p_add_information18 in varchar2 default hr_api.g_varchar2

Line 917: ,p_add_information15 in varchar2 default hr_api.g_varchar2

913: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
914: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
915: ,p_add_information13 in varchar2 default hr_api.g_varchar2
916: ,p_add_information14 in varchar2 default hr_api.g_varchar2
917: ,p_add_information15 in varchar2 default hr_api.g_varchar2
918: ,p_add_information16 in varchar2 default hr_api.g_varchar2
919: ,p_add_information17 in varchar2 default hr_api.g_varchar2
920: ,p_add_information18 in varchar2 default hr_api.g_varchar2
921: ,p_add_information19 in varchar2 default hr_api.g_varchar2

Line 918: ,p_add_information16 in varchar2 default hr_api.g_varchar2

914: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
915: ,p_add_information13 in varchar2 default hr_api.g_varchar2
916: ,p_add_information14 in varchar2 default hr_api.g_varchar2
917: ,p_add_information15 in varchar2 default hr_api.g_varchar2
918: ,p_add_information16 in varchar2 default hr_api.g_varchar2
919: ,p_add_information17 in varchar2 default hr_api.g_varchar2
920: ,p_add_information18 in varchar2 default hr_api.g_varchar2
921: ,p_add_information19 in varchar2 default hr_api.g_varchar2
922: ,p_add_information20 in varchar2 default hr_api.g_varchar2

Line 919: ,p_add_information17 in varchar2 default hr_api.g_varchar2

915: ,p_add_information13 in varchar2 default hr_api.g_varchar2
916: ,p_add_information14 in varchar2 default hr_api.g_varchar2
917: ,p_add_information15 in varchar2 default hr_api.g_varchar2
918: ,p_add_information16 in varchar2 default hr_api.g_varchar2
919: ,p_add_information17 in varchar2 default hr_api.g_varchar2
920: ,p_add_information18 in varchar2 default hr_api.g_varchar2
921: ,p_add_information19 in varchar2 default hr_api.g_varchar2
922: ,p_add_information20 in varchar2 default hr_api.g_varchar2
923: ,p_object_version_number in out nocopy number

Line 920: ,p_add_information18 in varchar2 default hr_api.g_varchar2

916: ,p_add_information14 in varchar2 default hr_api.g_varchar2
917: ,p_add_information15 in varchar2 default hr_api.g_varchar2
918: ,p_add_information16 in varchar2 default hr_api.g_varchar2
919: ,p_add_information17 in varchar2 default hr_api.g_varchar2
920: ,p_add_information18 in varchar2 default hr_api.g_varchar2
921: ,p_add_information19 in varchar2 default hr_api.g_varchar2
922: ,p_add_information20 in varchar2 default hr_api.g_varchar2
923: ,p_object_version_number in out nocopy number
924: ,p_party_id in number default hr_api.g_number

Line 921: ,p_add_information19 in varchar2 default hr_api.g_varchar2

917: ,p_add_information15 in varchar2 default hr_api.g_varchar2
918: ,p_add_information16 in varchar2 default hr_api.g_varchar2
919: ,p_add_information17 in varchar2 default hr_api.g_varchar2
920: ,p_add_information18 in varchar2 default hr_api.g_varchar2
921: ,p_add_information19 in varchar2 default hr_api.g_varchar2
922: ,p_add_information20 in varchar2 default hr_api.g_varchar2
923: ,p_object_version_number in out nocopy number
924: ,p_party_id in number default hr_api.g_number
925: ,p_validate in boolean default false

Line 922: ,p_add_information20 in varchar2 default hr_api.g_varchar2

918: ,p_add_information16 in varchar2 default hr_api.g_varchar2
919: ,p_add_information17 in varchar2 default hr_api.g_varchar2
920: ,p_add_information18 in varchar2 default hr_api.g_varchar2
921: ,p_add_information19 in varchar2 default hr_api.g_varchar2
922: ,p_add_information20 in varchar2 default hr_api.g_varchar2
923: ,p_object_version_number in out nocopy number
924: ,p_party_id in number default hr_api.g_number
925: ,p_validate in boolean default false
926: ,p_effective_date in date

Line 924: ,p_party_id in number default hr_api.g_number

920: ,p_add_information18 in varchar2 default hr_api.g_varchar2
921: ,p_add_information19 in varchar2 default hr_api.g_varchar2
922: ,p_add_information20 in varchar2 default hr_api.g_varchar2
923: ,p_object_version_number in out nocopy number
924: ,p_party_id in number default hr_api.g_number
925: ,p_validate in boolean default false
926: ,p_effective_date in date
927: ,p_prflagval_override in boolean default false
928: ,p_validate_county in boolean default true

Line 929: ,p_style in varchar2 default hr_api.g_varchar2

925: ,p_validate in boolean default false
926: ,p_effective_date in date
927: ,p_prflagval_override in boolean default false
928: ,p_validate_county in boolean default true
929: ,p_style in varchar2 default hr_api.g_varchar2
930: ) is
931: --
932: l_rec per_add_shd.g_rec_type;
933: l_proc varchar2(72) := g_package||'upd';

Line 948: -- hr_api.g_number,

944: p_address_id,
945: -- 70.2 change a start.
946: p_business_group_id,
947: p_person_id,
948: -- hr_api.g_number,
949: -- hr_api.g_number,
950: p_date_from,
951: -- Start of fix for Bug #2431588
952: p_primary_flag,

Line 949: -- hr_api.g_number,

945: -- 70.2 change a start.
946: p_business_group_id,
947: p_person_id,
948: -- hr_api.g_number,
949: -- hr_api.g_number,
950: p_date_from,
951: -- Start of fix for Bug #2431588
952: p_primary_flag,
953: -- End of fix for Bug #2431588