APPS.HR_LOC_UPD dependencies on HR_API

Line 163: WHEN hr_api.check_integrity_violated THEN

159: --
160: hr_utility.set_location(' Leaving:'||l_proc, 10);
161: --
162: EXCEPTION
163: WHEN hr_api.check_integrity_violated THEN
164: -- A check constraint has been violated
165: hr_loc_shd.g_api_dml := false; -- Unset the api dml status
166: hr_loc_shd.constraint_error
167: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));

Line 167: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));

163: WHEN hr_api.check_integrity_violated THEN
164: -- A check constraint has been violated
165: hr_loc_shd.g_api_dml := false; -- Unset the api dml status
166: hr_loc_shd.constraint_error
167: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));
168: WHEN hr_api.parent_integrity_violated THEN
169: -- Parent integrity has been violated
170: hr_loc_shd.g_api_dml := false; -- Unset the api dml status
171: hr_loc_shd.constraint_error

Line 168: WHEN hr_api.parent_integrity_violated THEN

164: -- A check constraint has been violated
165: hr_loc_shd.g_api_dml := false; -- Unset the api dml status
166: hr_loc_shd.constraint_error
167: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));
168: WHEN hr_api.parent_integrity_violated THEN
169: -- Parent integrity has been violated
170: hr_loc_shd.g_api_dml := false; -- Unset the api dml status
171: hr_loc_shd.constraint_error
172: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));

Line 172: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));

168: WHEN hr_api.parent_integrity_violated THEN
169: -- Parent integrity has been violated
170: hr_loc_shd.g_api_dml := false; -- Unset the api dml status
171: hr_loc_shd.constraint_error
172: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));
173: WHEN hr_api.unique_integrity_violated THEN
174: -- Unique integrity has been violated
175: hr_loc_shd.g_api_dml := false; -- Unset the api dml status
176: hr_loc_shd.constraint_error

Line 173: WHEN hr_api.unique_integrity_violated THEN

169: -- Parent integrity has been violated
170: hr_loc_shd.g_api_dml := false; -- Unset the api dml status
171: hr_loc_shd.constraint_error
172: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));
173: WHEN hr_api.unique_integrity_violated THEN
174: -- Unique integrity has been violated
175: hr_loc_shd.g_api_dml := false; -- Unset the api dml status
176: hr_loc_shd.constraint_error
177: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));

Line 177: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));

173: WHEN hr_api.unique_integrity_violated THEN
174: -- Unique integrity has been violated
175: hr_loc_shd.g_api_dml := false; -- Unset the api dml status
176: hr_loc_shd.constraint_error
177: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));
178: WHEN OTHERS THEN
179: hr_loc_shd.g_api_dml := false; -- Unset the api dml status
180: RAISE;
181: END update_dml;

Line 479: WHEN hr_api.cannot_find_prog_unit THEN

475: ,p_object_version_number_o => hr_loc_shd.g_old_rec.object_version_number
476: ,p_business_group_id_o => hr_loc_shd.g_old_rec.business_group_id
477: );
478: EXCEPTION
479: WHEN hr_api.cannot_find_prog_unit THEN
480: hr_api.cannot_find_prog_unit_error
481: (p_module_name => 'HR_LOCATIONS_ALL'
482: ,p_hook_type => 'AU'
483: );

Line 480: hr_api.cannot_find_prog_unit_error

476: ,p_business_group_id_o => hr_loc_shd.g_old_rec.business_group_id
477: );
478: EXCEPTION
479: WHEN hr_api.cannot_find_prog_unit THEN
480: hr_api.cannot_find_prog_unit_error
481: (p_module_name => 'HR_LOCATIONS_ALL'
482: ,p_hook_type => 'AU'
483: );
484: --

Line 547: IF (p_rec.entered_by = hr_api.g_number) THEN

543: -- p_rec plsql record structure
544: -- to see if a system default is being used. If a system default
545: -- is being used then we must set to the 'current' argument value.
546: --
547: IF (p_rec.entered_by = hr_api.g_number) THEN
548: p_rec.entered_by :=
549: hr_loc_shd.g_old_rec.entered_by;
550: END IF;
551: IF (p_rec.location_code = hr_api.g_varchar2) THEN

Line 551: IF (p_rec.location_code = hr_api.g_varchar2) THEN

547: IF (p_rec.entered_by = hr_api.g_number) THEN
548: p_rec.entered_by :=
549: hr_loc_shd.g_old_rec.entered_by;
550: END IF;
551: IF (p_rec.location_code = hr_api.g_varchar2) THEN
552: p_rec.location_code :=
553: hr_loc_shd.g_old_rec.location_code;
554: END IF;
555: IF (p_rec.address_line_1 = hr_api.g_varchar2) THEN

Line 555: IF (p_rec.address_line_1 = hr_api.g_varchar2) THEN

551: IF (p_rec.location_code = hr_api.g_varchar2) THEN
552: p_rec.location_code :=
553: hr_loc_shd.g_old_rec.location_code;
554: END IF;
555: IF (p_rec.address_line_1 = hr_api.g_varchar2) THEN
556: p_rec.address_line_1 :=
557: hr_loc_shd.g_old_rec.address_line_1;
558: END IF;
559: IF (p_rec.address_line_2 = hr_api.g_varchar2) THEN

Line 559: IF (p_rec.address_line_2 = hr_api.g_varchar2) THEN

555: IF (p_rec.address_line_1 = hr_api.g_varchar2) THEN
556: p_rec.address_line_1 :=
557: hr_loc_shd.g_old_rec.address_line_1;
558: END IF;
559: IF (p_rec.address_line_2 = hr_api.g_varchar2) THEN
560: p_rec.address_line_2 :=
561: hr_loc_shd.g_old_rec.address_line_2;
562: END IF;
563: IF (p_rec.address_line_3 = hr_api.g_varchar2) THEN

Line 563: IF (p_rec.address_line_3 = hr_api.g_varchar2) THEN

559: IF (p_rec.address_line_2 = hr_api.g_varchar2) THEN
560: p_rec.address_line_2 :=
561: hr_loc_shd.g_old_rec.address_line_2;
562: END IF;
563: IF (p_rec.address_line_3 = hr_api.g_varchar2) THEN
564: p_rec.address_line_3 :=
565: hr_loc_shd.g_old_rec.address_line_3;
566: END IF;
567: IF (p_rec.bill_to_site_flag = hr_api.g_varchar2) THEN

Line 567: IF (p_rec.bill_to_site_flag = hr_api.g_varchar2) THEN

563: IF (p_rec.address_line_3 = hr_api.g_varchar2) THEN
564: p_rec.address_line_3 :=
565: hr_loc_shd.g_old_rec.address_line_3;
566: END IF;
567: IF (p_rec.bill_to_site_flag = hr_api.g_varchar2) THEN
568: p_rec.bill_to_site_flag :=
569: hr_loc_shd.g_old_rec.bill_to_site_flag;
570: END IF;
571: IF (p_rec.country = hr_api.g_varchar2) THEN

Line 571: IF (p_rec.country = hr_api.g_varchar2) THEN

567: IF (p_rec.bill_to_site_flag = hr_api.g_varchar2) THEN
568: p_rec.bill_to_site_flag :=
569: hr_loc_shd.g_old_rec.bill_to_site_flag;
570: END IF;
571: IF (p_rec.country = hr_api.g_varchar2) THEN
572: p_rec.country :=
573: hr_loc_shd.g_old_rec.country;
574: END IF;
575: IF (p_rec.description = hr_api.g_varchar2) THEN

Line 575: IF (p_rec.description = hr_api.g_varchar2) THEN

571: IF (p_rec.country = hr_api.g_varchar2) THEN
572: p_rec.country :=
573: hr_loc_shd.g_old_rec.country;
574: END IF;
575: IF (p_rec.description = hr_api.g_varchar2) THEN
576: p_rec.description :=
577: hr_loc_shd.g_old_rec.description;
578: END IF;
579: IF (p_rec.designated_receiver_id = hr_api.g_number) THEN

Line 579: IF (p_rec.designated_receiver_id = hr_api.g_number) THEN

