158: --
159: hr_utility.set_location(' Leaving:'||l_proc, 10);
160: --
161: EXCEPTION
162: WHEN hr_api.check_integrity_violated THEN
163: -- A check constraint has been violated
164: hr_loc_shd.g_api_dml := false; -- Unset the api dml status
165: hr_loc_shd.constraint_error
166: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));
162: WHEN hr_api.check_integrity_violated THEN
163: -- A check constraint has been violated
164: hr_loc_shd.g_api_dml := false; -- Unset the api dml status
165: hr_loc_shd.constraint_error
166: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));
167: WHEN hr_api.parent_integrity_violated THEN
168: -- Parent integrity has been violated
169: hr_loc_shd.g_api_dml := false; -- Unset the api dml status
170: hr_loc_shd.constraint_error
163: -- A check constraint has been violated
164: hr_loc_shd.g_api_dml := false; -- Unset the api dml status
165: hr_loc_shd.constraint_error
166: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));
167: WHEN hr_api.parent_integrity_violated THEN
168: -- Parent integrity has been violated
169: hr_loc_shd.g_api_dml := false; -- Unset the api dml status
170: hr_loc_shd.constraint_error
171: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));
167: WHEN hr_api.parent_integrity_violated THEN
168: -- Parent integrity has been violated
169: hr_loc_shd.g_api_dml := false; -- Unset the api dml status
170: hr_loc_shd.constraint_error
171: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));
172: WHEN hr_api.unique_integrity_violated THEN
173: -- Unique integrity has been violated
174: hr_loc_shd.g_api_dml := false; -- Unset the api dml status
175: hr_loc_shd.constraint_error
168: -- Parent integrity has been violated
169: hr_loc_shd.g_api_dml := false; -- Unset the api dml status
170: hr_loc_shd.constraint_error
171: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));
172: WHEN hr_api.unique_integrity_violated THEN
173: -- Unique integrity has been violated
174: hr_loc_shd.g_api_dml := false; -- Unset the api dml status
175: hr_loc_shd.constraint_error
176: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));
172: WHEN hr_api.unique_integrity_violated THEN
173: -- Unique integrity has been violated
174: hr_loc_shd.g_api_dml := false; -- Unset the api dml status
175: hr_loc_shd.constraint_error
176: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));
177: WHEN OTHERS THEN
178: hr_loc_shd.g_api_dml := false; -- Unset the api dml status
179: RAISE;
180: END update_dml;
474: ,p_object_version_number_o => hr_loc_shd.g_old_rec.object_version_number
475: ,p_business_group_id_o => hr_loc_shd.g_old_rec.business_group_id
476: );
477: EXCEPTION
478: WHEN hr_api.cannot_find_prog_unit THEN
479: hr_api.cannot_find_prog_unit_error
480: (p_module_name => 'HR_LOCATIONS_ALL'
481: ,p_hook_type => 'AU'
482: );
475: ,p_business_group_id_o => hr_loc_shd.g_old_rec.business_group_id
476: );
477: EXCEPTION
478: WHEN hr_api.cannot_find_prog_unit THEN
479: hr_api.cannot_find_prog_unit_error
480: (p_module_name => 'HR_LOCATIONS_ALL'
481: ,p_hook_type => 'AU'
482: );
483: --
542: -- p_rec plsql record structure
543: -- to see if a system default is being used. If a system default
544: -- is being used then we must set to the 'current' argument value.
545: --
546: IF (p_rec.entered_by = hr_api.g_number) THEN
547: p_rec.entered_by :=
548: hr_loc_shd.g_old_rec.entered_by;
549: END IF;
550: IF (p_rec.location_code = hr_api.g_varchar2) THEN
546: IF (p_rec.entered_by = hr_api.g_number) THEN
547: p_rec.entered_by :=
548: hr_loc_shd.g_old_rec.entered_by;
549: END IF;
550: IF (p_rec.location_code = hr_api.g_varchar2) THEN
551: p_rec.location_code :=
552: hr_loc_shd.g_old_rec.location_code;
553: END IF;
554: IF (p_rec.address_line_1 = hr_api.g_varchar2) THEN
550: IF (p_rec.location_code = hr_api.g_varchar2) THEN
551: p_rec.location_code :=
552: hr_loc_shd.g_old_rec.location_code;
553: END IF;
554: IF (p_rec.address_line_1 = hr_api.g_varchar2) THEN
555: p_rec.address_line_1 :=
556: hr_loc_shd.g_old_rec.address_line_1;
557: END IF;
558: IF (p_rec.address_line_2 = hr_api.g_varchar2) THEN
554: IF (p_rec.address_line_1 = hr_api.g_varchar2) THEN
555: p_rec.address_line_1 :=
556: hr_loc_shd.g_old_rec.address_line_1;
557: END IF;
558: IF (p_rec.address_line_2 = hr_api.g_varchar2) THEN
559: p_rec.address_line_2 :=
560: hr_loc_shd.g_old_rec.address_line_2;
561: END IF;
562: IF (p_rec.address_line_3 = hr_api.g_varchar2) THEN
558: IF (p_rec.address_line_2 = hr_api.g_varchar2) THEN
559: p_rec.address_line_2 :=
560: hr_loc_shd.g_old_rec.address_line_2;
561: END IF;
562: IF (p_rec.address_line_3 = hr_api.g_varchar2) THEN
563: p_rec.address_line_3 :=
564: hr_loc_shd.g_old_rec.address_line_3;
565: END IF;
566: IF (p_rec.bill_to_site_flag = hr_api.g_varchar2) THEN
562: IF (p_rec.address_line_3 = hr_api.g_varchar2) THEN
563: p_rec.address_line_3 :=
564: hr_loc_shd.g_old_rec.address_line_3;
565: END IF;
566: IF (p_rec.bill_to_site_flag = hr_api.g_varchar2) THEN
567: p_rec.bill_to_site_flag :=
568: hr_loc_shd.g_old_rec.bill_to_site_flag;
569: END IF;
570: IF (p_rec.country = hr_api.g_varchar2) THEN
566: IF (p_rec.bill_to_site_flag = hr_api.g_varchar2) THEN
567: p_rec.bill_to_site_flag :=
568: hr_loc_shd.g_old_rec.bill_to_site_flag;
569: END IF;
570: IF (p_rec.country = hr_api.g_varchar2) THEN
571: p_rec.country :=
572: hr_loc_shd.g_old_rec.country;
573: END IF;
574: IF (p_rec.description = hr_api.g_varchar2) THEN
570: IF (p_rec.country = hr_api.g_varchar2) THEN
571: p_rec.country :=
572: hr_loc_shd.g_old_rec.country;
573: END IF;
574: IF (p_rec.description = hr_api.g_varchar2) THEN
575: p_rec.description :=
576: hr_loc_shd.g_old_rec.description;
577: END IF;
578: IF (p_rec.designated_receiver_id = hr_api.g_number) THEN
574: IF (p_rec.description = hr_api.g_varchar2) THEN
575: p_rec.description :=
576: hr_loc_shd.g_old_rec.description;
577: END IF;
578: IF (p_rec.designated_receiver_id = hr_api.g_number) THEN
579: p_rec.designated_receiver_id :=
580: hr_loc_shd.g_old_rec.designated_receiver_id;
581: END IF;
582: IF (p_rec.in_organization_flag = hr_api.g_varchar2) THEN
578: IF (p_rec.designated_receiver_id = hr_api.g_number) THEN
579: p_rec.designated_receiver_id :=
580: hr_loc_shd.g_old_rec.designated_receiver_id;
581: END IF;
582: IF (p_rec.in_organization_flag = hr_api.g_varchar2) THEN
583: p_rec.in_organization_flag :=
584: hr_loc_shd.g_old_rec.in_organization_flag;
585: END IF;
586: IF (p_rec.inactive_date = hr_api.g_date) THEN
582: IF (p_rec.in_organization_flag = hr_api.g_varchar2) THEN
583: p_rec.in_organization_flag :=
584: hr_loc_shd.g_old_rec.in_organization_flag;
585: END IF;
586: IF (p_rec.inactive_date = hr_api.g_date) THEN
587: p_rec.inactive_date :=
588: hr_loc_shd.g_old_rec.inactive_date;
589: END IF;
590: IF (p_rec.inventory_organization_id = hr_api.g_number) THEN
586: IF (p_rec.inactive_date = hr_api.g_date) THEN
587: p_rec.inactive_date :=
588: hr_loc_shd.g_old_rec.inactive_date;
589: END IF;
590: IF (p_rec.inventory_organization_id = hr_api.g_number) THEN
591: p_rec.inventory_organization_id :=
592: hr_loc_shd.g_old_rec.inventory_organization_id;
593: END IF;
594: IF (p_rec.office_site_flag = hr_api.g_varchar2) THEN
590: IF (p_rec.inventory_organization_id = hr_api.g_number) THEN
591: p_rec.inventory_organization_id :=
592: hr_loc_shd.g_old_rec.inventory_organization_id;
593: END IF;
594: IF (p_rec.office_site_flag = hr_api.g_varchar2) THEN
595: p_rec.office_site_flag :=
596: hr_loc_shd.g_old_rec.office_site_flag;
597: END IF;
598: IF (p_rec.postal_code = hr_api.g_varchar2) THEN
594: IF (p_rec.office_site_flag = hr_api.g_varchar2) THEN
595: p_rec.office_site_flag :=
596: hr_loc_shd.g_old_rec.office_site_flag;
597: END IF;
598: IF (p_rec.postal_code = hr_api.g_varchar2) THEN
599: p_rec.postal_code :=
600: hr_loc_shd.g_old_rec.postal_code;
601: END IF;
602: IF (p_rec.receiving_site_flag = hr_api.g_varchar2) THEN
598: IF (p_rec.postal_code = hr_api.g_varchar2) THEN
599: p_rec.postal_code :=
600: hr_loc_shd.g_old_rec.postal_code;
601: END IF;
602: IF (p_rec.receiving_site_flag = hr_api.g_varchar2) THEN
603: p_rec.receiving_site_flag :=
604: hr_loc_shd.g_old_rec.receiving_site_flag;
605: END IF;
606: IF (p_rec.region_1 = hr_api.g_varchar2) THEN
602: IF (p_rec.receiving_site_flag = hr_api.g_varchar2) THEN
603: p_rec.receiving_site_flag :=
604: hr_loc_shd.g_old_rec.receiving_site_flag;
605: END IF;
606: IF (p_rec.region_1 = hr_api.g_varchar2) THEN
607: p_rec.region_1 :=
608: hr_loc_shd.g_old_rec.region_1;
609: END IF;
610: IF (p_rec.region_2 = hr_api.g_varchar2) THEN
606: IF (p_rec.region_1 = hr_api.g_varchar2) THEN
607: p_rec.region_1 :=
608: hr_loc_shd.g_old_rec.region_1;
609: END IF;
610: IF (p_rec.region_2 = hr_api.g_varchar2) THEN
611: p_rec.region_2 :=
612: hr_loc_shd.g_old_rec.region_2;
613: END IF;
614: IF (p_rec.region_3 = hr_api.g_varchar2) THEN
610: IF (p_rec.region_2 = hr_api.g_varchar2) THEN
611: p_rec.region_2 :=
612: hr_loc_shd.g_old_rec.region_2;
613: END IF;
614: IF (p_rec.region_3 = hr_api.g_varchar2) THEN
615: p_rec.region_3 :=
616: hr_loc_shd.g_old_rec.region_3;
617: END IF;
618: IF (p_rec.ship_to_location_id = hr_api.g_number) THEN
614: IF (p_rec.region_3 = hr_api.g_varchar2) THEN
615: p_rec.region_3 :=
616: hr_loc_shd.g_old_rec.region_3;
617: END IF;
618: IF (p_rec.ship_to_location_id = hr_api.g_number) THEN
619: p_rec.ship_to_location_id :=
620: hr_loc_shd.g_old_rec.ship_to_location_id;
621: END IF;
622: IF (p_rec.ship_to_site_flag = hr_api.g_varchar2) THEN
618: IF (p_rec.ship_to_location_id = hr_api.g_number) THEN
619: p_rec.ship_to_location_id :=
620: hr_loc_shd.g_old_rec.ship_to_location_id;
621: END IF;
622: IF (p_rec.ship_to_site_flag = hr_api.g_varchar2) THEN
623: p_rec.ship_to_site_flag :=
624: hr_loc_shd.g_old_rec.ship_to_site_flag;
625: END IF;
626: IF (p_rec.style = hr_api.g_varchar2) THEN
622: IF (p_rec.ship_to_site_flag = hr_api.g_varchar2) THEN
623: p_rec.ship_to_site_flag :=
624: hr_loc_shd.g_old_rec.ship_to_site_flag;
625: END IF;
626: IF (p_rec.style = hr_api.g_varchar2) THEN
627: p_rec.style :=
628: hr_loc_shd.g_old_rec.style;
629: END IF;
630: IF (p_rec.tax_name = hr_api.g_varchar2) THEN
626: IF (p_rec.style = hr_api.g_varchar2) THEN
627: p_rec.style :=
628: hr_loc_shd.g_old_rec.style;
629: END IF;
630: IF (p_rec.tax_name = hr_api.g_varchar2) THEN
631: p_rec.tax_name :=
632: hr_loc_shd.g_old_rec.tax_name;
633: END IF;
634: IF (p_rec.telephone_number_1 = hr_api.g_varchar2) THEN
630: IF (p_rec.tax_name = hr_api.g_varchar2) THEN
631: p_rec.tax_name :=
632: hr_loc_shd.g_old_rec.tax_name;
633: END IF;
634: IF (p_rec.telephone_number_1 = hr_api.g_varchar2) THEN
635: p_rec.telephone_number_1 :=
636: hr_loc_shd.g_old_rec.telephone_number_1;
637: END IF;
638: IF (p_rec.telephone_number_2 = hr_api.g_varchar2) THEN
634: IF (p_rec.telephone_number_1 = hr_api.g_varchar2) THEN
635: p_rec.telephone_number_1 :=
636: hr_loc_shd.g_old_rec.telephone_number_1;
637: END IF;
638: IF (p_rec.telephone_number_2 = hr_api.g_varchar2) THEN
639: p_rec.telephone_number_2 :=
640: hr_loc_shd.g_old_rec.telephone_number_2;
641: END IF;
642: IF (p_rec.telephone_number_3 = hr_api.g_varchar2) THEN
638: IF (p_rec.telephone_number_2 = hr_api.g_varchar2) THEN
639: p_rec.telephone_number_2 :=
640: hr_loc_shd.g_old_rec.telephone_number_2;
641: END IF;
642: IF (p_rec.telephone_number_3 = hr_api.g_varchar2) THEN
643: p_rec.telephone_number_3 :=
644: hr_loc_shd.g_old_rec.telephone_number_3;
645: END IF;
646: IF (p_rec.town_or_city = hr_api.g_varchar2) THEN
642: IF (p_rec.telephone_number_3 = hr_api.g_varchar2) THEN
643: p_rec.telephone_number_3 :=
644: hr_loc_shd.g_old_rec.telephone_number_3;
645: END IF;
646: IF (p_rec.town_or_city = hr_api.g_varchar2) THEN
647: p_rec.town_or_city :=
648: hr_loc_shd.g_old_rec.town_or_city;
649: END IF;
650: IF (p_rec.loc_information13 = hr_api.g_varchar2) THEN
646: IF (p_rec.town_or_city = hr_api.g_varchar2) THEN
647: p_rec.town_or_city :=
648: hr_loc_shd.g_old_rec.town_or_city;
649: END IF;
650: IF (p_rec.loc_information13 = hr_api.g_varchar2) THEN
651: p_rec.loc_information13 :=
652: hr_loc_shd.g_old_rec.loc_information13;
653: END IF;
654: IF (p_rec.loc_information14 = hr_api.g_varchar2) THEN
650: IF (p_rec.loc_information13 = hr_api.g_varchar2) THEN
651: p_rec.loc_information13 :=
652: hr_loc_shd.g_old_rec.loc_information13;
653: END IF;
654: IF (p_rec.loc_information14 = hr_api.g_varchar2) THEN
655: p_rec.loc_information14 :=
656: hr_loc_shd.g_old_rec.loc_information14;
657: END IF;
658: IF (p_rec.loc_information15 = hr_api.g_varchar2) THEN
654: IF (p_rec.loc_information14 = hr_api.g_varchar2) THEN
655: p_rec.loc_information14 :=
656: hr_loc_shd.g_old_rec.loc_information14;
657: END IF;
658: IF (p_rec.loc_information15 = hr_api.g_varchar2) THEN
659: p_rec.loc_information15 :=
660: hr_loc_shd.g_old_rec.loc_information15;
661: END IF;
662: IF (p_rec.loc_information16 = hr_api.g_varchar2) THEN
658: IF (p_rec.loc_information15 = hr_api.g_varchar2) THEN
659: p_rec.loc_information15 :=
660: hr_loc_shd.g_old_rec.loc_information15;
661: END IF;
662: IF (p_rec.loc_information16 = hr_api.g_varchar2) THEN
663: p_rec.loc_information16 :=
664: hr_loc_shd.g_old_rec.loc_information16;
665: END IF;
666: IF (p_rec.loc_information17 = hr_api.g_varchar2) THEN
662: IF (p_rec.loc_information16 = hr_api.g_varchar2) THEN
663: p_rec.loc_information16 :=
664: hr_loc_shd.g_old_rec.loc_information16;
665: END IF;
666: IF (p_rec.loc_information17 = hr_api.g_varchar2) THEN
667: p_rec.loc_information17 :=
668: hr_loc_shd.g_old_rec.loc_information17;
669: END IF;
670: IF (p_rec.loc_information18 = hr_api.g_varchar2) THEN
666: IF (p_rec.loc_information17 = hr_api.g_varchar2) THEN
667: p_rec.loc_information17 :=
668: hr_loc_shd.g_old_rec.loc_information17;
669: END IF;
670: IF (p_rec.loc_information18 = hr_api.g_varchar2) THEN
671: p_rec.loc_information18 :=
672: hr_loc_shd.g_old_rec.loc_information18;
673: END IF;
674: IF (p_rec.loc_information19 = hr_api.g_varchar2) THEN
670: IF (p_rec.loc_information18 = hr_api.g_varchar2) THEN
671: p_rec.loc_information18 :=
672: hr_loc_shd.g_old_rec.loc_information18;
673: END IF;
674: IF (p_rec.loc_information19 = hr_api.g_varchar2) THEN
675: p_rec.loc_information19 :=
676: hr_loc_shd.g_old_rec.loc_information19;
677: END IF;
678: IF (p_rec.loc_information20 = hr_api.g_varchar2) THEN
674: IF (p_rec.loc_information19 = hr_api.g_varchar2) THEN
675: p_rec.loc_information19 :=
676: hr_loc_shd.g_old_rec.loc_information19;
677: END IF;
678: IF (p_rec.loc_information20 = hr_api.g_varchar2) THEN
679: p_rec.loc_information20 :=
680: hr_loc_shd.g_old_rec.loc_information20;
681: END IF;
682: IF (p_rec.attribute_category = hr_api.g_varchar2) THEN
678: IF (p_rec.loc_information20 = hr_api.g_varchar2) THEN
679: p_rec.loc_information20 :=
680: hr_loc_shd.g_old_rec.loc_information20;
681: END IF;
682: IF (p_rec.attribute_category = hr_api.g_varchar2) THEN
683: p_rec.attribute_category :=
684: hr_loc_shd.g_old_rec.attribute_category;
685: END IF;
686: IF (p_rec.attribute1 = hr_api.g_varchar2) THEN
682: IF (p_rec.attribute_category = hr_api.g_varchar2) THEN
683: p_rec.attribute_category :=
684: hr_loc_shd.g_old_rec.attribute_category;
685: END IF;
686: IF (p_rec.attribute1 = hr_api.g_varchar2) THEN
687: p_rec.attribute1 :=
688: hr_loc_shd.g_old_rec.attribute1;
689: END IF;
690: IF (p_rec.attribute2 = hr_api.g_varchar2) THEN
686: IF (p_rec.attribute1 = hr_api.g_varchar2) THEN
687: p_rec.attribute1 :=
688: hr_loc_shd.g_old_rec.attribute1;
689: END IF;
690: IF (p_rec.attribute2 = hr_api.g_varchar2) THEN
691: p_rec.attribute2 :=
692: hr_loc_shd.g_old_rec.attribute2;
693: END IF;
694: IF (p_rec.attribute3 = hr_api.g_varchar2) THEN
690: IF (p_rec.attribute2 = hr_api.g_varchar2) THEN
691: p_rec.attribute2 :=
692: hr_loc_shd.g_old_rec.attribute2;
693: END IF;
694: IF (p_rec.attribute3 = hr_api.g_varchar2) THEN
695: p_rec.attribute3 :=
696: hr_loc_shd.g_old_rec.attribute3;
697: END IF;
698: IF (p_rec.attribute4 = hr_api.g_varchar2) THEN
694: IF (p_rec.attribute3 = hr_api.g_varchar2) THEN
695: p_rec.attribute3 :=
696: hr_loc_shd.g_old_rec.attribute3;
697: END IF;
698: IF (p_rec.attribute4 = hr_api.g_varchar2) THEN
699: p_rec.attribute4 :=
700: hr_loc_shd.g_old_rec.attribute4;
701: END IF;
702: IF (p_rec.attribute5 = hr_api.g_varchar2) THEN
698: IF (p_rec.attribute4 = hr_api.g_varchar2) THEN
699: p_rec.attribute4 :=
700: hr_loc_shd.g_old_rec.attribute4;
701: END IF;
702: IF (p_rec.attribute5 = hr_api.g_varchar2) THEN
703: p_rec.attribute5 :=
704: hr_loc_shd.g_old_rec.attribute5;
705: END IF;
706: IF (p_rec.attribute6 = hr_api.g_varchar2) THEN
702: IF (p_rec.attribute5 = hr_api.g_varchar2) THEN
703: p_rec.attribute5 :=
704: hr_loc_shd.g_old_rec.attribute5;
705: END IF;
706: IF (p_rec.attribute6 = hr_api.g_varchar2) THEN
707: p_rec.attribute6 :=
708: hr_loc_shd.g_old_rec.attribute6;
709: END IF;
710: IF (p_rec.attribute7 = hr_api.g_varchar2) THEN
706: IF (p_rec.attribute6 = hr_api.g_varchar2) THEN
707: p_rec.attribute6 :=
708: hr_loc_shd.g_old_rec.attribute6;
709: END IF;
710: IF (p_rec.attribute7 = hr_api.g_varchar2) THEN
711: p_rec.attribute7 :=
712: hr_loc_shd.g_old_rec.attribute7;
713: END IF;
714: IF (p_rec.attribute8 = hr_api.g_varchar2) THEN
710: IF (p_rec.attribute7 = hr_api.g_varchar2) THEN
711: p_rec.attribute7 :=
712: hr_loc_shd.g_old_rec.attribute7;
713: END IF;
714: IF (p_rec.attribute8 = hr_api.g_varchar2) THEN
715: p_rec.attribute8 :=
716: hr_loc_shd.g_old_rec.attribute8;
717: END IF;
718: IF (p_rec.attribute9 = hr_api.g_varchar2) THEN
714: IF (p_rec.attribute8 = hr_api.g_varchar2) THEN
715: p_rec.attribute8 :=
716: hr_loc_shd.g_old_rec.attribute8;
717: END IF;
718: IF (p_rec.attribute9 = hr_api.g_varchar2) THEN
719: p_rec.attribute9 :=
720: hr_loc_shd.g_old_rec.attribute9;
721: END IF;
722: IF (p_rec.attribute10 = hr_api.g_varchar2) THEN
718: IF (p_rec.attribute9 = hr_api.g_varchar2) THEN
719: p_rec.attribute9 :=
720: hr_loc_shd.g_old_rec.attribute9;
721: END IF;
722: IF (p_rec.attribute10 = hr_api.g_varchar2) THEN
723: p_rec.attribute10 :=
724: hr_loc_shd.g_old_rec.attribute10;
725: END IF;
726: IF (p_rec.attribute11 = hr_api.g_varchar2) THEN
722: IF (p_rec.attribute10 = hr_api.g_varchar2) THEN
723: p_rec.attribute10 :=
724: hr_loc_shd.g_old_rec.attribute10;
725: END IF;
726: IF (p_rec.attribute11 = hr_api.g_varchar2) THEN
727: p_rec.attribute11 :=
728: hr_loc_shd.g_old_rec.attribute11;
729: END IF;
730: IF (p_rec.attribute12 = hr_api.g_varchar2) THEN
726: IF (p_rec.attribute11 = hr_api.g_varchar2) THEN
727: p_rec.attribute11 :=
728: hr_loc_shd.g_old_rec.attribute11;
729: END IF;
730: IF (p_rec.attribute12 = hr_api.g_varchar2) THEN
731: p_rec.attribute12 :=
732: hr_loc_shd.g_old_rec.attribute12;
733: END IF;
734: IF (p_rec.attribute13 = hr_api.g_varchar2) THEN
730: IF (p_rec.attribute12 = hr_api.g_varchar2) THEN
731: p_rec.attribute12 :=
732: hr_loc_shd.g_old_rec.attribute12;
733: END IF;
734: IF (p_rec.attribute13 = hr_api.g_varchar2) THEN
735: p_rec.attribute13 :=
736: hr_loc_shd.g_old_rec.attribute13;
737: END IF;
738: IF (p_rec.attribute14 = hr_api.g_varchar2) THEN
734: IF (p_rec.attribute13 = hr_api.g_varchar2) THEN
735: p_rec.attribute13 :=
736: hr_loc_shd.g_old_rec.attribute13;
737: END IF;
738: IF (p_rec.attribute14 = hr_api.g_varchar2) THEN
739: p_rec.attribute14 :=
740: hr_loc_shd.g_old_rec.attribute14;
741: END IF;
742: IF (p_rec.attribute15 = hr_api.g_varchar2) THEN
738: IF (p_rec.attribute14 = hr_api.g_varchar2) THEN
739: p_rec.attribute14 :=
740: hr_loc_shd.g_old_rec.attribute14;
741: END IF;
742: IF (p_rec.attribute15 = hr_api.g_varchar2) THEN
743: p_rec.attribute15 :=
744: hr_loc_shd.g_old_rec.attribute15;
745: END IF;
746: IF (p_rec.attribute16 = hr_api.g_varchar2) THEN
742: IF (p_rec.attribute15 = hr_api.g_varchar2) THEN
743: p_rec.attribute15 :=
744: hr_loc_shd.g_old_rec.attribute15;
745: END IF;
746: IF (p_rec.attribute16 = hr_api.g_varchar2) THEN
747: p_rec.attribute16 :=
748: hr_loc_shd.g_old_rec.attribute16;
749: END IF;
750: IF (p_rec.attribute17 = hr_api.g_varchar2) THEN
746: IF (p_rec.attribute16 = hr_api.g_varchar2) THEN
747: p_rec.attribute16 :=
748: hr_loc_shd.g_old_rec.attribute16;
749: END IF;
750: IF (p_rec.attribute17 = hr_api.g_varchar2) THEN
751: p_rec.attribute17 :=
752: hr_loc_shd.g_old_rec.attribute17;
753: END IF;
754: IF (p_rec.attribute18 = hr_api.g_varchar2) THEN
750: IF (p_rec.attribute17 = hr_api.g_varchar2) THEN
751: p_rec.attribute17 :=
752: hr_loc_shd.g_old_rec.attribute17;
753: END IF;
754: IF (p_rec.attribute18 = hr_api.g_varchar2) THEN
755: p_rec.attribute18 :=
756: hr_loc_shd.g_old_rec.attribute18;
757: END IF;
758: IF (p_rec.attribute19 = hr_api.g_varchar2) THEN
754: IF (p_rec.attribute18 = hr_api.g_varchar2) THEN
755: p_rec.attribute18 :=
756: hr_loc_shd.g_old_rec.attribute18;
757: END IF;
758: IF (p_rec.attribute19 = hr_api.g_varchar2) THEN
759: p_rec.attribute19 :=
760: hr_loc_shd.g_old_rec.attribute19;
761: END IF;
762: IF (p_rec.attribute20 = hr_api.g_varchar2) THEN
758: IF (p_rec.attribute19 = hr_api.g_varchar2) THEN
759: p_rec.attribute19 :=
760: hr_loc_shd.g_old_rec.attribute19;
761: END IF;
762: IF (p_rec.attribute20 = hr_api.g_varchar2) THEN
763: p_rec.attribute20 :=
764: hr_loc_shd.g_old_rec.attribute20;
765: END IF;
766: IF (p_rec.global_attribute_category = hr_api.g_varchar2) THEN
762: IF (p_rec.attribute20 = hr_api.g_varchar2) THEN
763: p_rec.attribute20 :=
764: hr_loc_shd.g_old_rec.attribute20;
765: END IF;
766: IF (p_rec.global_attribute_category = hr_api.g_varchar2) THEN
767: p_rec.global_attribute_category :=
768: hr_loc_shd.g_old_rec.global_attribute_category;
769: END IF;
770: IF (p_rec.global_attribute1 = hr_api.g_varchar2) THEN
766: IF (p_rec.global_attribute_category = hr_api.g_varchar2) THEN
767: p_rec.global_attribute_category :=
768: hr_loc_shd.g_old_rec.global_attribute_category;
769: END IF;
770: IF (p_rec.global_attribute1 = hr_api.g_varchar2) THEN
771: p_rec.global_attribute1 :=
772: hr_loc_shd.g_old_rec.global_attribute1;
773: END IF;
774: IF (p_rec.global_attribute2 = hr_api.g_varchar2) THEN
770: IF (p_rec.global_attribute1 = hr_api.g_varchar2) THEN
771: p_rec.global_attribute1 :=
772: hr_loc_shd.g_old_rec.global_attribute1;
773: END IF;
774: IF (p_rec.global_attribute2 = hr_api.g_varchar2) THEN
775: p_rec.global_attribute2 :=
776: hr_loc_shd.g_old_rec.global_attribute2;
777: END IF;
778: IF (p_rec.global_attribute3 = hr_api.g_varchar2) THEN
774: IF (p_rec.global_attribute2 = hr_api.g_varchar2) THEN
775: p_rec.global_attribute2 :=
776: hr_loc_shd.g_old_rec.global_attribute2;
777: END IF;
778: IF (p_rec.global_attribute3 = hr_api.g_varchar2) THEN
779: p_rec.global_attribute3 :=
780: hr_loc_shd.g_old_rec.global_attribute3;
781: END IF;
782: IF (p_rec.global_attribute4 = hr_api.g_varchar2) THEN
778: IF (p_rec.global_attribute3 = hr_api.g_varchar2) THEN
779: p_rec.global_attribute3 :=
780: hr_loc_shd.g_old_rec.global_attribute3;
781: END IF;
782: IF (p_rec.global_attribute4 = hr_api.g_varchar2) THEN
783: p_rec.global_attribute4 :=
784: hr_loc_shd.g_old_rec.global_attribute4;
785: END IF;
786: IF (p_rec.global_attribute5 = hr_api.g_varchar2) THEN
782: IF (p_rec.global_attribute4 = hr_api.g_varchar2) THEN
783: p_rec.global_attribute4 :=
784: hr_loc_shd.g_old_rec.global_attribute4;
785: END IF;
786: IF (p_rec.global_attribute5 = hr_api.g_varchar2) THEN
787: p_rec.global_attribute5 :=
788: hr_loc_shd.g_old_rec.global_attribute5;
789: END IF;
790: IF (p_rec.global_attribute6 = hr_api.g_varchar2) THEN
786: IF (p_rec.global_attribute5 = hr_api.g_varchar2) THEN
787: p_rec.global_attribute5 :=
788: hr_loc_shd.g_old_rec.global_attribute5;
789: END IF;
790: IF (p_rec.global_attribute6 = hr_api.g_varchar2) THEN
791: p_rec.global_attribute6 :=
792: hr_loc_shd.g_old_rec.global_attribute6;
793: END IF;
794: IF (p_rec.global_attribute7 = hr_api.g_varchar2) THEN
790: IF (p_rec.global_attribute6 = hr_api.g_varchar2) THEN
791: p_rec.global_attribute6 :=
792: hr_loc_shd.g_old_rec.global_attribute6;
793: END IF;
794: IF (p_rec.global_attribute7 = hr_api.g_varchar2) THEN
795: p_rec.global_attribute7 :=
796: hr_loc_shd.g_old_rec.global_attribute7;
797: END IF;
798: IF (p_rec.global_attribute8 = hr_api.g_varchar2) THEN
794: IF (p_rec.global_attribute7 = hr_api.g_varchar2) THEN
795: p_rec.global_attribute7 :=
796: hr_loc_shd.g_old_rec.global_attribute7;
797: END IF;
798: IF (p_rec.global_attribute8 = hr_api.g_varchar2) THEN
799: p_rec.global_attribute8 :=
800: hr_loc_shd.g_old_rec.global_attribute8;
801: END IF;
802: IF (p_rec.global_attribute9 = hr_api.g_varchar2) THEN
798: IF (p_rec.global_attribute8 = hr_api.g_varchar2) THEN
799: p_rec.global_attribute8 :=
800: hr_loc_shd.g_old_rec.global_attribute8;
801: END IF;
802: IF (p_rec.global_attribute9 = hr_api.g_varchar2) THEN
803: p_rec.global_attribute9 :=
804: hr_loc_shd.g_old_rec.global_attribute9;
805: END IF;
806: IF (p_rec.global_attribute10 = hr_api.g_varchar2) THEN
802: IF (p_rec.global_attribute9 = hr_api.g_varchar2) THEN
803: p_rec.global_attribute9 :=
804: hr_loc_shd.g_old_rec.global_attribute9;
805: END IF;
806: IF (p_rec.global_attribute10 = hr_api.g_varchar2) THEN
807: p_rec.global_attribute10 :=
808: hr_loc_shd.g_old_rec.global_attribute10;
809: END IF;
810: IF (p_rec.global_attribute11 = hr_api.g_varchar2) THEN
806: IF (p_rec.global_attribute10 = hr_api.g_varchar2) THEN
807: p_rec.global_attribute10 :=
808: hr_loc_shd.g_old_rec.global_attribute10;
809: END IF;
810: IF (p_rec.global_attribute11 = hr_api.g_varchar2) THEN
811: p_rec.global_attribute11 :=
812: hr_loc_shd.g_old_rec.global_attribute11;
813: END IF;
814: IF (p_rec.global_attribute12 = hr_api.g_varchar2) THEN
810: IF (p_rec.global_attribute11 = hr_api.g_varchar2) THEN
811: p_rec.global_attribute11 :=
812: hr_loc_shd.g_old_rec.global_attribute11;
813: END IF;
814: IF (p_rec.global_attribute12 = hr_api.g_varchar2) THEN
815: p_rec.global_attribute12 :=
816: hr_loc_shd.g_old_rec.global_attribute12;
817: END IF;
818: IF (p_rec.global_attribute13 = hr_api.g_varchar2) THEN
814: IF (p_rec.global_attribute12 = hr_api.g_varchar2) THEN
815: p_rec.global_attribute12 :=
816: hr_loc_shd.g_old_rec.global_attribute12;
817: END IF;
818: IF (p_rec.global_attribute13 = hr_api.g_varchar2) THEN
819: p_rec.global_attribute13 :=
820: hr_loc_shd.g_old_rec.global_attribute13;
821: END IF;
822: IF (p_rec.global_attribute14 = hr_api.g_varchar2) THEN
818: IF (p_rec.global_attribute13 = hr_api.g_varchar2) THEN
819: p_rec.global_attribute13 :=
820: hr_loc_shd.g_old_rec.global_attribute13;
821: END IF;
822: IF (p_rec.global_attribute14 = hr_api.g_varchar2) THEN
823: p_rec.global_attribute14 :=
824: hr_loc_shd.g_old_rec.global_attribute14;
825: END IF;
826: IF (p_rec.global_attribute15 = hr_api.g_varchar2) THEN
822: IF (p_rec.global_attribute14 = hr_api.g_varchar2) THEN
823: p_rec.global_attribute14 :=
824: hr_loc_shd.g_old_rec.global_attribute14;
825: END IF;
826: IF (p_rec.global_attribute15 = hr_api.g_varchar2) THEN
827: p_rec.global_attribute15 :=
828: hr_loc_shd.g_old_rec.global_attribute15;
829: END IF;
830: IF (p_rec.global_attribute16 = hr_api.g_varchar2) THEN
826: IF (p_rec.global_attribute15 = hr_api.g_varchar2) THEN
827: p_rec.global_attribute15 :=
828: hr_loc_shd.g_old_rec.global_attribute15;
829: END IF;
830: IF (p_rec.global_attribute16 = hr_api.g_varchar2) THEN
831: p_rec.global_attribute16 :=
832: hr_loc_shd.g_old_rec.global_attribute16;
833: END IF;
834: IF (p_rec.global_attribute17 = hr_api.g_varchar2) THEN
830: IF (p_rec.global_attribute16 = hr_api.g_varchar2) THEN
831: p_rec.global_attribute16 :=
832: hr_loc_shd.g_old_rec.global_attribute16;
833: END IF;
834: IF (p_rec.global_attribute17 = hr_api.g_varchar2) THEN
835: p_rec.global_attribute17 :=
836: hr_loc_shd.g_old_rec.global_attribute17;
837: END IF;
838: IF (p_rec.global_attribute18 = hr_api.g_varchar2) THEN
834: IF (p_rec.global_attribute17 = hr_api.g_varchar2) THEN
835: p_rec.global_attribute17 :=
836: hr_loc_shd.g_old_rec.global_attribute17;
837: END IF;
838: IF (p_rec.global_attribute18 = hr_api.g_varchar2) THEN
839: p_rec.global_attribute18 :=
840: hr_loc_shd.g_old_rec.global_attribute18;
841: END IF;
842: IF (p_rec.global_attribute19 = hr_api.g_varchar2) THEN
838: IF (p_rec.global_attribute18 = hr_api.g_varchar2) THEN
839: p_rec.global_attribute18 :=
840: hr_loc_shd.g_old_rec.global_attribute18;
841: END IF;
842: IF (p_rec.global_attribute19 = hr_api.g_varchar2) THEN
843: p_rec.global_attribute19 :=
844: hr_loc_shd.g_old_rec.global_attribute19;
845: END IF;
846: IF (p_rec.global_attribute20 = hr_api.g_varchar2) THEN
842: IF (p_rec.global_attribute19 = hr_api.g_varchar2) THEN
843: p_rec.global_attribute19 :=
844: hr_loc_shd.g_old_rec.global_attribute19;
845: END IF;
846: IF (p_rec.global_attribute20 = hr_api.g_varchar2) THEN
847: p_rec.global_attribute20 :=
848: hr_loc_shd.g_old_rec.global_attribute20;
849: END IF;
850: IF (p_rec.legal_address_flag = hr_api.g_varchar2) THEN
846: IF (p_rec.global_attribute20 = hr_api.g_varchar2) THEN
847: p_rec.global_attribute20 :=
848: hr_loc_shd.g_old_rec.global_attribute20;
849: END IF;
850: IF (p_rec.legal_address_flag = hr_api.g_varchar2) THEN
851: p_rec.legal_address_flag :=
852: hr_loc_shd.g_old_rec.legal_address_flag;
853: END IF;
854: IF (p_rec.tp_header_id = hr_api.g_number) THEN
850: IF (p_rec.legal_address_flag = hr_api.g_varchar2) THEN
851: p_rec.legal_address_flag :=
852: hr_loc_shd.g_old_rec.legal_address_flag;
853: END IF;
854: IF (p_rec.tp_header_id = hr_api.g_number) THEN
855: p_rec.tp_header_id :=
856: hr_loc_shd.g_old_rec.tp_header_id;
857: END IF;
858: IF (p_rec.ece_tp_location_code = hr_api.g_varchar2) THEN
854: IF (p_rec.tp_header_id = hr_api.g_number) THEN
855: p_rec.tp_header_id :=
856: hr_loc_shd.g_old_rec.tp_header_id;
857: END IF;
858: IF (p_rec.ece_tp_location_code = hr_api.g_varchar2) THEN
859: p_rec.ece_tp_location_code :=
860: hr_loc_shd.g_old_rec.ece_tp_location_code;
861: END IF;
862: IF (p_rec.business_group_id = hr_api.g_number) THEN
858: IF (p_rec.ece_tp_location_code = hr_api.g_varchar2) THEN
859: p_rec.ece_tp_location_code :=
860: hr_loc_shd.g_old_rec.ece_tp_location_code;
861: END IF;
862: IF (p_rec.business_group_id = hr_api.g_number) THEN
863: p_rec.business_group_id :=
864: hr_loc_shd.g_old_rec.business_group_id;
865: END IF;
866: -- Fix 3286235
863: p_rec.business_group_id :=
864: hr_loc_shd.g_old_rec.business_group_id;
865: END IF;
866: -- Fix 3286235
867: IF (p_rec.timezone_code = hr_api.g_varchar2) THEN
868: p_rec.timezone_code :=
869: hr_loc_shd.g_old_rec.timezone_code;
870: END IF;
871: -- End Fix 3286235
931: (
932: p_effective_date IN DATE,
933: p_location_id IN NUMBER,
934: p_object_version_number IN OUT NOCOPY NUMBER,
935: p_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
936: p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
937: p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
938: p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
939: p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
932: p_effective_date IN DATE,
933: p_location_id IN NUMBER,
934: p_object_version_number IN OUT NOCOPY NUMBER,
935: p_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
936: p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
937: p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
938: p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
939: p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
940: p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
933: p_location_id IN NUMBER,
934: p_object_version_number IN OUT NOCOPY NUMBER,
935: p_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
936: p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
937: p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
938: p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
939: p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
940: p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
941: p_country IN VARCHAR2 DEFAULT hr_api.g_varchar2,
934: p_object_version_number IN OUT NOCOPY NUMBER,
935: p_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
936: p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
937: p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
938: p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
939: p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
940: p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
941: p_country IN VARCHAR2 DEFAULT hr_api.g_varchar2,
942: p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2,
935: p_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
936: p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
937: p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
938: p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
939: p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
940: p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
941: p_country IN VARCHAR2 DEFAULT hr_api.g_varchar2,
942: p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2,
943: p_designated_receiver_id IN NUMBER DEFAULT hr_api.g_number,
936: p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
937: p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
938: p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
939: p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
940: p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
941: p_country IN VARCHAR2 DEFAULT hr_api.g_varchar2,
942: p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2,
943: p_designated_receiver_id IN NUMBER DEFAULT hr_api.g_number,
944: p_in_organization_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
937: p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
938: p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
939: p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
940: p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
941: p_country IN VARCHAR2 DEFAULT hr_api.g_varchar2,
942: p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2,
943: p_designated_receiver_id IN NUMBER DEFAULT hr_api.g_number,
944: p_in_organization_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
945: p_inactive_date IN DATE DEFAULT hr_api.g_date,
938: p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
939: p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
940: p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
941: p_country IN VARCHAR2 DEFAULT hr_api.g_varchar2,
942: p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2,
943: p_designated_receiver_id IN NUMBER DEFAULT hr_api.g_number,
944: p_in_organization_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
945: p_inactive_date IN DATE DEFAULT hr_api.g_date,
946: p_operating_unit_id IN NUMBER DEFAULT NULL,
939: p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
940: p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
941: p_country IN VARCHAR2 DEFAULT hr_api.g_varchar2,
942: p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2,
943: p_designated_receiver_id IN NUMBER DEFAULT hr_api.g_number,
944: p_in_organization_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
945: p_inactive_date IN DATE DEFAULT hr_api.g_date,
946: p_operating_unit_id IN NUMBER DEFAULT NULL,
947: p_inventory_organization_id IN NUMBER DEFAULT hr_api.g_number,
940: p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
941: p_country IN VARCHAR2 DEFAULT hr_api.g_varchar2,
942: p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2,
943: p_designated_receiver_id IN NUMBER DEFAULT hr_api.g_number,
944: p_in_organization_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
945: p_inactive_date IN DATE DEFAULT hr_api.g_date,
946: p_operating_unit_id IN NUMBER DEFAULT NULL,
947: p_inventory_organization_id IN NUMBER DEFAULT hr_api.g_number,
948: p_office_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
941: p_country IN VARCHAR2 DEFAULT hr_api.g_varchar2,
942: p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2,
943: p_designated_receiver_id IN NUMBER DEFAULT hr_api.g_number,
944: p_in_organization_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
945: p_inactive_date IN DATE DEFAULT hr_api.g_date,
946: p_operating_unit_id IN NUMBER DEFAULT NULL,
947: p_inventory_organization_id IN NUMBER DEFAULT hr_api.g_number,
948: p_office_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
949: p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
943: p_designated_receiver_id IN NUMBER DEFAULT hr_api.g_number,
944: p_in_organization_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
945: p_inactive_date IN DATE DEFAULT hr_api.g_date,
946: p_operating_unit_id IN NUMBER DEFAULT NULL,
947: p_inventory_organization_id IN NUMBER DEFAULT hr_api.g_number,
948: p_office_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
949: p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
950: p_receiving_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
951: p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
944: p_in_organization_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
945: p_inactive_date IN DATE DEFAULT hr_api.g_date,
946: p_operating_unit_id IN NUMBER DEFAULT NULL,
947: p_inventory_organization_id IN NUMBER DEFAULT hr_api.g_number,
948: p_office_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
949: p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
950: p_receiving_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
951: p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
952: p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
945: p_inactive_date IN DATE DEFAULT hr_api.g_date,
946: p_operating_unit_id IN NUMBER DEFAULT NULL,
947: p_inventory_organization_id IN NUMBER DEFAULT hr_api.g_number,
948: p_office_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
949: p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
950: p_receiving_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
951: p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
952: p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
953: p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
946: p_operating_unit_id IN NUMBER DEFAULT NULL,
947: p_inventory_organization_id IN NUMBER DEFAULT hr_api.g_number,
948: p_office_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
949: p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
950: p_receiving_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
951: p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
952: p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
953: p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
954: p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number,
947: p_inventory_organization_id IN NUMBER DEFAULT hr_api.g_number,
948: p_office_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
949: p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
950: p_receiving_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
951: p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
952: p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
953: p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
954: p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number,
955: p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
948: p_office_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
949: p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
950: p_receiving_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
951: p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
952: p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
953: p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
954: p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number,
955: p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
956: p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2,
949: p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
950: p_receiving_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
951: p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
952: p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
953: p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
954: p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number,
955: p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
956: p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2,
957: p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2,
950: p_receiving_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
951: p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
952: p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
953: p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
954: p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number,
955: p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
956: p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2,
957: p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2,
958: p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
951: p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
952: p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
953: p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
954: p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number,
955: p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
956: p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2,
957: p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2,
958: p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
959: p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
952: p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
953: p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
954: p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number,
955: p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
956: p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2,
957: p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2,
958: p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
959: p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
960: p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
953: p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
954: p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number,
955: p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
956: p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2,
957: p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2,
958: p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
959: p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
960: p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
961: p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2,
954: p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number,
955: p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
956: p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2,
957: p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2,
958: p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
959: p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
960: p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
961: p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2,
962: p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
955: p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
956: p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2,
957: p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2,
958: p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
959: p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
960: p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
961: p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2,
962: p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
963: p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
956: p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2,
957: p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2,
958: p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
959: p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
960: p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
961: p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2,
962: p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
963: p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
964: p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
957: p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2,
958: p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
959: p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
960: p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
961: p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2,
962: p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
963: p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
964: p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
965: p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
958: p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
959: p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
960: p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
961: p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2,
962: p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
963: p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
964: p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
965: p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
966: p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
959: p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
960: p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
961: p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2,
962: p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
963: p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
964: p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
965: p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
966: p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
967: p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
960: p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
961: p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2,
962: p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
963: p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
964: p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
965: p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
966: p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
967: p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
968: p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
961: p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2,
962: p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
963: p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
964: p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
965: p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
966: p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
967: p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
968: p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
969: p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
962: p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
963: p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
964: p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
965: p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
966: p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
967: p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
968: p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
969: p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
970: p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
963: p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
964: p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
965: p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
966: p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
967: p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
968: p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
969: p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
970: p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
971: p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
964: p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
965: p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
966: p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
967: p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
968: p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
969: p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
970: p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
971: p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
972: p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
965: p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
966: p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
967: p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
968: p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
969: p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
970: p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
971: p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
972: p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
973: p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
966: p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
967: p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
968: p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
969: p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
970: p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
971: p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
972: p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
973: p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
974: p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
967: p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
968: p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
969: p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
970: p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
971: p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
972: p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
973: p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
974: p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
975: p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
968: p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
969: p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
970: p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
971: p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
972: p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
973: p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
974: p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
975: p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
976: p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
969: p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
970: p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
971: p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
972: p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
973: p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
974: p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
975: p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
976: p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
977: p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
970: p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
971: p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
972: p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
973: p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
974: p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
975: p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
976: p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
977: p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
978: p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
971: p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
972: p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
973: p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
974: p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
975: p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
976: p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
977: p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
978: p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
979: p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
972: p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
973: p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
974: p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
975: p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
976: p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
977: p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
978: p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
979: p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
980: p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
973: p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
974: p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
975: p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
976: p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
977: p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
978: p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
979: p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
980: p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
981: p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
974: p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
975: p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
976: p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
977: p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
978: p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
979: p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
980: p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
981: p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
982: p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
975: p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
976: p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
977: p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
978: p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
979: p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
980: p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
981: p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
982: p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
983: p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
976: p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
977: p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
978: p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
979: p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
980: p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
981: p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
982: p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
983: p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
984: p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
977: p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
978: p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
979: p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
980: p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
981: p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
982: p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
983: p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
984: p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
985: p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
978: p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
979: p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
980: p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
981: p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
982: p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
983: p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
984: p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
985: p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
986: p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
979: p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
980: p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
981: p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
982: p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
983: p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
984: p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
985: p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
986: p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
987: p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
980: p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
981: p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
982: p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
983: p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
984: p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
985: p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
986: p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
987: p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
988: p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
981: p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
982: p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
983: p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
984: p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
985: p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
986: p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
987: p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
988: p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
989: p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
982: p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
983: p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
984: p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
985: p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
986: p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
987: p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
988: p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
989: p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
990: p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
983: p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
984: p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
985: p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
986: p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
987: p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
988: p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
989: p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
990: p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
991: p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
984: p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
985: p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
986: p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
987: p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
988: p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
989: p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
990: p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
991: p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
992: p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
985: p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
986: p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
987: p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
988: p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
989: p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
990: p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
991: p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
992: p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
993: p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
986: p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
987: p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
988: p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
989: p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
990: p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
991: p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
992: p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
993: p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
994: p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
987: p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
988: p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
989: p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
990: p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
991: p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
992: p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
993: p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
994: p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
995: p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
988: p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
989: p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
990: p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
991: p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
992: p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
993: p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
994: p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
995: p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
996: p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
989: p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
990: p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
991: p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
992: p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
993: p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
994: p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
995: p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
996: p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
997: p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
990: p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
991: p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
992: p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
993: p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
994: p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
995: p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
996: p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
997: p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
998: p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
991: p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
992: p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
993: p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
994: p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
995: p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
996: p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
997: p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
998: p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
999: p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
992: p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
993: p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
994: p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
995: p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
996: p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
997: p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
998: p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
999: p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1000: p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
993: p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
994: p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
995: p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
996: p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
997: p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
998: p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
999: p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1000: p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1001: p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
994: p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
995: p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
996: p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
997: p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
998: p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
999: p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1000: p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1001: p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1002: p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
995: p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
996: p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
997: p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
998: p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
999: p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1000: p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1001: p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1002: p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1003: p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
996: p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
997: p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
998: p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
999: p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1000: p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1001: p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1002: p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1003: p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1004: p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
997: p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
998: p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
999: p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1000: p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1001: p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1002: p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1003: p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1004: p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1005: p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
998: p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
999: p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1000: p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1001: p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1002: p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1003: p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1004: p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1005: p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1006: p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
999: p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1000: p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1001: p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1002: p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1003: p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1004: p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1005: p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1006: p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1007: p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1000: p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1001: p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1002: p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1003: p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1004: p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1005: p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1006: p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1007: p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1008: p_global_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1001: p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1002: p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1003: p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1004: p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1005: p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1006: p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1007: p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1008: p_global_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1009: p_global_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1002: p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1003: p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1004: p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1005: p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1006: p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1007: p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1008: p_global_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1009: p_global_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1010: p_global_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1003: p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1004: p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1005: p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1006: p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1007: p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1008: p_global_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1009: p_global_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1010: p_global_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1011: p_global_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1004: p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1005: p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1006: p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1007: p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1008: p_global_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1009: p_global_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1010: p_global_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1011: p_global_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1012: p_legal_address_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1005: p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1006: p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1007: p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1008: p_global_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1009: p_global_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1010: p_global_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1011: p_global_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1012: p_legal_address_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1013: p_tp_header_id IN NUMBER DEFAULT hr_api.g_number,
1006: p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1007: p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1008: p_global_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1009: p_global_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1010: p_global_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1011: p_global_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1012: p_legal_address_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1013: p_tp_header_id IN NUMBER DEFAULT hr_api.g_number,
1014: p_ece_tp_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
1007: p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1008: p_global_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1009: p_global_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1010: p_global_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1011: p_global_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1012: p_legal_address_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1013: p_tp_header_id IN NUMBER DEFAULT hr_api.g_number,
1014: p_ece_tp_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
1015: ) IS
1008: p_global_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1009: p_global_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1010: p_global_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1011: p_global_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1012: p_legal_address_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1013: p_tp_header_id IN NUMBER DEFAULT hr_api.g_number,
1014: p_ece_tp_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
1015: ) IS
1016: --
1009: p_global_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1010: p_global_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1011: p_global_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1012: p_legal_address_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1013: p_tp_header_id IN NUMBER DEFAULT hr_api.g_number,
1014: p_ece_tp_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
1015: ) IS
1016: --
1017: l_rec hr_loc_shd.g_rec_type;
1010: p_global_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1011: p_global_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1012: p_legal_address_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1013: p_tp_header_id IN NUMBER DEFAULT hr_api.g_number,
1014: p_ece_tp_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
1015: ) IS
1016: --
1017: l_rec hr_loc_shd.g_rec_type;
1018: l_proc VARCHAR2(72) := g_package||'upd';
1106: p_legal_address_flag,
1107: p_tp_header_id,
1108: p_ece_tp_location_code,
1109: p_object_version_number,
1110: hr_api.g_number -- business_group_id is not updateable
1111: );
1112: --
1113: -- Having converted the arguments into the
1114: -- plsql record structure we call the corresponding record