575: IF (p_rec.description = hr_api.g_varchar2) THEN
576: p_rec.description :=
577: hr_loc_shd.g_old_rec.description;
578: END IF;
579: IF (p_rec.designated_receiver_id = hr_api.g_number) THEN
580: p_rec.designated_receiver_id :=
581: hr_loc_shd.g_old_rec.designated_receiver_id;
582: END IF;
583: IF (p_rec.in_organization_flag = hr_api.g_varchar2) THEN

Line 583: IF (p_rec.in_organization_flag = hr_api.g_varchar2) THEN

579: IF (p_rec.designated_receiver_id = hr_api.g_number) THEN
580: p_rec.designated_receiver_id :=
581: hr_loc_shd.g_old_rec.designated_receiver_id;
582: END IF;
583: IF (p_rec.in_organization_flag = hr_api.g_varchar2) THEN
584: p_rec.in_organization_flag :=
585: hr_loc_shd.g_old_rec.in_organization_flag;
586: END IF;
587: IF (p_rec.inactive_date = hr_api.g_date) THEN

Line 587: IF (p_rec.inactive_date = hr_api.g_date) THEN

583: IF (p_rec.in_organization_flag = hr_api.g_varchar2) THEN
584: p_rec.in_organization_flag :=
585: hr_loc_shd.g_old_rec.in_organization_flag;
586: END IF;
587: IF (p_rec.inactive_date = hr_api.g_date) THEN
588: p_rec.inactive_date :=
589: hr_loc_shd.g_old_rec.inactive_date;
590: END IF;
591: IF (p_rec.inventory_organization_id = hr_api.g_number) THEN

Line 591: IF (p_rec.inventory_organization_id = hr_api.g_number) THEN

587: IF (p_rec.inactive_date = hr_api.g_date) THEN
588: p_rec.inactive_date :=
589: hr_loc_shd.g_old_rec.inactive_date;
590: END IF;
591: IF (p_rec.inventory_organization_id = hr_api.g_number) THEN
592: p_rec.inventory_organization_id :=
593: hr_loc_shd.g_old_rec.inventory_organization_id;
594: END IF;
595: IF (p_rec.office_site_flag = hr_api.g_varchar2) THEN

Line 595: IF (p_rec.office_site_flag = hr_api.g_varchar2) THEN

591: IF (p_rec.inventory_organization_id = hr_api.g_number) THEN
592: p_rec.inventory_organization_id :=
593: hr_loc_shd.g_old_rec.inventory_organization_id;
594: END IF;
595: IF (p_rec.office_site_flag = hr_api.g_varchar2) THEN
596: p_rec.office_site_flag :=
597: hr_loc_shd.g_old_rec.office_site_flag;
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.office_site_flag = hr_api.g_varchar2) THEN
596: p_rec.office_site_flag :=
597: hr_loc_shd.g_old_rec.office_site_flag;
598: END IF;
599: IF (p_rec.postal_code = hr_api.g_varchar2) THEN
600: p_rec.postal_code :=
601: hr_loc_shd.g_old_rec.postal_code;
602: END IF;
603: IF (p_rec.receiving_site_flag = hr_api.g_varchar2) THEN

Line 603: IF (p_rec.receiving_site_flag = hr_api.g_varchar2) THEN

599: IF (p_rec.postal_code = hr_api.g_varchar2) THEN
600: p_rec.postal_code :=
601: hr_loc_shd.g_old_rec.postal_code;
602: END IF;
603: IF (p_rec.receiving_site_flag = hr_api.g_varchar2) THEN
604: p_rec.receiving_site_flag :=
605: hr_loc_shd.g_old_rec.receiving_site_flag;
606: END IF;
607: IF (p_rec.region_1 = hr_api.g_varchar2) THEN

Line 607: IF (p_rec.region_1 = hr_api.g_varchar2) THEN

603: IF (p_rec.receiving_site_flag = hr_api.g_varchar2) THEN
604: p_rec.receiving_site_flag :=
605: hr_loc_shd.g_old_rec.receiving_site_flag;
606: END IF;
607: IF (p_rec.region_1 = hr_api.g_varchar2) THEN
608: p_rec.region_1 :=
609: hr_loc_shd.g_old_rec.region_1;
610: END IF;
611: IF (p_rec.region_2 = hr_api.g_varchar2) THEN

Line 611: IF (p_rec.region_2 = hr_api.g_varchar2) THEN

607: IF (p_rec.region_1 = hr_api.g_varchar2) THEN
608: p_rec.region_1 :=
609: hr_loc_shd.g_old_rec.region_1;
610: END IF;
611: IF (p_rec.region_2 = hr_api.g_varchar2) THEN
612: p_rec.region_2 :=
613: hr_loc_shd.g_old_rec.region_2;
614: END IF;
615: IF (p_rec.region_3 = hr_api.g_varchar2) THEN

Line 615: IF (p_rec.region_3 = hr_api.g_varchar2) THEN

611: IF (p_rec.region_2 = hr_api.g_varchar2) THEN
612: p_rec.region_2 :=
613: hr_loc_shd.g_old_rec.region_2;
614: END IF;
615: IF (p_rec.region_3 = hr_api.g_varchar2) THEN
616: p_rec.region_3 :=
617: hr_loc_shd.g_old_rec.region_3;
618: END IF;
619: IF (p_rec.ship_to_location_id = hr_api.g_number) THEN

Line 619: IF (p_rec.ship_to_location_id = hr_api.g_number) THEN

615: IF (p_rec.region_3 = hr_api.g_varchar2) THEN
616: p_rec.region_3 :=
617: hr_loc_shd.g_old_rec.region_3;
618: END IF;
619: IF (p_rec.ship_to_location_id = hr_api.g_number) THEN
620: p_rec.ship_to_location_id :=
621: hr_loc_shd.g_old_rec.ship_to_location_id;
622: END IF;
623: IF (p_rec.ship_to_site_flag = hr_api.g_varchar2) THEN

Line 623: IF (p_rec.ship_to_site_flag = hr_api.g_varchar2) THEN

619: IF (p_rec.ship_to_location_id = hr_api.g_number) THEN
620: p_rec.ship_to_location_id :=
621: hr_loc_shd.g_old_rec.ship_to_location_id;
622: END IF;
623: IF (p_rec.ship_to_site_flag = hr_api.g_varchar2) THEN
624: p_rec.ship_to_site_flag :=
625: hr_loc_shd.g_old_rec.ship_to_site_flag;
626: END IF;
627: IF (p_rec.style = hr_api.g_varchar2) THEN

Line 627: IF (p_rec.style = hr_api.g_varchar2) THEN

623: IF (p_rec.ship_to_site_flag = hr_api.g_varchar2) THEN
624: p_rec.ship_to_site_flag :=
625: hr_loc_shd.g_old_rec.ship_to_site_flag;
626: END IF;
627: IF (p_rec.style = hr_api.g_varchar2) THEN
628: p_rec.style :=
629: hr_loc_shd.g_old_rec.style;
630: END IF;
631: IF (p_rec.tax_name = hr_api.g_varchar2) THEN

Line 631: IF (p_rec.tax_name = hr_api.g_varchar2) THEN

627: IF (p_rec.style = hr_api.g_varchar2) THEN
628: p_rec.style :=
629: hr_loc_shd.g_old_rec.style;
630: END IF;
631: IF (p_rec.tax_name = hr_api.g_varchar2) THEN
632: p_rec.tax_name :=
633: hr_loc_shd.g_old_rec.tax_name;
634: END IF;
635: IF (p_rec.telephone_number_1 = hr_api.g_varchar2) THEN

Line 635: IF (p_rec.telephone_number_1 = hr_api.g_varchar2) THEN

631: IF (p_rec.tax_name = hr_api.g_varchar2) THEN
632: p_rec.tax_name :=
633: hr_loc_shd.g_old_rec.tax_name;
634: END IF;
635: IF (p_rec.telephone_number_1 = hr_api.g_varchar2) THEN
636: p_rec.telephone_number_1 :=
637: hr_loc_shd.g_old_rec.telephone_number_1;
638: END IF;
639: IF (p_rec.telephone_number_2 = hr_api.g_varchar2) THEN

Line 639: IF (p_rec.telephone_number_2 = hr_api.g_varchar2) THEN

635: IF (p_rec.telephone_number_1 = hr_api.g_varchar2) THEN
636: p_rec.telephone_number_1 :=
637: hr_loc_shd.g_old_rec.telephone_number_1;
638: END IF;
639: IF (p_rec.telephone_number_2 = hr_api.g_varchar2) THEN
640: p_rec.telephone_number_2 :=
641: hr_loc_shd.g_old_rec.telephone_number_2;
642: END IF;
643: IF (p_rec.telephone_number_3 = hr_api.g_varchar2) THEN

Line 643: IF (p_rec.telephone_number_3 = hr_api.g_varchar2) THEN

639: IF (p_rec.telephone_number_2 = hr_api.g_varchar2) THEN
640: p_rec.telephone_number_2 :=
641: hr_loc_shd.g_old_rec.telephone_number_2;
642: END IF;
643: IF (p_rec.telephone_number_3 = hr_api.g_varchar2) THEN
644: p_rec.telephone_number_3 :=
645: hr_loc_shd.g_old_rec.telephone_number_3;
646: END IF;
647: IF (p_rec.town_or_city = hr_api.g_varchar2) THEN

Line 647: IF (p_rec.town_or_city = hr_api.g_varchar2) THEN

643: IF (p_rec.telephone_number_3 = hr_api.g_varchar2) THEN
644: p_rec.telephone_number_3 :=
645: hr_loc_shd.g_old_rec.telephone_number_3;
646: END IF;
647: IF (p_rec.town_or_city = hr_api.g_varchar2) THEN
648: p_rec.town_or_city :=
649: hr_loc_shd.g_old_rec.town_or_city;
650: END IF;
651: IF (p_rec.loc_information13 = hr_api.g_varchar2) THEN

Line 651: IF (p_rec.loc_information13 = hr_api.g_varchar2) THEN

647: IF (p_rec.town_or_city = hr_api.g_varchar2) THEN
648: p_rec.town_or_city :=
649: hr_loc_shd.g_old_rec.town_or_city;
650: END IF;
651: IF (p_rec.loc_information13 = hr_api.g_varchar2) THEN
652: p_rec.loc_information13 :=
653: hr_loc_shd.g_old_rec.loc_information13;
654: END IF;
655: IF (p_rec.loc_information14 = hr_api.g_varchar2) THEN

Line 655: IF (p_rec.loc_information14 = hr_api.g_varchar2) THEN

651: IF (p_rec.loc_information13 = hr_api.g_varchar2) THEN
652: p_rec.loc_information13 :=
653: hr_loc_shd.g_old_rec.loc_information13;
654: END IF;
655: IF (p_rec.loc_information14 = hr_api.g_varchar2) THEN
656: p_rec.loc_information14 :=
657: hr_loc_shd.g_old_rec.loc_information14;
658: END IF;
659: IF (p_rec.loc_information15 = hr_api.g_varchar2) THEN

Line 659: IF (p_rec.loc_information15 = hr_api.g_varchar2) THEN

655: IF (p_rec.loc_information14 = hr_api.g_varchar2) THEN
656: p_rec.loc_information14 :=
657: hr_loc_shd.g_old_rec.loc_information14;
658: END IF;
659: IF (p_rec.loc_information15 = hr_api.g_varchar2) THEN
660: p_rec.loc_information15 :=
661: hr_loc_shd.g_old_rec.loc_information15;
662: END IF;
663: IF (p_rec.loc_information16 = hr_api.g_varchar2) THEN

Line 663: IF (p_rec.loc_information16 = hr_api.g_varchar2) THEN

659: IF (p_rec.loc_information15 = hr_api.g_varchar2) THEN
660: p_rec.loc_information15 :=
661: hr_loc_shd.g_old_rec.loc_information15;
662: END IF;
663: IF (p_rec.loc_information16 = hr_api.g_varchar2) THEN
664: p_rec.loc_information16 :=
665: hr_loc_shd.g_old_rec.loc_information16;
666: END IF;
667: IF (p_rec.loc_information17 = hr_api.g_varchar2) THEN

Line 667: IF (p_rec.loc_information17 = hr_api.g_varchar2) THEN

663: IF (p_rec.loc_information16 = hr_api.g_varchar2) THEN
664: p_rec.loc_information16 :=
665: hr_loc_shd.g_old_rec.loc_information16;
666: END IF;
667: IF (p_rec.loc_information17 = hr_api.g_varchar2) THEN
668: p_rec.loc_information17 :=
669: hr_loc_shd.g_old_rec.loc_information17;
670: END IF;
671: IF (p_rec.loc_information18 = hr_api.g_varchar2) THEN

Line 671: IF (p_rec.loc_information18 = hr_api.g_varchar2) THEN

667: IF (p_rec.loc_information17 = hr_api.g_varchar2) THEN
668: p_rec.loc_information17 :=
669: hr_loc_shd.g_old_rec.loc_information17;
670: END IF;
671: IF (p_rec.loc_information18 = hr_api.g_varchar2) THEN
672: p_rec.loc_information18 :=
673: hr_loc_shd.g_old_rec.loc_information18;
674: END IF;
675: IF (p_rec.loc_information19 = hr_api.g_varchar2) THEN

Line 675: IF (p_rec.loc_information19 = hr_api.g_varchar2) THEN

671: IF (p_rec.loc_information18 = hr_api.g_varchar2) THEN
672: p_rec.loc_information18 :=
673: hr_loc_shd.g_old_rec.loc_information18;
674: END IF;
675: IF (p_rec.loc_information19 = hr_api.g_varchar2) THEN
676: p_rec.loc_information19 :=
677: hr_loc_shd.g_old_rec.loc_information19;
678: END IF;
679: IF (p_rec.loc_information20 = hr_api.g_varchar2) THEN

Line 679: IF (p_rec.loc_information20 = hr_api.g_varchar2) THEN

675: IF (p_rec.loc_information19 = hr_api.g_varchar2) THEN
676: p_rec.loc_information19 :=
677: hr_loc_shd.g_old_rec.loc_information19;
678: END IF;
679: IF (p_rec.loc_information20 = hr_api.g_varchar2) THEN
680: p_rec.loc_information20 :=
681: hr_loc_shd.g_old_rec.loc_information20;
682: END IF;
683: IF (p_rec.attribute_category = hr_api.g_varchar2) THEN

Line 683: IF (p_rec.attribute_category = hr_api.g_varchar2) THEN

679: IF (p_rec.loc_information20 = hr_api.g_varchar2) THEN
680: p_rec.loc_information20 :=
681: hr_loc_shd.g_old_rec.loc_information20;
682: END IF;
683: IF (p_rec.attribute_category = hr_api.g_varchar2) THEN
684: p_rec.attribute_category :=
685: hr_loc_shd.g_old_rec.attribute_category;
686: END IF;
687: IF (p_rec.attribute1 = hr_api.g_varchar2) THEN

Line 687: IF (p_rec.attribute1 = hr_api.g_varchar2) THEN

683: IF (p_rec.attribute_category = hr_api.g_varchar2) THEN
684: p_rec.attribute_category :=
685: hr_loc_shd.g_old_rec.attribute_category;
686: END IF;
687: IF (p_rec.attribute1 = hr_api.g_varchar2) THEN
688: p_rec.attribute1 :=
689: hr_loc_shd.g_old_rec.attribute1;
690: END IF;
691: IF (p_rec.attribute2 = hr_api.g_varchar2) THEN

Line 691: IF (p_rec.attribute2 = hr_api.g_varchar2) THEN

687: IF (p_rec.attribute1 = hr_api.g_varchar2) THEN
688: p_rec.attribute1 :=
689: hr_loc_shd.g_old_rec.attribute1;
690: END IF;
691: IF (p_rec.attribute2 = hr_api.g_varchar2) THEN
692: p_rec.attribute2 :=
693: hr_loc_shd.g_old_rec.attribute2;
694: END IF;
695: IF (p_rec.attribute3 = hr_api.g_varchar2) THEN

Line 695: IF (p_rec.attribute3 = hr_api.g_varchar2) THEN

691: IF (p_rec.attribute2 = hr_api.g_varchar2) THEN
692: p_rec.attribute2 :=
693: hr_loc_shd.g_old_rec.attribute2;
694: END IF;
695: IF (p_rec.attribute3 = hr_api.g_varchar2) THEN
696: p_rec.attribute3 :=
697: hr_loc_shd.g_old_rec.attribute3;
698: END IF;
699: IF (p_rec.attribute4 = hr_api.g_varchar2) THEN

Line 699: IF (p_rec.attribute4 = hr_api.g_varchar2) THEN

695: IF (p_rec.attribute3 = hr_api.g_varchar2) THEN
696: p_rec.attribute3 :=
697: hr_loc_shd.g_old_rec.attribute3;
698: END IF;
699: IF (p_rec.attribute4 = hr_api.g_varchar2) THEN
700: p_rec.attribute4 :=
701: hr_loc_shd.g_old_rec.attribute4;
702: END IF;
703: IF (p_rec.attribute5 = hr_api.g_varchar2) THEN

Line 703: IF (p_rec.attribute5 = hr_api.g_varchar2) THEN

699: IF (p_rec.attribute4 = hr_api.g_varchar2) THEN
700: p_rec.attribute4 :=
701: hr_loc_shd.g_old_rec.attribute4;
702: END IF;
703: IF (p_rec.attribute5 = hr_api.g_varchar2) THEN
704: p_rec.attribute5 :=
705: hr_loc_shd.g_old_rec.attribute5;
706: END IF;
707: IF (p_rec.attribute6 = hr_api.g_varchar2) THEN

Line 707: IF (p_rec.attribute6 = hr_api.g_varchar2) THEN

703: IF (p_rec.attribute5 = hr_api.g_varchar2) THEN
704: p_rec.attribute5 :=
705: hr_loc_shd.g_old_rec.attribute5;
706: END IF;
707: IF (p_rec.attribute6 = hr_api.g_varchar2) THEN
708: p_rec.attribute6 :=
709: hr_loc_shd.g_old_rec.attribute6;
710: END IF;
711: IF (p_rec.attribute7 = hr_api.g_varchar2) THEN

Line 711: IF (p_rec.attribute7 = hr_api.g_varchar2) THEN

707: IF (p_rec.attribute6 = hr_api.g_varchar2) THEN
708: p_rec.attribute6 :=
709: hr_loc_shd.g_old_rec.attribute6;
710: END IF;
711: IF (p_rec.attribute7 = hr_api.g_varchar2) THEN
712: p_rec.attribute7 :=
713: hr_loc_shd.g_old_rec.attribute7;
714: END IF;
715: IF (p_rec.attribute8 = hr_api.g_varchar2) THEN

Line 715: IF (p_rec.attribute8 = hr_api.g_varchar2) THEN

711: IF (p_rec.attribute7 = hr_api.g_varchar2) THEN
712: p_rec.attribute7 :=
713: hr_loc_shd.g_old_rec.attribute7;
714: END IF;
715: IF (p_rec.attribute8 = hr_api.g_varchar2) THEN
716: p_rec.attribute8 :=
717: hr_loc_shd.g_old_rec.attribute8;
718: END IF;
719: IF (p_rec.attribute9 = hr_api.g_varchar2) THEN

Line 719: IF (p_rec.attribute9 = hr_api.g_varchar2) THEN

715: IF (p_rec.attribute8 = hr_api.g_varchar2) THEN
716: p_rec.attribute8 :=
717: hr_loc_shd.g_old_rec.attribute8;
718: END IF;
719: IF (p_rec.attribute9 = hr_api.g_varchar2) THEN
720: p_rec.attribute9 :=
721: hr_loc_shd.g_old_rec.attribute9;
722: END IF;
723: IF (p_rec.attribute10 = hr_api.g_varchar2) THEN

Line 723: IF (p_rec.attribute10 = hr_api.g_varchar2) THEN

719: IF (p_rec.attribute9 = hr_api.g_varchar2) THEN
720: p_rec.attribute9 :=
721: hr_loc_shd.g_old_rec.attribute9;
722: END IF;
723: IF (p_rec.attribute10 = hr_api.g_varchar2) THEN
724: p_rec.attribute10 :=
725: hr_loc_shd.g_old_rec.attribute10;
726: END IF;
727: IF (p_rec.attribute11 = hr_api.g_varchar2) THEN

Line 727: IF (p_rec.attribute11 = hr_api.g_varchar2) THEN

723: IF (p_rec.attribute10 = hr_api.g_varchar2) THEN
724: p_rec.attribute10 :=
725: hr_loc_shd.g_old_rec.attribute10;
726: END IF;
727: IF (p_rec.attribute11 = hr_api.g_varchar2) THEN
728: p_rec.attribute11 :=
729: hr_loc_shd.g_old_rec.attribute11;
730: END IF;
731: IF (p_rec.attribute12 = hr_api.g_varchar2) THEN

Line 731: IF (p_rec.attribute12 = hr_api.g_varchar2) THEN

727: IF (p_rec.attribute11 = hr_api.g_varchar2) THEN
728: p_rec.attribute11 :=
729: hr_loc_shd.g_old_rec.attribute11;
730: END IF;
731: IF (p_rec.attribute12 = hr_api.g_varchar2) THEN
732: p_rec.attribute12 :=
733: hr_loc_shd.g_old_rec.attribute12;
734: END IF;
735: IF (p_rec.attribute13 = hr_api.g_varchar2) THEN

Line 735: IF (p_rec.attribute13 = hr_api.g_varchar2) THEN

731: IF (p_rec.attribute12 = hr_api.g_varchar2) THEN
732: p_rec.attribute12 :=
733: hr_loc_shd.g_old_rec.attribute12;
734: END IF;
735: IF (p_rec.attribute13 = hr_api.g_varchar2) THEN
736: p_rec.attribute13 :=
737: hr_loc_shd.g_old_rec.attribute13;
738: END IF;
739: IF (p_rec.attribute14 = hr_api.g_varchar2) THEN

Line 739: IF (p_rec.attribute14 = hr_api.g_varchar2) THEN

735: IF (p_rec.attribute13 = hr_api.g_varchar2) THEN
736: p_rec.attribute13 :=
737: hr_loc_shd.g_old_rec.attribute13;
738: END IF;
739: IF (p_rec.attribute14 = hr_api.g_varchar2) THEN
740: p_rec.attribute14 :=
741: hr_loc_shd.g_old_rec.attribute14;
742: END IF;
743: IF (p_rec.attribute15 = hr_api.g_varchar2) THEN

Line 743: IF (p_rec.attribute15 = hr_api.g_varchar2) THEN

739: IF (p_rec.attribute14 = hr_api.g_varchar2) THEN
740: p_rec.attribute14 :=
741: hr_loc_shd.g_old_rec.attribute14;
742: END IF;
743: IF (p_rec.attribute15 = hr_api.g_varchar2) THEN
744: p_rec.attribute15 :=
745: hr_loc_shd.g_old_rec.attribute15;
746: END IF;
747: IF (p_rec.attribute16 = hr_api.g_varchar2) THEN

Line 747: IF (p_rec.attribute16 = hr_api.g_varchar2) THEN

743: IF (p_rec.attribute15 = hr_api.g_varchar2) THEN
744: p_rec.attribute15 :=
745: hr_loc_shd.g_old_rec.attribute15;
746: END IF;
747: IF (p_rec.attribute16 = hr_api.g_varchar2) THEN
748: p_rec.attribute16 :=
749: hr_loc_shd.g_old_rec.attribute16;
750: END IF;
751: IF (p_rec.attribute17 = hr_api.g_varchar2) THEN

Line 751: IF (p_rec.attribute17 = hr_api.g_varchar2) THEN

747: IF (p_rec.attribute16 = hr_api.g_varchar2) THEN
748: p_rec.attribute16 :=
749: hr_loc_shd.g_old_rec.attribute16;
750: END IF;
751: IF (p_rec.attribute17 = hr_api.g_varchar2) THEN
752: p_rec.attribute17 :=
753: hr_loc_shd.g_old_rec.attribute17;
754: END IF;
755: IF (p_rec.attribute18 = hr_api.g_varchar2) THEN

Line 755: IF (p_rec.attribute18 = hr_api.g_varchar2) THEN

751: IF (p_rec.attribute17 = hr_api.g_varchar2) THEN
752: p_rec.attribute17 :=
753: hr_loc_shd.g_old_rec.attribute17;
754: END IF;
755: IF (p_rec.attribute18 = hr_api.g_varchar2) THEN
756: p_rec.attribute18 :=
757: hr_loc_shd.g_old_rec.attribute18;
758: END IF;
759: IF (p_rec.attribute19 = hr_api.g_varchar2) THEN

Line 759: IF (p_rec.attribute19 = hr_api.g_varchar2) THEN

755: IF (p_rec.attribute18 = hr_api.g_varchar2) THEN
756: p_rec.attribute18 :=
757: hr_loc_shd.g_old_rec.attribute18;
758: END IF;
759: IF (p_rec.attribute19 = hr_api.g_varchar2) THEN
760: p_rec.attribute19 :=
761: hr_loc_shd.g_old_rec.attribute19;
762: END IF;
763: IF (p_rec.attribute20 = hr_api.g_varchar2) THEN

Line 763: IF (p_rec.attribute20 = hr_api.g_varchar2) THEN

759: IF (p_rec.attribute19 = hr_api.g_varchar2) THEN
760: p_rec.attribute19 :=
761: hr_loc_shd.g_old_rec.attribute19;
762: END IF;
763: IF (p_rec.attribute20 = hr_api.g_varchar2) THEN
764: p_rec.attribute20 :=
765: hr_loc_shd.g_old_rec.attribute20;
766: END IF;
767: IF (p_rec.global_attribute_category = hr_api.g_varchar2) THEN

Line 767: IF (p_rec.global_attribute_category = hr_api.g_varchar2) THEN

763: IF (p_rec.attribute20 = hr_api.g_varchar2) THEN
764: p_rec.attribute20 :=
765: hr_loc_shd.g_old_rec.attribute20;
766: END IF;
767: IF (p_rec.global_attribute_category = hr_api.g_varchar2) THEN
768: p_rec.global_attribute_category :=
769: hr_loc_shd.g_old_rec.global_attribute_category;
770: END IF;
771: IF (p_rec.global_attribute1 = hr_api.g_varchar2) THEN

Line 771: IF (p_rec.global_attribute1 = hr_api.g_varchar2) THEN

767: IF (p_rec.global_attribute_category = hr_api.g_varchar2) THEN
768: p_rec.global_attribute_category :=
769: hr_loc_shd.g_old_rec.global_attribute_category;
770: END IF;
771: IF (p_rec.global_attribute1 = hr_api.g_varchar2) THEN
772: p_rec.global_attribute1 :=
773: hr_loc_shd.g_old_rec.global_attribute1;
774: END IF;
775: IF (p_rec.global_attribute2 = hr_api.g_varchar2) THEN

Line 775: IF (p_rec.global_attribute2 = hr_api.g_varchar2) THEN

771: IF (p_rec.global_attribute1 = hr_api.g_varchar2) THEN
772: p_rec.global_attribute1 :=
773: hr_loc_shd.g_old_rec.global_attribute1;
774: END IF;
775: IF (p_rec.global_attribute2 = hr_api.g_varchar2) THEN
776: p_rec.global_attribute2 :=
777: hr_loc_shd.g_old_rec.global_attribute2;
778: END IF;
779: IF (p_rec.global_attribute3 = hr_api.g_varchar2) THEN

Line 779: IF (p_rec.global_attribute3 = hr_api.g_varchar2) THEN

775: IF (p_rec.global_attribute2 = hr_api.g_varchar2) THEN
776: p_rec.global_attribute2 :=
777: hr_loc_shd.g_old_rec.global_attribute2;
778: END IF;
779: IF (p_rec.global_attribute3 = hr_api.g_varchar2) THEN
780: p_rec.global_attribute3 :=
781: hr_loc_shd.g_old_rec.global_attribute3;
782: END IF;
783: IF (p_rec.global_attribute4 = hr_api.g_varchar2) THEN

Line 783: IF (p_rec.global_attribute4 = hr_api.g_varchar2) THEN

779: IF (p_rec.global_attribute3 = hr_api.g_varchar2) THEN
780: p_rec.global_attribute3 :=
781: hr_loc_shd.g_old_rec.global_attribute3;
782: END IF;
783: IF (p_rec.global_attribute4 = hr_api.g_varchar2) THEN
784: p_rec.global_attribute4 :=
785: hr_loc_shd.g_old_rec.global_attribute4;
786: END IF;
787: IF (p_rec.global_attribute5 = hr_api.g_varchar2) THEN

Line 787: IF (p_rec.global_attribute5 = hr_api.g_varchar2) THEN

783: IF (p_rec.global_attribute4 = hr_api.g_varchar2) THEN
784: p_rec.global_attribute4 :=
785: hr_loc_shd.g_old_rec.global_attribute4;
786: END IF;
787: IF (p_rec.global_attribute5 = hr_api.g_varchar2) THEN
788: p_rec.global_attribute5 :=
789: hr_loc_shd.g_old_rec.global_attribute5;
790: END IF;
791: IF (p_rec.global_attribute6 = hr_api.g_varchar2) THEN

Line 791: IF (p_rec.global_attribute6 = hr_api.g_varchar2) THEN

787: IF (p_rec.global_attribute5 = hr_api.g_varchar2) THEN
788: p_rec.global_attribute5 :=
789: hr_loc_shd.g_old_rec.global_attribute5;
790: END IF;
791: IF (p_rec.global_attribute6 = hr_api.g_varchar2) THEN
792: p_rec.global_attribute6 :=
793: hr_loc_shd.g_old_rec.global_attribute6;
794: END IF;
795: IF (p_rec.global_attribute7 = hr_api.g_varchar2) THEN

Line 795: IF (p_rec.global_attribute7 = hr_api.g_varchar2) THEN

791: IF (p_rec.global_attribute6 = hr_api.g_varchar2) THEN
792: p_rec.global_attribute6 :=
793: hr_loc_shd.g_old_rec.global_attribute6;
794: END IF;
795: IF (p_rec.global_attribute7 = hr_api.g_varchar2) THEN
796: p_rec.global_attribute7 :=
797: hr_loc_shd.g_old_rec.global_attribute7;
798: END IF;
799: IF (p_rec.global_attribute8 = hr_api.g_varchar2) THEN

Line 799: IF (p_rec.global_attribute8 = hr_api.g_varchar2) THEN

795: IF (p_rec.global_attribute7 = hr_api.g_varchar2) THEN
796: p_rec.global_attribute7 :=
797: hr_loc_shd.g_old_rec.global_attribute7;
798: END IF;
799: IF (p_rec.global_attribute8 = hr_api.g_varchar2) THEN
800: p_rec.global_attribute8 :=
801: hr_loc_shd.g_old_rec.global_attribute8;
802: END IF;
803: IF (p_rec.global_attribute9 = hr_api.g_varchar2) THEN

Line 803: IF (p_rec.global_attribute9 = hr_api.g_varchar2) THEN

799: IF (p_rec.global_attribute8 = hr_api.g_varchar2) THEN
800: p_rec.global_attribute8 :=
801: hr_loc_shd.g_old_rec.global_attribute8;
802: END IF;
803: IF (p_rec.global_attribute9 = hr_api.g_varchar2) THEN
804: p_rec.global_attribute9 :=
805: hr_loc_shd.g_old_rec.global_attribute9;
806: END IF;
807: IF (p_rec.global_attribute10 = hr_api.g_varchar2) THEN

Line 807: IF (p_rec.global_attribute10 = hr_api.g_varchar2) THEN

803: IF (p_rec.global_attribute9 = hr_api.g_varchar2) THEN
804: p_rec.global_attribute9 :=
805: hr_loc_shd.g_old_rec.global_attribute9;
806: END IF;
807: IF (p_rec.global_attribute10 = hr_api.g_varchar2) THEN
808: p_rec.global_attribute10 :=
809: hr_loc_shd.g_old_rec.global_attribute10;
810: END IF;
811: IF (p_rec.global_attribute11 = hr_api.g_varchar2) THEN

Line 811: IF (p_rec.global_attribute11 = hr_api.g_varchar2) THEN

807: IF (p_rec.global_attribute10 = hr_api.g_varchar2) THEN
808: p_rec.global_attribute10 :=
809: hr_loc_shd.g_old_rec.global_attribute10;
810: END IF;
811: IF (p_rec.global_attribute11 = hr_api.g_varchar2) THEN
812: p_rec.global_attribute11 :=
813: hr_loc_shd.g_old_rec.global_attribute11;
814: END IF;
815: IF (p_rec.global_attribute12 = hr_api.g_varchar2) THEN

Line 815: IF (p_rec.global_attribute12 = hr_api.g_varchar2) THEN

811: IF (p_rec.global_attribute11 = hr_api.g_varchar2) THEN
812: p_rec.global_attribute11 :=
813: hr_loc_shd.g_old_rec.global_attribute11;
814: END IF;
815: IF (p_rec.global_attribute12 = hr_api.g_varchar2) THEN
816: p_rec.global_attribute12 :=
817: hr_loc_shd.g_old_rec.global_attribute12;
818: END IF;
819: IF (p_rec.global_attribute13 = hr_api.g_varchar2) THEN

Line 819: IF (p_rec.global_attribute13 = hr_api.g_varchar2) THEN

815: IF (p_rec.global_attribute12 = hr_api.g_varchar2) THEN
816: p_rec.global_attribute12 :=
817: hr_loc_shd.g_old_rec.global_attribute12;
818: END IF;
819: IF (p_rec.global_attribute13 = hr_api.g_varchar2) THEN
820: p_rec.global_attribute13 :=
821: hr_loc_shd.g_old_rec.global_attribute13;
822: END IF;
823: IF (p_rec.global_attribute14 = hr_api.g_varchar2) THEN

Line 823: IF (p_rec.global_attribute14 = hr_api.g_varchar2) THEN

819: IF (p_rec.global_attribute13 = hr_api.g_varchar2) THEN
820: p_rec.global_attribute13 :=
821: hr_loc_shd.g_old_rec.global_attribute13;
822: END IF;
823: IF (p_rec.global_attribute14 = hr_api.g_varchar2) THEN
824: p_rec.global_attribute14 :=
825: hr_loc_shd.g_old_rec.global_attribute14;
826: END IF;
827: IF (p_rec.global_attribute15 = hr_api.g_varchar2) THEN

Line 827: IF (p_rec.global_attribute15 = hr_api.g_varchar2) THEN

823: IF (p_rec.global_attribute14 = hr_api.g_varchar2) THEN
824: p_rec.global_attribute14 :=
825: hr_loc_shd.g_old_rec.global_attribute14;
826: END IF;
827: IF (p_rec.global_attribute15 = hr_api.g_varchar2) THEN
828: p_rec.global_attribute15 :=
829: hr_loc_shd.g_old_rec.global_attribute15;
830: END IF;
831: IF (p_rec.global_attribute16 = hr_api.g_varchar2) THEN

Line 831: IF (p_rec.global_attribute16 = hr_api.g_varchar2) THEN

827: IF (p_rec.global_attribute15 = hr_api.g_varchar2) THEN
828: p_rec.global_attribute15 :=
829: hr_loc_shd.g_old_rec.global_attribute15;
830: END IF;
831: IF (p_rec.global_attribute16 = hr_api.g_varchar2) THEN
832: p_rec.global_attribute16 :=
833: hr_loc_shd.g_old_rec.global_attribute16;
834: END IF;
835: IF (p_rec.global_attribute17 = hr_api.g_varchar2) THEN

Line 835: IF (p_rec.global_attribute17 = hr_api.g_varchar2) THEN

831: IF (p_rec.global_attribute16 = hr_api.g_varchar2) THEN
832: p_rec.global_attribute16 :=
833: hr_loc_shd.g_old_rec.global_attribute16;
834: END IF;
835: IF (p_rec.global_attribute17 = hr_api.g_varchar2) THEN
836: p_rec.global_attribute17 :=
837: hr_loc_shd.g_old_rec.global_attribute17;
838: END IF;
839: IF (p_rec.global_attribute18 = hr_api.g_varchar2) THEN

Line 839: IF (p_rec.global_attribute18 = hr_api.g_varchar2) THEN

835: IF (p_rec.global_attribute17 = hr_api.g_varchar2) THEN
836: p_rec.global_attribute17 :=
837: hr_loc_shd.g_old_rec.global_attribute17;
838: END IF;
839: IF (p_rec.global_attribute18 = hr_api.g_varchar2) THEN
840: p_rec.global_attribute18 :=
841: hr_loc_shd.g_old_rec.global_attribute18;
842: END IF;
843: IF (p_rec.global_attribute19 = hr_api.g_varchar2) THEN

Line 843: IF (p_rec.global_attribute19 = hr_api.g_varchar2) THEN

839: IF (p_rec.global_attribute18 = hr_api.g_varchar2) THEN
840: p_rec.global_attribute18 :=
841: hr_loc_shd.g_old_rec.global_attribute18;
842: END IF;
843: IF (p_rec.global_attribute19 = hr_api.g_varchar2) THEN
844: p_rec.global_attribute19 :=
845: hr_loc_shd.g_old_rec.global_attribute19;
846: END IF;
847: IF (p_rec.global_attribute20 = hr_api.g_varchar2) THEN

Line 847: IF (p_rec.global_attribute20 = hr_api.g_varchar2) THEN

843: IF (p_rec.global_attribute19 = hr_api.g_varchar2) THEN
844: p_rec.global_attribute19 :=
845: hr_loc_shd.g_old_rec.global_attribute19;
846: END IF;
847: IF (p_rec.global_attribute20 = hr_api.g_varchar2) THEN
848: p_rec.global_attribute20 :=
849: hr_loc_shd.g_old_rec.global_attribute20;
850: END IF;
851: IF (p_rec.legal_address_flag = hr_api.g_varchar2) THEN

Line 851: IF (p_rec.legal_address_flag = hr_api.g_varchar2) THEN

847: IF (p_rec.global_attribute20 = hr_api.g_varchar2) THEN
848: p_rec.global_attribute20 :=
849: hr_loc_shd.g_old_rec.global_attribute20;
850: END IF;
851: IF (p_rec.legal_address_flag = hr_api.g_varchar2) THEN
852: p_rec.legal_address_flag :=
853: hr_loc_shd.g_old_rec.legal_address_flag;
854: END IF;
855: IF (p_rec.tp_header_id = hr_api.g_number) THEN

Line 855: IF (p_rec.tp_header_id = hr_api.g_number) THEN

851: IF (p_rec.legal_address_flag = hr_api.g_varchar2) THEN
852: p_rec.legal_address_flag :=
853: hr_loc_shd.g_old_rec.legal_address_flag;
854: END IF;
855: IF (p_rec.tp_header_id = hr_api.g_number) THEN
856: p_rec.tp_header_id :=
857: hr_loc_shd.g_old_rec.tp_header_id;
858: END IF;
859: IF (p_rec.ece_tp_location_code = hr_api.g_varchar2) THEN

Line 859: IF (p_rec.ece_tp_location_code = hr_api.g_varchar2) THEN

855: IF (p_rec.tp_header_id = hr_api.g_number) THEN
856: p_rec.tp_header_id :=
857: hr_loc_shd.g_old_rec.tp_header_id;
858: END IF;
859: IF (p_rec.ece_tp_location_code = hr_api.g_varchar2) THEN
860: p_rec.ece_tp_location_code :=
861: hr_loc_shd.g_old_rec.ece_tp_location_code;
862: END IF;
863: IF (p_rec.business_group_id = hr_api.g_number) THEN

Line 863: IF (p_rec.business_group_id = hr_api.g_number) THEN

859: IF (p_rec.ece_tp_location_code = hr_api.g_varchar2) THEN
860: p_rec.ece_tp_location_code :=
861: hr_loc_shd.g_old_rec.ece_tp_location_code;
862: END IF;
863: IF (p_rec.business_group_id = hr_api.g_number) THEN
864: p_rec.business_group_id :=
865: hr_loc_shd.g_old_rec.business_group_id;
866: END IF;
867: -- Fix 3286235

Line 868: IF (p_rec.timezone_code = hr_api.g_varchar2) THEN

864: p_rec.business_group_id :=
865: hr_loc_shd.g_old_rec.business_group_id;
866: END IF;
867: -- Fix 3286235
868: IF (p_rec.timezone_code = hr_api.g_varchar2) THEN
869: p_rec.timezone_code :=
870: hr_loc_shd.g_old_rec.timezone_code;
871: END IF;
872: -- End Fix 3286235

Line 936: p_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,

932: (
933: p_effective_date IN DATE,
934: p_location_id IN NUMBER,
935: p_object_version_number IN OUT NOCOPY NUMBER,
936: p_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
937: p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
938: p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
939: p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
940: p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 937: p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,

933: p_effective_date IN DATE,
934: p_location_id IN NUMBER,
935: p_object_version_number IN OUT NOCOPY NUMBER,
936: p_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
937: p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
938: p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
939: p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
940: p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
941: p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 938: p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

934: p_location_id IN NUMBER,
935: p_object_version_number IN OUT NOCOPY NUMBER,
936: p_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
937: p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
938: p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
939: p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
940: p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
941: p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
942: p_country IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 939: p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

935: p_object_version_number IN OUT NOCOPY NUMBER,
936: p_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
937: p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
938: p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
939: p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
940: p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
941: p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
942: p_country IN VARCHAR2 DEFAULT hr_api.g_varchar2,
943: p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 940: p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

936: p_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
937: p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
938: p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
939: p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
940: p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
941: p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
942: p_country IN VARCHAR2 DEFAULT hr_api.g_varchar2,
943: p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2,
944: p_designated_receiver_id IN NUMBER DEFAULT hr_api.g_number,

Line 941: p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,

937: p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
938: p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
939: p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
940: p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
941: p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
942: p_country IN VARCHAR2 DEFAULT hr_api.g_varchar2,
943: p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2,
944: p_designated_receiver_id IN NUMBER DEFAULT hr_api.g_number,
945: p_in_organization_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 942: p_country IN VARCHAR2 DEFAULT hr_api.g_varchar2,

938: p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
939: p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
940: p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
941: p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
942: p_country IN VARCHAR2 DEFAULT hr_api.g_varchar2,
943: p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2,
944: p_designated_receiver_id IN NUMBER DEFAULT hr_api.g_number,
945: p_in_organization_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
946: p_inactive_date IN DATE DEFAULT hr_api.g_date,

Line 943: p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2,

939: p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
940: p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
941: p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
942: p_country IN VARCHAR2 DEFAULT hr_api.g_varchar2,
943: p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2,
944: p_designated_receiver_id IN NUMBER DEFAULT hr_api.g_number,
945: p_in_organization_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
946: p_inactive_date IN DATE DEFAULT hr_api.g_date,
947: p_operating_unit_id IN NUMBER DEFAULT NULL,

Line 944: p_designated_receiver_id IN NUMBER DEFAULT hr_api.g_number,

940: p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
941: p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
942: p_country IN VARCHAR2 DEFAULT hr_api.g_varchar2,
943: p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2,
944: p_designated_receiver_id IN NUMBER DEFAULT hr_api.g_number,
945: p_in_organization_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
946: p_inactive_date IN DATE DEFAULT hr_api.g_date,
947: p_operating_unit_id IN NUMBER DEFAULT NULL,
948: p_inventory_organization_id IN NUMBER DEFAULT hr_api.g_number,

Line 945: p_in_organization_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,

941: p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
942: p_country IN VARCHAR2 DEFAULT hr_api.g_varchar2,
943: p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2,
944: p_designated_receiver_id IN NUMBER DEFAULT hr_api.g_number,
945: p_in_organization_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
946: p_inactive_date IN DATE DEFAULT hr_api.g_date,
947: p_operating_unit_id IN NUMBER DEFAULT NULL,
948: p_inventory_organization_id IN NUMBER DEFAULT hr_api.g_number,
949: p_office_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 946: p_inactive_date IN DATE DEFAULT hr_api.g_date,

942: p_country IN VARCHAR2 DEFAULT hr_api.g_varchar2,
943: p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2,
944: p_designated_receiver_id IN NUMBER DEFAULT hr_api.g_number,
945: p_in_organization_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
946: p_inactive_date IN DATE DEFAULT hr_api.g_date,
947: p_operating_unit_id IN NUMBER DEFAULT NULL,
948: p_inventory_organization_id IN NUMBER DEFAULT hr_api.g_number,
949: p_office_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
950: p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 948: p_inventory_organization_id IN NUMBER DEFAULT hr_api.g_number,

944: p_designated_receiver_id IN NUMBER DEFAULT hr_api.g_number,
945: p_in_organization_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
946: p_inactive_date IN DATE DEFAULT hr_api.g_date,
947: p_operating_unit_id IN NUMBER DEFAULT NULL,
948: p_inventory_organization_id IN NUMBER DEFAULT hr_api.g_number,
949: p_office_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
950: p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
951: p_receiving_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
952: p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 949: p_office_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,

945: p_in_organization_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
946: p_inactive_date IN DATE DEFAULT hr_api.g_date,
947: p_operating_unit_id IN NUMBER DEFAULT NULL,
948: p_inventory_organization_id IN NUMBER DEFAULT hr_api.g_number,
949: p_office_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
950: p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
951: p_receiving_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
952: p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
953: p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 950: p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,

946: p_inactive_date IN DATE DEFAULT hr_api.g_date,
947: p_operating_unit_id IN NUMBER DEFAULT NULL,
948: p_inventory_organization_id IN NUMBER DEFAULT hr_api.g_number,
949: p_office_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
950: p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
951: p_receiving_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
952: p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
953: p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
954: p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 951: p_receiving_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,

947: p_operating_unit_id IN NUMBER DEFAULT NULL,
948: p_inventory_organization_id IN NUMBER DEFAULT hr_api.g_number,
949: p_office_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
950: p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
951: p_receiving_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
952: p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
953: p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
954: p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
955: p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number,

Line 952: p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

948: p_inventory_organization_id IN NUMBER DEFAULT hr_api.g_number,
949: p_office_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
950: p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
951: p_receiving_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
952: p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
953: p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
954: p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
955: p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number,
956: p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 953: p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

949: p_office_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
950: p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
951: p_receiving_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
952: p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
953: p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
954: p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
955: p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number,
956: p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
957: p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 954: p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

950: p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
951: p_receiving_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
952: p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
953: p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
954: p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
955: p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number,
956: p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
957: p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2,
958: p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 955: p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number,

951: p_receiving_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
952: p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
953: p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
954: p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
955: p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number,
956: p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
957: p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2,
958: p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2,
959: p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 956: p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,

952: p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
953: p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
954: p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
955: p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number,
956: p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
957: p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2,
958: p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2,
959: p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
960: p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 957: p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2,

953: p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
954: p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
955: p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number,
956: p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
957: p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2,
958: p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2,
959: p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
960: p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
961: p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 958: p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2,

954: p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
955: p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number,
956: p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
957: p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2,
958: p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2,
959: p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
960: p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
961: p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
962: p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 959: p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

955: p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number,
956: p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
957: p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2,
958: p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2,
959: p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
960: p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
961: p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
962: p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2,
963: p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 960: p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

956: p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
957: p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2,
958: p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2,
959: p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
960: p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
961: p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
962: p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2,
963: p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
964: p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 961: p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

957: p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2,
958: p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2,
959: p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
960: p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
961: p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
962: p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2,
963: p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
964: p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
965: p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 962: p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2,

958: p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2,
959: p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
960: p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
961: p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
962: p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2,
963: p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
964: p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
965: p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
966: p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 963: p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

959: p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
960: p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
961: p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
962: p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2,
963: p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
964: p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
965: p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
966: p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
967: p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 964: p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

960: p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
961: p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
962: p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2,
963: p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
964: p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
965: p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
966: p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
967: p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
968: p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 965: p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

961: p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
962: p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2,
963: p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
964: p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
965: p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
966: p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
967: p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
968: p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
969: p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 966: p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

962: p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2,
963: p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
964: p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
965: p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
966: p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
967: p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
968: p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
969: p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
970: p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 967: p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

963: p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
964: p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
965: p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
966: p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
967: p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
968: p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
969: p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
970: p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
971: p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 968: p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

964: p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
965: p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
966: p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
967: p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
968: p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
969: p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
970: p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
971: p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
972: p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 969: p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

965: p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
966: p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
967: p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
968: p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
969: p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
970: p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
971: p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
972: p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
973: p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 970: p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

966: p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
967: p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
968: p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
969: p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
970: p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
971: p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
972: p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
973: p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
974: p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 971: p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,

967: p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
968: p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
969: p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
970: p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
971: p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
972: p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
973: p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
974: p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
975: p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 972: p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

968: p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
969: p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
970: p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
971: p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
972: p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
973: p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
974: p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
975: p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
976: p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 973: p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

969: p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
970: p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
971: p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
972: p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
973: p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
974: p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
975: p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
976: p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
977: p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 974: p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

970: p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
971: p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
972: p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
973: p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
974: p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
975: p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
976: p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
977: p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
978: p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 975: p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

971: p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
972: p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
973: p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
974: p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
975: p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
976: p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
977: p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
978: p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
979: p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 976: p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

972: p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
973: p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
974: p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
975: p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
976: p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
977: p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
978: p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
979: p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
980: p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 977: p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

973: p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
974: p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
975: p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
976: p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
977: p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
978: p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
979: p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
980: p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
981: p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 978: p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

974: p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
975: p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
976: p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
977: p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
978: p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
979: p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
980: p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
981: p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
982: p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 979: p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

975: p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
976: p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
977: p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
978: p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
979: p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
980: p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
981: p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
982: p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
983: p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 980: p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

976: p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
977: p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
978: p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
979: p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
980: p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
981: p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
982: p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
983: p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
984: p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 981: p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

977: p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
978: p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
979: p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
980: p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
981: p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
982: p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
983: p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
984: p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
985: p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 982: p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

978: p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
979: p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
980: p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
981: p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
982: p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
983: p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
984: p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
985: p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
986: p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 983: p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

979: p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
980: p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
981: p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
982: p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
983: p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
984: p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
985: p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
986: p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
987: p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 984: p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

980: p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
981: p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
982: p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
983: p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
984: p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
985: p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
986: p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
987: p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
988: p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 985: p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

981: p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
982: p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
983: p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
984: p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
985: p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
986: p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
987: p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
988: p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
989: p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 986: p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

982: p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
983: p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
984: p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
985: p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
986: p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
987: p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
988: p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
989: p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
990: p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 987: p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

983: p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
984: p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
985: p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
986: p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
987: p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
988: p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
989: p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
990: p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
991: p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 988: p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

984: p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
985: p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
986: p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
987: p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
988: p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
989: p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
990: p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
991: p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
992: p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 989: p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

985: p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
986: p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
987: p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
988: p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
989: p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
990: p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
991: p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
992: p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
993: p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 990: p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

986: p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
987: p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
988: p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
989: p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
990: p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
991: p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
992: p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
993: p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
994: p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 991: p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

987: p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
988: p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
989: p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
990: p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
991: p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
992: p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
993: p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
994: p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
995: p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 992: p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,

988: p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
989: p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
990: p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
991: p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
992: p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
993: p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
994: p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
995: p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
996: p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 993: p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

989: p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
990: p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
991: p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
992: p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
993: p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
994: p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
995: p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
996: p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
997: p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 994: p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

990: p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
991: p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
992: p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
993: p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
994: p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
995: p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
996: p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
997: p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
998: p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 995: p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

991: p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
992: p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
993: p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
994: p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
995: p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
996: p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
997: p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
998: p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
999: p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 996: p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

992: p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
993: p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
994: p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
995: p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
996: p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
997: p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
998: p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
999: p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1000: p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 997: p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

993: p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
994: p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
995: p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
996: p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
997: p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
998: p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
999: p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1000: p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1001: p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 998: p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

994: p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
995: p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
996: p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
997: p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
998: p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
999: p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1000: p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1001: p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1002: p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 999: p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

995: p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
996: p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
997: p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
998: p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
999: p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1000: p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1001: p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1002: p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1003: p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 1000: p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

996: p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
997: p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
998: p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
999: p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1000: p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1001: p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1002: p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1003: p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1004: p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 1001: p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

997: p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
998: p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
999: p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1000: p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1001: p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1002: p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1003: p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1004: p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1005: p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 1002: p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

998: p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
999: p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1000: p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1001: p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1002: p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1003: p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1004: p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1005: p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1006: p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 1003: p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

999: p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1000: p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1001: p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1002: p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1003: p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1004: p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1005: p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1006: p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1007: p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 1004: p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

1000: p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1001: p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1002: p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1003: p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1004: p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1005: p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1006: p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1007: p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1008: p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 1005: p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

1001: p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1002: p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1003: p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1004: p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1005: p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1006: p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1007: p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1008: p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1009: p_global_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 1006: p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

1002: p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1003: p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1004: p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1005: p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1006: p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1007: p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1008: p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1009: p_global_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1010: p_global_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 1007: p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

1003: p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1004: p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1005: p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1006: p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1007: p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1008: p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1009: p_global_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1010: p_global_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1011: p_global_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 1008: p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

1004: p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1005: p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1006: p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1007: p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1008: p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1009: p_global_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1010: p_global_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1011: p_global_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1012: p_global_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 1009: p_global_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

1005: p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1006: p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1007: p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1008: p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1009: p_global_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1010: p_global_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1011: p_global_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1012: p_global_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1013: p_legal_address_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 1010: p_global_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

1006: p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1007: p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1008: p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1009: p_global_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1010: p_global_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1011: p_global_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1012: p_global_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1013: p_legal_address_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1014: p_tp_header_id IN NUMBER DEFAULT hr_api.g_number,

Line 1011: p_global_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

1007: p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1008: p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1009: p_global_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1010: p_global_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1011: p_global_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1012: p_global_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1013: p_legal_address_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1014: p_tp_header_id IN NUMBER DEFAULT hr_api.g_number,
1015: p_ece_tp_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1012: p_global_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,

1008: p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1009: p_global_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1010: p_global_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1011: p_global_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1012: p_global_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1013: p_legal_address_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1014: p_tp_header_id IN NUMBER DEFAULT hr_api.g_number,
1015: p_ece_tp_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
1016: ) IS

Line 1013: p_legal_address_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,

1009: p_global_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1010: p_global_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1011: p_global_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1012: p_global_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1013: p_legal_address_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1014: p_tp_header_id IN NUMBER DEFAULT hr_api.g_number,
1015: p_ece_tp_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
1016: ) IS
1017: --

Line 1014: p_tp_header_id IN NUMBER DEFAULT hr_api.g_number,

1010: p_global_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1011: p_global_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1012: p_global_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1013: p_legal_address_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1014: p_tp_header_id IN NUMBER DEFAULT hr_api.g_number,
1015: p_ece_tp_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
1016: ) IS
1017: --
1018: l_rec hr_loc_shd.g_rec_type;

Line 1015: p_ece_tp_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2

1011: p_global_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1012: p_global_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1013: p_legal_address_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1014: p_tp_header_id IN NUMBER DEFAULT hr_api.g_number,
1015: p_ece_tp_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
1016: ) IS
1017: --
1018: l_rec hr_loc_shd.g_rec_type;
1019: l_proc VARCHAR2(72) := g_package||'upd';

Line 1111: hr_api.g_number -- business_group_id is not updateable

1107: p_legal_address_flag,
1108: p_tp_header_id,
1109: p_ece_tp_location_code,
1110: p_object_version_number,
1111: hr_api.g_number -- business_group_id is not updateable
1112: );
1113: --
1114: -- Having converted the arguments into the
1115: -- plsql record structure we call the corresponding record