[Home] [Help]
53: --
54: BEGIN
55: --
56: hr_utility.set_location('Entering:'|| l_proc, 10);
57: hr_api.mandatory_arg_error(p_api_name => l_proc,
58: p_argument => 'location_id',
59: p_argument_value => p_location_id);
60: IF nvl(g_location_id, hr_api.g_number) = p_location_id THEN
61: --
56: hr_utility.set_location('Entering:'|| l_proc, 10);
57: hr_api.mandatory_arg_error(p_api_name => l_proc,
58: p_argument => 'location_id',
59: p_argument_value => p_location_id);
60: IF nvl(g_location_id, hr_api.g_number) = p_location_id THEN
61: --
62: -- The legislation code has already been found with a previous
63: -- call to this function. Just return the value in the global
64: -- variable.
182: SELECT NULL
183: FROM hr_locations_all
184: WHERE location_id = p_ship_to_location_id
185: AND ship_to_site_flag = 'Y'
186: AND nvl(inactive_date, hr_api.g_eot) >= p_effective_date
187: AND ( p_business_group_id IS NULL
188: OR nvl(business_group_id, p_business_group_id)
189: = p_business_group_id );
190: --
250: --
251:
252: ELSE
253: -- Start of fix 3224396
254: IF nvl (p_ship_to_location_id, hr_api.g_number) <>
255: nvl (hr_loc_shd.g_old_rec.ship_to_location_id, hr_api.g_number) OR
256: nvl (p_ship_to_site_flag, hr_api.g_varchar2) <>
257: nvl (hr_loc_shd.g_old_rec.ship_to_site_flag, hr_api.g_varchar2) THEN
258: -- End of 3224396
251:
252: ELSE
253: -- Start of fix 3224396
254: IF nvl (p_ship_to_location_id, hr_api.g_number) <>
255: nvl (hr_loc_shd.g_old_rec.ship_to_location_id, hr_api.g_number) OR
256: nvl (p_ship_to_site_flag, hr_api.g_varchar2) <>
257: nvl (hr_loc_shd.g_old_rec.ship_to_site_flag, hr_api.g_varchar2) THEN
258: -- End of 3224396
259: --
252: ELSE
253: -- Start of fix 3224396
254: IF nvl (p_ship_to_location_id, hr_api.g_number) <>
255: nvl (hr_loc_shd.g_old_rec.ship_to_location_id, hr_api.g_number) OR
256: nvl (p_ship_to_site_flag, hr_api.g_varchar2) <>
257: nvl (hr_loc_shd.g_old_rec.ship_to_site_flag, hr_api.g_varchar2) THEN
258: -- End of 3224396
259: --
260: -- ************************** Updating with new data ***************************
253: -- Start of fix 3224396
254: IF nvl (p_ship_to_location_id, hr_api.g_number) <>
255: nvl (hr_loc_shd.g_old_rec.ship_to_location_id, hr_api.g_number) OR
256: nvl (p_ship_to_site_flag, hr_api.g_varchar2) <>
257: nvl (hr_loc_shd.g_old_rec.ship_to_site_flag, hr_api.g_varchar2) THEN
258: -- End of 3224396
259: --
260: -- ************************** Updating with new data ***************************
261: --
270: IF p_ship_to_location_id = p_location_id THEN
271: --
272: -- Do not get data from database if we are referencing current location_id
273: --
274: IF (p_ship_to_site_flag = 'N') OR (nvl(p_inactive_date, hr_api.g_eot) <
275: p_effective_date) THEN
276: hr_utility.set_message(800, 'PER_52537_LOC_INV_SHPTO_FLG');
277: hr_utility.raise_error;
278: END IF;
417: -- Only perform validation when DESIGNATED_RECEIVER_ID is not null
418: --
419: IF (p_location_id IS NULL) OR
420: (p_designated_receiver_id <> nvl (hr_loc_shd.g_old_rec.designated_receiver_id,
421: hr_api.g_number) )
422: THEN
423: --
424: -- Check that the Person ID is linked to a
425: -- valid person on PER_PEOPLE_F
488: hr_utility.set_location('Entering:'|| l_proc, 10);
489: --
490: -- If set, inactive_date must be greater or equal to session date.
491: --
492: IF nvl (p_inactive_date, hr_api.g_eot) < p_effective_date THEN
493: hr_utility.set_message(800, 'HR_7301_INVALID_INACTIVE_DATE');
494: hr_utility.raise_error;
495: END IF;
496: --
555: -- and we are updating with new data, or inserting.
556: --
557: IF p_inventory_organization_id IS NOT NULL THEN
558: hr_utility.set_location('Inventory Org id '|| p_inventory_organization_id, 15);
559: IF ( p_inventory_organization_id <> nvl (hr_loc_shd.g_old_rec.inventory_organization_id, hr_api.g_number) ) OR
560: ( p_location_id IS NULL) THEN
561: hr_utility.set_location('If Condition satisfied, checking inventory org ', 20);
562: --
563: DECLARE
651:
652: /* cursor csr_valid_tax_name IS
653: SELECT NULL
654: FROM ap_tax_codes
655: WHERE nvl(inactive_date, hr_api.g_eot ) >= p_effective_date
656: AND name = p_tax_name;
657: */
658: -- Start of the bug#11705804
659:
659:
660: cursor csr_valid_tax_name IS
661: SELECT NULL
662: FROM zx_input_classifications_v
663: WHERE nvl(end_date_active, hr_api.g_eot ) >= p_effective_date
664: AND lookup_type = 'ZX_INPUT_CLASSIFICATIONS'
665: AND lookup_code = p_tax_name ;
666: -- AND tax_class = 'INPUT';
667:
676: IF ( p_tax_name IS NOT NULL ) THEN
677: --
678: -- Only continue if tax_name is not null
679: --p_tax_name
680: IF ( p_tax_name <> nvl (hr_loc_shd.g_old_rec.tax_name, hr_api.g_varchar2) )
681: OR (p_location_id IS NULL)
682: --
683: -- Only validate if inserting, or updating with new value
684: --
763: IF ( p_style IS NOT NULL ) THEN
764: --
765: -- Only continue if STYLE is not null
766: --
767: IF ( nvl(hr_loc_shd.g_old_rec.style, hr_api.g_varchar2) <> p_style)
768: OR (p_location_id IS NULL ) THEN
769: --
770: -- Only validate if inserting, or updating with new value
771: --
839: IF ( p_timezone_code IS NOT NULL ) THEN
840: --
841: -- Only continue if TIMEZONE_CODE is not null
842: --
843: IF ( nvl(hr_loc_shd.g_old_rec.timezone_code, hr_api.g_varchar2)
844: <> p_timezone_code) THEN
845: --
846: -- Only validate if inserting, or updating with new value
847: --
1163: END IF;
1164: --
1165: hr_utility.set_location(l_proc, 10);
1166: --
1167: IF nvl(p_rec.business_group_id, hr_api.g_number) <>
1168: nvl (hr_loc_shd.g_old_rec.business_group_id, hr_api.g_number) THEN
1169: l_argument := 'business_group_id';
1170: RAISE l_error;
1171: END IF;
1164: --
1165: hr_utility.set_location(l_proc, 10);
1166: --
1167: IF nvl(p_rec.business_group_id, hr_api.g_number) <>
1168: nvl (hr_loc_shd.g_old_rec.business_group_id, hr_api.g_number) THEN
1169: l_argument := 'business_group_id';
1170: RAISE l_error;
1171: END IF;
1172: --
1171: END IF;
1172: --
1173: EXCEPTION
1174: WHEN l_error THEN
1175: hr_api.argument_changed_error
1176: (p_api_name => l_proc
1177: ,p_argument => l_argument);
1178: WHEN OTHERS THEN
1179: RAISE;
1219: --
1220: -- Address location - regular DF
1221: -- =============================
1222: --
1223: IF nvl(hr_loc_shd.g_old_rec.style, hr_api.g_varchar2) <>
1224: nvl(p_rec.style, hr_api.g_varchar2) OR
1225: nvl(hr_loc_shd.g_old_rec.address_line_1, hr_api.g_varchar2) <>
1226: nvl(p_rec.address_line_1, hr_api.g_varchar2) OR
1227: nvl(hr_loc_shd.g_old_rec.address_line_2, hr_api.g_varchar2) <>
1220: -- Address location - regular DF
1221: -- =============================
1222: --
1223: IF nvl(hr_loc_shd.g_old_rec.style, hr_api.g_varchar2) <>
1224: nvl(p_rec.style, hr_api.g_varchar2) OR
1225: nvl(hr_loc_shd.g_old_rec.address_line_1, hr_api.g_varchar2) <>
1226: nvl(p_rec.address_line_1, hr_api.g_varchar2) OR
1227: nvl(hr_loc_shd.g_old_rec.address_line_2, hr_api.g_varchar2) <>
1228: nvl(p_rec.address_line_2, hr_api.g_varchar2) OR
1221: -- =============================
1222: --
1223: IF nvl(hr_loc_shd.g_old_rec.style, hr_api.g_varchar2) <>
1224: nvl(p_rec.style, hr_api.g_varchar2) OR
1225: nvl(hr_loc_shd.g_old_rec.address_line_1, hr_api.g_varchar2) <>
1226: nvl(p_rec.address_line_1, hr_api.g_varchar2) OR
1227: nvl(hr_loc_shd.g_old_rec.address_line_2, hr_api.g_varchar2) <>
1228: nvl(p_rec.address_line_2, hr_api.g_varchar2) OR
1229: nvl(hr_loc_shd.g_old_rec.address_line_3, hr_api.g_varchar2) <>
1222: --
1223: IF nvl(hr_loc_shd.g_old_rec.style, hr_api.g_varchar2) <>
1224: nvl(p_rec.style, hr_api.g_varchar2) OR
1225: nvl(hr_loc_shd.g_old_rec.address_line_1, hr_api.g_varchar2) <>
1226: nvl(p_rec.address_line_1, hr_api.g_varchar2) OR
1227: nvl(hr_loc_shd.g_old_rec.address_line_2, hr_api.g_varchar2) <>
1228: nvl(p_rec.address_line_2, hr_api.g_varchar2) OR
1229: nvl(hr_loc_shd.g_old_rec.address_line_3, hr_api.g_varchar2) <>
1230: nvl(p_rec.address_line_3, hr_api.g_varchar2) OR
1223: IF nvl(hr_loc_shd.g_old_rec.style, hr_api.g_varchar2) <>
1224: nvl(p_rec.style, hr_api.g_varchar2) OR
1225: nvl(hr_loc_shd.g_old_rec.address_line_1, hr_api.g_varchar2) <>
1226: nvl(p_rec.address_line_1, hr_api.g_varchar2) OR
1227: nvl(hr_loc_shd.g_old_rec.address_line_2, hr_api.g_varchar2) <>
1228: nvl(p_rec.address_line_2, hr_api.g_varchar2) OR
1229: nvl(hr_loc_shd.g_old_rec.address_line_3, hr_api.g_varchar2) <>
1230: nvl(p_rec.address_line_3, hr_api.g_varchar2) OR
1231: nvl(hr_loc_shd.g_old_rec.country, hr_api.g_varchar2) <>
1224: nvl(p_rec.style, hr_api.g_varchar2) OR
1225: nvl(hr_loc_shd.g_old_rec.address_line_1, hr_api.g_varchar2) <>
1226: nvl(p_rec.address_line_1, hr_api.g_varchar2) OR
1227: nvl(hr_loc_shd.g_old_rec.address_line_2, hr_api.g_varchar2) <>
1228: nvl(p_rec.address_line_2, hr_api.g_varchar2) OR
1229: nvl(hr_loc_shd.g_old_rec.address_line_3, hr_api.g_varchar2) <>
1230: nvl(p_rec.address_line_3, hr_api.g_varchar2) OR
1231: nvl(hr_loc_shd.g_old_rec.country, hr_api.g_varchar2) <>
1232: nvl(p_rec.country, hr_api.g_varchar2) OR
1225: nvl(hr_loc_shd.g_old_rec.address_line_1, hr_api.g_varchar2) <>
1226: nvl(p_rec.address_line_1, hr_api.g_varchar2) OR
1227: nvl(hr_loc_shd.g_old_rec.address_line_2, hr_api.g_varchar2) <>
1228: nvl(p_rec.address_line_2, hr_api.g_varchar2) OR
1229: nvl(hr_loc_shd.g_old_rec.address_line_3, hr_api.g_varchar2) <>
1230: nvl(p_rec.address_line_3, hr_api.g_varchar2) OR
1231: nvl(hr_loc_shd.g_old_rec.country, hr_api.g_varchar2) <>
1232: nvl(p_rec.country, hr_api.g_varchar2) OR
1233: nvl(hr_loc_shd.g_old_rec.postal_code, hr_api.g_varchar2) <>
1226: nvl(p_rec.address_line_1, hr_api.g_varchar2) OR
1227: nvl(hr_loc_shd.g_old_rec.address_line_2, hr_api.g_varchar2) <>
1228: nvl(p_rec.address_line_2, hr_api.g_varchar2) OR
1229: nvl(hr_loc_shd.g_old_rec.address_line_3, hr_api.g_varchar2) <>
1230: nvl(p_rec.address_line_3, hr_api.g_varchar2) OR
1231: nvl(hr_loc_shd.g_old_rec.country, hr_api.g_varchar2) <>
1232: nvl(p_rec.country, hr_api.g_varchar2) OR
1233: nvl(hr_loc_shd.g_old_rec.postal_code, hr_api.g_varchar2) <>
1234: nvl(p_rec.postal_code, hr_api.g_varchar2) OR
1227: nvl(hr_loc_shd.g_old_rec.address_line_2, hr_api.g_varchar2) <>
1228: nvl(p_rec.address_line_2, hr_api.g_varchar2) OR
1229: nvl(hr_loc_shd.g_old_rec.address_line_3, hr_api.g_varchar2) <>
1230: nvl(p_rec.address_line_3, hr_api.g_varchar2) OR
1231: nvl(hr_loc_shd.g_old_rec.country, hr_api.g_varchar2) <>
1232: nvl(p_rec.country, hr_api.g_varchar2) OR
1233: nvl(hr_loc_shd.g_old_rec.postal_code, hr_api.g_varchar2) <>
1234: nvl(p_rec.postal_code, hr_api.g_varchar2) OR
1235: nvl(hr_loc_shd.g_old_rec.region_1, hr_api.g_varchar2) <>
1228: nvl(p_rec.address_line_2, hr_api.g_varchar2) OR
1229: nvl(hr_loc_shd.g_old_rec.address_line_3, hr_api.g_varchar2) <>
1230: nvl(p_rec.address_line_3, hr_api.g_varchar2) OR
1231: nvl(hr_loc_shd.g_old_rec.country, hr_api.g_varchar2) <>
1232: nvl(p_rec.country, hr_api.g_varchar2) OR
1233: nvl(hr_loc_shd.g_old_rec.postal_code, hr_api.g_varchar2) <>
1234: nvl(p_rec.postal_code, hr_api.g_varchar2) OR
1235: nvl(hr_loc_shd.g_old_rec.region_1, hr_api.g_varchar2) <>
1236: nvl(p_rec.region_1, hr_api.g_varchar2) OR
1229: nvl(hr_loc_shd.g_old_rec.address_line_3, hr_api.g_varchar2) <>
1230: nvl(p_rec.address_line_3, hr_api.g_varchar2) OR
1231: nvl(hr_loc_shd.g_old_rec.country, hr_api.g_varchar2) <>
1232: nvl(p_rec.country, hr_api.g_varchar2) OR
1233: nvl(hr_loc_shd.g_old_rec.postal_code, hr_api.g_varchar2) <>
1234: nvl(p_rec.postal_code, hr_api.g_varchar2) OR
1235: nvl(hr_loc_shd.g_old_rec.region_1, hr_api.g_varchar2) <>
1236: nvl(p_rec.region_1, hr_api.g_varchar2) OR
1237: nvl(hr_loc_shd.g_old_rec.region_2, hr_api.g_varchar2) <>
1230: nvl(p_rec.address_line_3, hr_api.g_varchar2) OR
1231: nvl(hr_loc_shd.g_old_rec.country, hr_api.g_varchar2) <>
1232: nvl(p_rec.country, hr_api.g_varchar2) OR
1233: nvl(hr_loc_shd.g_old_rec.postal_code, hr_api.g_varchar2) <>
1234: nvl(p_rec.postal_code, hr_api.g_varchar2) OR
1235: nvl(hr_loc_shd.g_old_rec.region_1, hr_api.g_varchar2) <>
1236: nvl(p_rec.region_1, hr_api.g_varchar2) OR
1237: nvl(hr_loc_shd.g_old_rec.region_2, hr_api.g_varchar2) <>
1238: nvl(p_rec.region_2, hr_api.g_varchar2) OR
1231: nvl(hr_loc_shd.g_old_rec.country, hr_api.g_varchar2) <>
1232: nvl(p_rec.country, hr_api.g_varchar2) OR
1233: nvl(hr_loc_shd.g_old_rec.postal_code, hr_api.g_varchar2) <>
1234: nvl(p_rec.postal_code, hr_api.g_varchar2) OR
1235: nvl(hr_loc_shd.g_old_rec.region_1, hr_api.g_varchar2) <>
1236: nvl(p_rec.region_1, hr_api.g_varchar2) OR
1237: nvl(hr_loc_shd.g_old_rec.region_2, hr_api.g_varchar2) <>
1238: nvl(p_rec.region_2, hr_api.g_varchar2) OR
1239: nvl(hr_loc_shd.g_old_rec.region_3, hr_api.g_varchar2) <>
1232: nvl(p_rec.country, hr_api.g_varchar2) OR
1233: nvl(hr_loc_shd.g_old_rec.postal_code, hr_api.g_varchar2) <>
1234: nvl(p_rec.postal_code, hr_api.g_varchar2) OR
1235: nvl(hr_loc_shd.g_old_rec.region_1, hr_api.g_varchar2) <>
1236: nvl(p_rec.region_1, hr_api.g_varchar2) OR
1237: nvl(hr_loc_shd.g_old_rec.region_2, hr_api.g_varchar2) <>
1238: nvl(p_rec.region_2, hr_api.g_varchar2) OR
1239: nvl(hr_loc_shd.g_old_rec.region_3, hr_api.g_varchar2) <>
1240: nvl(p_rec.region_3, hr_api.g_varchar2) OR
1233: nvl(hr_loc_shd.g_old_rec.postal_code, hr_api.g_varchar2) <>
1234: nvl(p_rec.postal_code, hr_api.g_varchar2) OR
1235: nvl(hr_loc_shd.g_old_rec.region_1, hr_api.g_varchar2) <>
1236: nvl(p_rec.region_1, hr_api.g_varchar2) OR
1237: nvl(hr_loc_shd.g_old_rec.region_2, hr_api.g_varchar2) <>
1238: nvl(p_rec.region_2, hr_api.g_varchar2) OR
1239: nvl(hr_loc_shd.g_old_rec.region_3, hr_api.g_varchar2) <>
1240: nvl(p_rec.region_3, hr_api.g_varchar2) OR
1241: nvl(hr_loc_shd.g_old_rec.telephone_number_1, hr_api.g_varchar2) <>
1234: nvl(p_rec.postal_code, hr_api.g_varchar2) OR
1235: nvl(hr_loc_shd.g_old_rec.region_1, hr_api.g_varchar2) <>
1236: nvl(p_rec.region_1, hr_api.g_varchar2) OR
1237: nvl(hr_loc_shd.g_old_rec.region_2, hr_api.g_varchar2) <>
1238: nvl(p_rec.region_2, hr_api.g_varchar2) OR
1239: nvl(hr_loc_shd.g_old_rec.region_3, hr_api.g_varchar2) <>
1240: nvl(p_rec.region_3, hr_api.g_varchar2) OR
1241: nvl(hr_loc_shd.g_old_rec.telephone_number_1, hr_api.g_varchar2) <>
1242: nvl(p_rec.telephone_number_1, hr_api.g_varchar2) OR
1235: nvl(hr_loc_shd.g_old_rec.region_1, hr_api.g_varchar2) <>
1236: nvl(p_rec.region_1, hr_api.g_varchar2) OR
1237: nvl(hr_loc_shd.g_old_rec.region_2, hr_api.g_varchar2) <>
1238: nvl(p_rec.region_2, hr_api.g_varchar2) OR
1239: nvl(hr_loc_shd.g_old_rec.region_3, hr_api.g_varchar2) <>
1240: nvl(p_rec.region_3, hr_api.g_varchar2) OR
1241: nvl(hr_loc_shd.g_old_rec.telephone_number_1, hr_api.g_varchar2) <>
1242: nvl(p_rec.telephone_number_1, hr_api.g_varchar2) OR
1243: nvl(hr_loc_shd.g_old_rec.telephone_number_2, hr_api.g_varchar2) <>
1236: nvl(p_rec.region_1, hr_api.g_varchar2) OR
1237: nvl(hr_loc_shd.g_old_rec.region_2, hr_api.g_varchar2) <>
1238: nvl(p_rec.region_2, hr_api.g_varchar2) OR
1239: nvl(hr_loc_shd.g_old_rec.region_3, hr_api.g_varchar2) <>
1240: nvl(p_rec.region_3, hr_api.g_varchar2) OR
1241: nvl(hr_loc_shd.g_old_rec.telephone_number_1, hr_api.g_varchar2) <>
1242: nvl(p_rec.telephone_number_1, hr_api.g_varchar2) OR
1243: nvl(hr_loc_shd.g_old_rec.telephone_number_2, hr_api.g_varchar2) <>
1244: nvl(p_rec.telephone_number_2, hr_api.g_varchar2) OR
1237: nvl(hr_loc_shd.g_old_rec.region_2, hr_api.g_varchar2) <>
1238: nvl(p_rec.region_2, hr_api.g_varchar2) OR
1239: nvl(hr_loc_shd.g_old_rec.region_3, hr_api.g_varchar2) <>
1240: nvl(p_rec.region_3, hr_api.g_varchar2) OR
1241: nvl(hr_loc_shd.g_old_rec.telephone_number_1, hr_api.g_varchar2) <>
1242: nvl(p_rec.telephone_number_1, hr_api.g_varchar2) OR
1243: nvl(hr_loc_shd.g_old_rec.telephone_number_2, hr_api.g_varchar2) <>
1244: nvl(p_rec.telephone_number_2, hr_api.g_varchar2) OR
1245: nvl(hr_loc_shd.g_old_rec.telephone_number_3, hr_api.g_varchar2) <>
1238: nvl(p_rec.region_2, hr_api.g_varchar2) OR
1239: nvl(hr_loc_shd.g_old_rec.region_3, hr_api.g_varchar2) <>
1240: nvl(p_rec.region_3, hr_api.g_varchar2) OR
1241: nvl(hr_loc_shd.g_old_rec.telephone_number_1, hr_api.g_varchar2) <>
1242: nvl(p_rec.telephone_number_1, hr_api.g_varchar2) OR
1243: nvl(hr_loc_shd.g_old_rec.telephone_number_2, hr_api.g_varchar2) <>
1244: nvl(p_rec.telephone_number_2, hr_api.g_varchar2) OR
1245: nvl(hr_loc_shd.g_old_rec.telephone_number_3, hr_api.g_varchar2) <>
1246: nvl(p_rec.telephone_number_3, hr_api.g_varchar2) OR
1239: nvl(hr_loc_shd.g_old_rec.region_3, hr_api.g_varchar2) <>
1240: nvl(p_rec.region_3, hr_api.g_varchar2) OR
1241: nvl(hr_loc_shd.g_old_rec.telephone_number_1, hr_api.g_varchar2) <>
1242: nvl(p_rec.telephone_number_1, hr_api.g_varchar2) OR
1243: nvl(hr_loc_shd.g_old_rec.telephone_number_2, hr_api.g_varchar2) <>
1244: nvl(p_rec.telephone_number_2, hr_api.g_varchar2) OR
1245: nvl(hr_loc_shd.g_old_rec.telephone_number_3, hr_api.g_varchar2) <>
1246: nvl(p_rec.telephone_number_3, hr_api.g_varchar2) OR
1247: nvl(hr_loc_shd.g_old_rec.town_or_city, hr_api.g_varchar2) <>
1240: nvl(p_rec.region_3, hr_api.g_varchar2) OR
1241: nvl(hr_loc_shd.g_old_rec.telephone_number_1, hr_api.g_varchar2) <>
1242: nvl(p_rec.telephone_number_1, hr_api.g_varchar2) OR
1243: nvl(hr_loc_shd.g_old_rec.telephone_number_2, hr_api.g_varchar2) <>
1244: nvl(p_rec.telephone_number_2, hr_api.g_varchar2) OR
1245: nvl(hr_loc_shd.g_old_rec.telephone_number_3, hr_api.g_varchar2) <>
1246: nvl(p_rec.telephone_number_3, hr_api.g_varchar2) OR
1247: nvl(hr_loc_shd.g_old_rec.town_or_city, hr_api.g_varchar2) <>
1248: nvl(p_rec.town_or_city, hr_api.g_varchar2) OR
1241: nvl(hr_loc_shd.g_old_rec.telephone_number_1, hr_api.g_varchar2) <>
1242: nvl(p_rec.telephone_number_1, hr_api.g_varchar2) OR
1243: nvl(hr_loc_shd.g_old_rec.telephone_number_2, hr_api.g_varchar2) <>
1244: nvl(p_rec.telephone_number_2, hr_api.g_varchar2) OR
1245: nvl(hr_loc_shd.g_old_rec.telephone_number_3, hr_api.g_varchar2) <>
1246: nvl(p_rec.telephone_number_3, hr_api.g_varchar2) OR
1247: nvl(hr_loc_shd.g_old_rec.town_or_city, hr_api.g_varchar2) <>
1248: nvl(p_rec.town_or_city, hr_api.g_varchar2) OR
1249: nvl(hr_loc_shd.g_old_rec.loc_information13, hr_api.g_varchar2) <>
1242: nvl(p_rec.telephone_number_1, hr_api.g_varchar2) OR
1243: nvl(hr_loc_shd.g_old_rec.telephone_number_2, hr_api.g_varchar2) <>
1244: nvl(p_rec.telephone_number_2, hr_api.g_varchar2) OR
1245: nvl(hr_loc_shd.g_old_rec.telephone_number_3, hr_api.g_varchar2) <>
1246: nvl(p_rec.telephone_number_3, hr_api.g_varchar2) OR
1247: nvl(hr_loc_shd.g_old_rec.town_or_city, hr_api.g_varchar2) <>
1248: nvl(p_rec.town_or_city, hr_api.g_varchar2) OR
1249: nvl(hr_loc_shd.g_old_rec.loc_information13, hr_api.g_varchar2) <>
1250: nvl(p_rec.loc_information13, hr_api.g_varchar2) OR
1243: nvl(hr_loc_shd.g_old_rec.telephone_number_2, hr_api.g_varchar2) <>
1244: nvl(p_rec.telephone_number_2, hr_api.g_varchar2) OR
1245: nvl(hr_loc_shd.g_old_rec.telephone_number_3, hr_api.g_varchar2) <>
1246: nvl(p_rec.telephone_number_3, hr_api.g_varchar2) OR
1247: nvl(hr_loc_shd.g_old_rec.town_or_city, hr_api.g_varchar2) <>
1248: nvl(p_rec.town_or_city, hr_api.g_varchar2) OR
1249: nvl(hr_loc_shd.g_old_rec.loc_information13, hr_api.g_varchar2) <>
1250: nvl(p_rec.loc_information13, hr_api.g_varchar2) OR
1251: nvl(hr_loc_shd.g_old_rec.loc_information14, hr_api.g_varchar2) <>
1244: nvl(p_rec.telephone_number_2, hr_api.g_varchar2) OR
1245: nvl(hr_loc_shd.g_old_rec.telephone_number_3, hr_api.g_varchar2) <>
1246: nvl(p_rec.telephone_number_3, hr_api.g_varchar2) OR
1247: nvl(hr_loc_shd.g_old_rec.town_or_city, hr_api.g_varchar2) <>
1248: nvl(p_rec.town_or_city, hr_api.g_varchar2) OR
1249: nvl(hr_loc_shd.g_old_rec.loc_information13, hr_api.g_varchar2) <>
1250: nvl(p_rec.loc_information13, hr_api.g_varchar2) OR
1251: nvl(hr_loc_shd.g_old_rec.loc_information14, hr_api.g_varchar2) <>
1252: nvl(p_rec.loc_information14, hr_api.g_varchar2) OR
1245: nvl(hr_loc_shd.g_old_rec.telephone_number_3, hr_api.g_varchar2) <>
1246: nvl(p_rec.telephone_number_3, hr_api.g_varchar2) OR
1247: nvl(hr_loc_shd.g_old_rec.town_or_city, hr_api.g_varchar2) <>
1248: nvl(p_rec.town_or_city, hr_api.g_varchar2) OR
1249: nvl(hr_loc_shd.g_old_rec.loc_information13, hr_api.g_varchar2) <>
1250: nvl(p_rec.loc_information13, hr_api.g_varchar2) OR
1251: nvl(hr_loc_shd.g_old_rec.loc_information14, hr_api.g_varchar2) <>
1252: nvl(p_rec.loc_information14, hr_api.g_varchar2) OR
1253: nvl(hr_loc_shd.g_old_rec.loc_information15, hr_api.g_varchar2) <>
1246: nvl(p_rec.telephone_number_3, hr_api.g_varchar2) OR
1247: nvl(hr_loc_shd.g_old_rec.town_or_city, hr_api.g_varchar2) <>
1248: nvl(p_rec.town_or_city, hr_api.g_varchar2) OR
1249: nvl(hr_loc_shd.g_old_rec.loc_information13, hr_api.g_varchar2) <>
1250: nvl(p_rec.loc_information13, hr_api.g_varchar2) OR
1251: nvl(hr_loc_shd.g_old_rec.loc_information14, hr_api.g_varchar2) <>
1252: nvl(p_rec.loc_information14, hr_api.g_varchar2) OR
1253: nvl(hr_loc_shd.g_old_rec.loc_information15, hr_api.g_varchar2) <>
1254: nvl(p_rec.loc_information15, hr_api.g_varchar2) OR
1247: nvl(hr_loc_shd.g_old_rec.town_or_city, hr_api.g_varchar2) <>
1248: nvl(p_rec.town_or_city, hr_api.g_varchar2) OR
1249: nvl(hr_loc_shd.g_old_rec.loc_information13, hr_api.g_varchar2) <>
1250: nvl(p_rec.loc_information13, hr_api.g_varchar2) OR
1251: nvl(hr_loc_shd.g_old_rec.loc_information14, hr_api.g_varchar2) <>
1252: nvl(p_rec.loc_information14, hr_api.g_varchar2) OR
1253: nvl(hr_loc_shd.g_old_rec.loc_information15, hr_api.g_varchar2) <>
1254: nvl(p_rec.loc_information15, hr_api.g_varchar2) OR
1255: nvl(hr_loc_shd.g_old_rec.loc_information16, hr_api.g_varchar2) <>
1248: nvl(p_rec.town_or_city, hr_api.g_varchar2) OR
1249: nvl(hr_loc_shd.g_old_rec.loc_information13, hr_api.g_varchar2) <>
1250: nvl(p_rec.loc_information13, hr_api.g_varchar2) OR
1251: nvl(hr_loc_shd.g_old_rec.loc_information14, hr_api.g_varchar2) <>
1252: nvl(p_rec.loc_information14, hr_api.g_varchar2) OR
1253: nvl(hr_loc_shd.g_old_rec.loc_information15, hr_api.g_varchar2) <>
1254: nvl(p_rec.loc_information15, hr_api.g_varchar2) OR
1255: nvl(hr_loc_shd.g_old_rec.loc_information16, hr_api.g_varchar2) <>
1256: nvl(p_rec.loc_information16, hr_api.g_varchar2) OR
1249: nvl(hr_loc_shd.g_old_rec.loc_information13, hr_api.g_varchar2) <>
1250: nvl(p_rec.loc_information13, hr_api.g_varchar2) OR
1251: nvl(hr_loc_shd.g_old_rec.loc_information14, hr_api.g_varchar2) <>
1252: nvl(p_rec.loc_information14, hr_api.g_varchar2) OR
1253: nvl(hr_loc_shd.g_old_rec.loc_information15, hr_api.g_varchar2) <>
1254: nvl(p_rec.loc_information15, hr_api.g_varchar2) OR
1255: nvl(hr_loc_shd.g_old_rec.loc_information16, hr_api.g_varchar2) <>
1256: nvl(p_rec.loc_information16, hr_api.g_varchar2) OR
1257: nvl(hr_loc_shd.g_old_rec.loc_information17, hr_api.g_varchar2) <>
1250: nvl(p_rec.loc_information13, hr_api.g_varchar2) OR
1251: nvl(hr_loc_shd.g_old_rec.loc_information14, hr_api.g_varchar2) <>
1252: nvl(p_rec.loc_information14, hr_api.g_varchar2) OR
1253: nvl(hr_loc_shd.g_old_rec.loc_information15, hr_api.g_varchar2) <>
1254: nvl(p_rec.loc_information15, hr_api.g_varchar2) OR
1255: nvl(hr_loc_shd.g_old_rec.loc_information16, hr_api.g_varchar2) <>
1256: nvl(p_rec.loc_information16, hr_api.g_varchar2) OR
1257: nvl(hr_loc_shd.g_old_rec.loc_information17, hr_api.g_varchar2) <>
1258: nvl(p_rec.loc_information17, hr_api.g_varchar2) OR
1251: nvl(hr_loc_shd.g_old_rec.loc_information14, hr_api.g_varchar2) <>
1252: nvl(p_rec.loc_information14, hr_api.g_varchar2) OR
1253: nvl(hr_loc_shd.g_old_rec.loc_information15, hr_api.g_varchar2) <>
1254: nvl(p_rec.loc_information15, hr_api.g_varchar2) OR
1255: nvl(hr_loc_shd.g_old_rec.loc_information16, hr_api.g_varchar2) <>
1256: nvl(p_rec.loc_information16, hr_api.g_varchar2) OR
1257: nvl(hr_loc_shd.g_old_rec.loc_information17, hr_api.g_varchar2) <>
1258: nvl(p_rec.loc_information17, hr_api.g_varchar2) OR
1259: nvl(hr_loc_shd.g_old_rec.loc_information18, hr_api.g_varchar2) <>
1252: nvl(p_rec.loc_information14, hr_api.g_varchar2) OR
1253: nvl(hr_loc_shd.g_old_rec.loc_information15, hr_api.g_varchar2) <>
1254: nvl(p_rec.loc_information15, hr_api.g_varchar2) OR
1255: nvl(hr_loc_shd.g_old_rec.loc_information16, hr_api.g_varchar2) <>
1256: nvl(p_rec.loc_information16, hr_api.g_varchar2) OR
1257: nvl(hr_loc_shd.g_old_rec.loc_information17, hr_api.g_varchar2) <>
1258: nvl(p_rec.loc_information17, hr_api.g_varchar2) OR
1259: nvl(hr_loc_shd.g_old_rec.loc_information18, hr_api.g_varchar2) <>
1260: nvl(p_rec.loc_information18, hr_api.g_varchar2) OR
1253: nvl(hr_loc_shd.g_old_rec.loc_information15, hr_api.g_varchar2) <>
1254: nvl(p_rec.loc_information15, hr_api.g_varchar2) OR
1255: nvl(hr_loc_shd.g_old_rec.loc_information16, hr_api.g_varchar2) <>
1256: nvl(p_rec.loc_information16, hr_api.g_varchar2) OR
1257: nvl(hr_loc_shd.g_old_rec.loc_information17, hr_api.g_varchar2) <>
1258: nvl(p_rec.loc_information17, hr_api.g_varchar2) OR
1259: nvl(hr_loc_shd.g_old_rec.loc_information18, hr_api.g_varchar2) <>
1260: nvl(p_rec.loc_information18, hr_api.g_varchar2) OR
1261: nvl(hr_loc_shd.g_old_rec.loc_information19, hr_api.g_varchar2) <>
1254: nvl(p_rec.loc_information15, hr_api.g_varchar2) OR
1255: nvl(hr_loc_shd.g_old_rec.loc_information16, hr_api.g_varchar2) <>
1256: nvl(p_rec.loc_information16, hr_api.g_varchar2) OR
1257: nvl(hr_loc_shd.g_old_rec.loc_information17, hr_api.g_varchar2) <>
1258: nvl(p_rec.loc_information17, hr_api.g_varchar2) OR
1259: nvl(hr_loc_shd.g_old_rec.loc_information18, hr_api.g_varchar2) <>
1260: nvl(p_rec.loc_information18, hr_api.g_varchar2) OR
1261: nvl(hr_loc_shd.g_old_rec.loc_information19, hr_api.g_varchar2) <>
1262: nvl(p_rec.loc_information19, hr_api.g_varchar2) OR
1255: nvl(hr_loc_shd.g_old_rec.loc_information16, hr_api.g_varchar2) <>
1256: nvl(p_rec.loc_information16, hr_api.g_varchar2) OR
1257: nvl(hr_loc_shd.g_old_rec.loc_information17, hr_api.g_varchar2) <>
1258: nvl(p_rec.loc_information17, hr_api.g_varchar2) OR
1259: nvl(hr_loc_shd.g_old_rec.loc_information18, hr_api.g_varchar2) <>
1260: nvl(p_rec.loc_information18, hr_api.g_varchar2) OR
1261: nvl(hr_loc_shd.g_old_rec.loc_information19, hr_api.g_varchar2) <>
1262: nvl(p_rec.loc_information19, hr_api.g_varchar2) OR
1263: nvl(hr_loc_shd.g_old_rec.loc_information20, hr_api.g_varchar2) <>
1256: nvl(p_rec.loc_information16, hr_api.g_varchar2) OR
1257: nvl(hr_loc_shd.g_old_rec.loc_information17, hr_api.g_varchar2) <>
1258: nvl(p_rec.loc_information17, hr_api.g_varchar2) OR
1259: nvl(hr_loc_shd.g_old_rec.loc_information18, hr_api.g_varchar2) <>
1260: nvl(p_rec.loc_information18, hr_api.g_varchar2) OR
1261: nvl(hr_loc_shd.g_old_rec.loc_information19, hr_api.g_varchar2) <>
1262: nvl(p_rec.loc_information19, hr_api.g_varchar2) OR
1263: nvl(hr_loc_shd.g_old_rec.loc_information20, hr_api.g_varchar2) <>
1264: nvl(p_rec.loc_information20, hr_api.g_varchar2) OR
1257: nvl(hr_loc_shd.g_old_rec.loc_information17, hr_api.g_varchar2) <>
1258: nvl(p_rec.loc_information17, hr_api.g_varchar2) OR
1259: nvl(hr_loc_shd.g_old_rec.loc_information18, hr_api.g_varchar2) <>
1260: nvl(p_rec.loc_information18, hr_api.g_varchar2) OR
1261: nvl(hr_loc_shd.g_old_rec.loc_information19, hr_api.g_varchar2) <>
1262: nvl(p_rec.loc_information19, hr_api.g_varchar2) OR
1263: nvl(hr_loc_shd.g_old_rec.loc_information20, hr_api.g_varchar2) <>
1264: nvl(p_rec.loc_information20, hr_api.g_varchar2) OR
1265: (p_rec.location_id IS NULL)
1258: nvl(p_rec.loc_information17, hr_api.g_varchar2) OR
1259: nvl(hr_loc_shd.g_old_rec.loc_information18, hr_api.g_varchar2) <>
1260: nvl(p_rec.loc_information18, hr_api.g_varchar2) OR
1261: nvl(hr_loc_shd.g_old_rec.loc_information19, hr_api.g_varchar2) <>
1262: nvl(p_rec.loc_information19, hr_api.g_varchar2) OR
1263: nvl(hr_loc_shd.g_old_rec.loc_information20, hr_api.g_varchar2) <>
1264: nvl(p_rec.loc_information20, hr_api.g_varchar2) OR
1265: (p_rec.location_id IS NULL)
1266: THEN
1259: nvl(hr_loc_shd.g_old_rec.loc_information18, hr_api.g_varchar2) <>
1260: nvl(p_rec.loc_information18, hr_api.g_varchar2) OR
1261: nvl(hr_loc_shd.g_old_rec.loc_information19, hr_api.g_varchar2) <>
1262: nvl(p_rec.loc_information19, hr_api.g_varchar2) OR
1263: nvl(hr_loc_shd.g_old_rec.loc_information20, hr_api.g_varchar2) <>
1264: nvl(p_rec.loc_information20, hr_api.g_varchar2) OR
1265: (p_rec.location_id IS NULL)
1266: THEN
1267: -- Only execute the validation if absolutely necessary:
1260: nvl(p_rec.loc_information18, hr_api.g_varchar2) OR
1261: nvl(hr_loc_shd.g_old_rec.loc_information19, hr_api.g_varchar2) <>
1262: nvl(p_rec.loc_information19, hr_api.g_varchar2) OR
1263: nvl(hr_loc_shd.g_old_rec.loc_information20, hr_api.g_varchar2) <>
1264: nvl(p_rec.loc_information20, hr_api.g_varchar2) OR
1265: (p_rec.location_id IS NULL)
1266: THEN
1267: -- Only execute the validation if absolutely necessary:
1268: -- a) During update, the structure column value or any
1320: --
1321: -- HR_LOCATIONS - flexible address DDF
1322: -- ===================================
1323: --
1324: IF nvl(hr_loc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1325: nvl(p_rec.attribute_category, hr_api.g_varchar2) OR
1326: nvl(hr_loc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1327: nvl(p_rec.attribute1, hr_api.g_varchar2) OR
1328: nvl(hr_loc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1321: -- HR_LOCATIONS - flexible address DDF
1322: -- ===================================
1323: --
1324: IF nvl(hr_loc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1325: nvl(p_rec.attribute_category, hr_api.g_varchar2) OR
1326: nvl(hr_loc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1327: nvl(p_rec.attribute1, hr_api.g_varchar2) OR
1328: nvl(hr_loc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1329: nvl(p_rec.attribute2, hr_api.g_varchar2) OR
1322: -- ===================================
1323: --
1324: IF nvl(hr_loc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1325: nvl(p_rec.attribute_category, hr_api.g_varchar2) OR
1326: nvl(hr_loc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1327: nvl(p_rec.attribute1, hr_api.g_varchar2) OR
1328: nvl(hr_loc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1329: nvl(p_rec.attribute2, hr_api.g_varchar2) OR
1330: nvl(hr_loc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1323: --
1324: IF nvl(hr_loc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1325: nvl(p_rec.attribute_category, hr_api.g_varchar2) OR
1326: nvl(hr_loc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1327: nvl(p_rec.attribute1, hr_api.g_varchar2) OR
1328: nvl(hr_loc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1329: nvl(p_rec.attribute2, hr_api.g_varchar2) OR
1330: nvl(hr_loc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1331: nvl(p_rec.attribute3, hr_api.g_varchar2) OR
1324: IF nvl(hr_loc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1325: nvl(p_rec.attribute_category, hr_api.g_varchar2) OR
1326: nvl(hr_loc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1327: nvl(p_rec.attribute1, hr_api.g_varchar2) OR
1328: nvl(hr_loc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1329: nvl(p_rec.attribute2, hr_api.g_varchar2) OR
1330: nvl(hr_loc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1331: nvl(p_rec.attribute3, hr_api.g_varchar2) OR
1332: nvl(hr_loc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1325: nvl(p_rec.attribute_category, hr_api.g_varchar2) OR
1326: nvl(hr_loc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1327: nvl(p_rec.attribute1, hr_api.g_varchar2) OR
1328: nvl(hr_loc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1329: nvl(p_rec.attribute2, hr_api.g_varchar2) OR
1330: nvl(hr_loc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1331: nvl(p_rec.attribute3, hr_api.g_varchar2) OR
1332: nvl(hr_loc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1333: nvl(p_rec.attribute4, hr_api.g_varchar2) OR
1326: nvl(hr_loc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1327: nvl(p_rec.attribute1, hr_api.g_varchar2) OR
1328: nvl(hr_loc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1329: nvl(p_rec.attribute2, hr_api.g_varchar2) OR
1330: nvl(hr_loc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1331: nvl(p_rec.attribute3, hr_api.g_varchar2) OR
1332: nvl(hr_loc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1333: nvl(p_rec.attribute4, hr_api.g_varchar2) OR
1334: nvl(hr_loc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1327: nvl(p_rec.attribute1, hr_api.g_varchar2) OR
1328: nvl(hr_loc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1329: nvl(p_rec.attribute2, hr_api.g_varchar2) OR
1330: nvl(hr_loc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1331: nvl(p_rec.attribute3, hr_api.g_varchar2) OR
1332: nvl(hr_loc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1333: nvl(p_rec.attribute4, hr_api.g_varchar2) OR
1334: nvl(hr_loc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1335: nvl(p_rec.attribute5, hr_api.g_varchar2) OR
1328: nvl(hr_loc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1329: nvl(p_rec.attribute2, hr_api.g_varchar2) OR
1330: nvl(hr_loc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1331: nvl(p_rec.attribute3, hr_api.g_varchar2) OR
1332: nvl(hr_loc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1333: nvl(p_rec.attribute4, hr_api.g_varchar2) OR
1334: nvl(hr_loc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1335: nvl(p_rec.attribute5, hr_api.g_varchar2) OR
1336: nvl(hr_loc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1329: nvl(p_rec.attribute2, hr_api.g_varchar2) OR
1330: nvl(hr_loc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1331: nvl(p_rec.attribute3, hr_api.g_varchar2) OR
1332: nvl(hr_loc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1333: nvl(p_rec.attribute4, hr_api.g_varchar2) OR
1334: nvl(hr_loc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1335: nvl(p_rec.attribute5, hr_api.g_varchar2) OR
1336: nvl(hr_loc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1337: nvl(p_rec.attribute6, hr_api.g_varchar2) OR
1330: nvl(hr_loc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1331: nvl(p_rec.attribute3, hr_api.g_varchar2) OR
1332: nvl(hr_loc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1333: nvl(p_rec.attribute4, hr_api.g_varchar2) OR
1334: nvl(hr_loc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1335: nvl(p_rec.attribute5, hr_api.g_varchar2) OR
1336: nvl(hr_loc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1337: nvl(p_rec.attribute6, hr_api.g_varchar2) OR
1338: nvl(hr_loc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1331: nvl(p_rec.attribute3, hr_api.g_varchar2) OR
1332: nvl(hr_loc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1333: nvl(p_rec.attribute4, hr_api.g_varchar2) OR
1334: nvl(hr_loc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1335: nvl(p_rec.attribute5, hr_api.g_varchar2) OR
1336: nvl(hr_loc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1337: nvl(p_rec.attribute6, hr_api.g_varchar2) OR
1338: nvl(hr_loc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1339: nvl(p_rec.attribute7, hr_api.g_varchar2) OR
1332: nvl(hr_loc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1333: nvl(p_rec.attribute4, hr_api.g_varchar2) OR
1334: nvl(hr_loc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1335: nvl(p_rec.attribute5, hr_api.g_varchar2) OR
1336: nvl(hr_loc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1337: nvl(p_rec.attribute6, hr_api.g_varchar2) OR
1338: nvl(hr_loc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1339: nvl(p_rec.attribute7, hr_api.g_varchar2) OR
1340: nvl(hr_loc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1333: nvl(p_rec.attribute4, hr_api.g_varchar2) OR
1334: nvl(hr_loc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1335: nvl(p_rec.attribute5, hr_api.g_varchar2) OR
1336: nvl(hr_loc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1337: nvl(p_rec.attribute6, hr_api.g_varchar2) OR
1338: nvl(hr_loc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1339: nvl(p_rec.attribute7, hr_api.g_varchar2) OR
1340: nvl(hr_loc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1341: nvl(p_rec.attribute8, hr_api.g_varchar2) OR
1334: nvl(hr_loc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1335: nvl(p_rec.attribute5, hr_api.g_varchar2) OR
1336: nvl(hr_loc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1337: nvl(p_rec.attribute6, hr_api.g_varchar2) OR
1338: nvl(hr_loc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1339: nvl(p_rec.attribute7, hr_api.g_varchar2) OR
1340: nvl(hr_loc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1341: nvl(p_rec.attribute8, hr_api.g_varchar2) OR
1342: nvl(hr_loc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1335: nvl(p_rec.attribute5, hr_api.g_varchar2) OR
1336: nvl(hr_loc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1337: nvl(p_rec.attribute6, hr_api.g_varchar2) OR
1338: nvl(hr_loc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1339: nvl(p_rec.attribute7, hr_api.g_varchar2) OR
1340: nvl(hr_loc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1341: nvl(p_rec.attribute8, hr_api.g_varchar2) OR
1342: nvl(hr_loc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1343: nvl(p_rec.attribute9, hr_api.g_varchar2) OR
1336: nvl(hr_loc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1337: nvl(p_rec.attribute6, hr_api.g_varchar2) OR
1338: nvl(hr_loc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1339: nvl(p_rec.attribute7, hr_api.g_varchar2) OR
1340: nvl(hr_loc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1341: nvl(p_rec.attribute8, hr_api.g_varchar2) OR
1342: nvl(hr_loc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1343: nvl(p_rec.attribute9, hr_api.g_varchar2) OR
1344: nvl(hr_loc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1337: nvl(p_rec.attribute6, hr_api.g_varchar2) OR
1338: nvl(hr_loc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1339: nvl(p_rec.attribute7, hr_api.g_varchar2) OR
1340: nvl(hr_loc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1341: nvl(p_rec.attribute8, hr_api.g_varchar2) OR
1342: nvl(hr_loc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1343: nvl(p_rec.attribute9, hr_api.g_varchar2) OR
1344: nvl(hr_loc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1345: nvl(p_rec.attribute10, hr_api.g_varchar2) OR
1338: nvl(hr_loc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1339: nvl(p_rec.attribute7, hr_api.g_varchar2) OR
1340: nvl(hr_loc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1341: nvl(p_rec.attribute8, hr_api.g_varchar2) OR
1342: nvl(hr_loc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1343: nvl(p_rec.attribute9, hr_api.g_varchar2) OR
1344: nvl(hr_loc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1345: nvl(p_rec.attribute10, hr_api.g_varchar2) OR
1346: nvl(hr_loc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1339: nvl(p_rec.attribute7, hr_api.g_varchar2) OR
1340: nvl(hr_loc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1341: nvl(p_rec.attribute8, hr_api.g_varchar2) OR
1342: nvl(hr_loc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1343: nvl(p_rec.attribute9, hr_api.g_varchar2) OR
1344: nvl(hr_loc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1345: nvl(p_rec.attribute10, hr_api.g_varchar2) OR
1346: nvl(hr_loc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1347: nvl(p_rec.attribute11, hr_api.g_varchar2) OR
1340: nvl(hr_loc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1341: nvl(p_rec.attribute8, hr_api.g_varchar2) OR
1342: nvl(hr_loc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1343: nvl(p_rec.attribute9, hr_api.g_varchar2) OR
1344: nvl(hr_loc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1345: nvl(p_rec.attribute10, hr_api.g_varchar2) OR
1346: nvl(hr_loc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1347: nvl(p_rec.attribute11, hr_api.g_varchar2) OR
1348: nvl(hr_loc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1341: nvl(p_rec.attribute8, hr_api.g_varchar2) OR
1342: nvl(hr_loc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1343: nvl(p_rec.attribute9, hr_api.g_varchar2) OR
1344: nvl(hr_loc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1345: nvl(p_rec.attribute10, hr_api.g_varchar2) OR
1346: nvl(hr_loc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1347: nvl(p_rec.attribute11, hr_api.g_varchar2) OR
1348: nvl(hr_loc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1349: nvl(p_rec.attribute12, hr_api.g_varchar2) OR
1342: nvl(hr_loc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1343: nvl(p_rec.attribute9, hr_api.g_varchar2) OR
1344: nvl(hr_loc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1345: nvl(p_rec.attribute10, hr_api.g_varchar2) OR
1346: nvl(hr_loc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1347: nvl(p_rec.attribute11, hr_api.g_varchar2) OR
1348: nvl(hr_loc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1349: nvl(p_rec.attribute12, hr_api.g_varchar2) OR
1350: nvl(hr_loc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1343: nvl(p_rec.attribute9, hr_api.g_varchar2) OR
1344: nvl(hr_loc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1345: nvl(p_rec.attribute10, hr_api.g_varchar2) OR
1346: nvl(hr_loc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1347: nvl(p_rec.attribute11, hr_api.g_varchar2) OR
1348: nvl(hr_loc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1349: nvl(p_rec.attribute12, hr_api.g_varchar2) OR
1350: nvl(hr_loc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1351: nvl(p_rec.attribute13, hr_api.g_varchar2) OR
1344: nvl(hr_loc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1345: nvl(p_rec.attribute10, hr_api.g_varchar2) OR
1346: nvl(hr_loc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1347: nvl(p_rec.attribute11, hr_api.g_varchar2) OR
1348: nvl(hr_loc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1349: nvl(p_rec.attribute12, hr_api.g_varchar2) OR
1350: nvl(hr_loc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1351: nvl(p_rec.attribute13, hr_api.g_varchar2) OR
1352: nvl(hr_loc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1345: nvl(p_rec.attribute10, hr_api.g_varchar2) OR
1346: nvl(hr_loc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1347: nvl(p_rec.attribute11, hr_api.g_varchar2) OR
1348: nvl(hr_loc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1349: nvl(p_rec.attribute12, hr_api.g_varchar2) OR
1350: nvl(hr_loc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1351: nvl(p_rec.attribute13, hr_api.g_varchar2) OR
1352: nvl(hr_loc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1353: nvl(p_rec.attribute14, hr_api.g_varchar2) OR
1346: nvl(hr_loc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1347: nvl(p_rec.attribute11, hr_api.g_varchar2) OR
1348: nvl(hr_loc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1349: nvl(p_rec.attribute12, hr_api.g_varchar2) OR
1350: nvl(hr_loc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1351: nvl(p_rec.attribute13, hr_api.g_varchar2) OR
1352: nvl(hr_loc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1353: nvl(p_rec.attribute14, hr_api.g_varchar2) OR
1354: nvl(hr_loc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1347: nvl(p_rec.attribute11, hr_api.g_varchar2) OR
1348: nvl(hr_loc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1349: nvl(p_rec.attribute12, hr_api.g_varchar2) OR
1350: nvl(hr_loc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1351: nvl(p_rec.attribute13, hr_api.g_varchar2) OR
1352: nvl(hr_loc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1353: nvl(p_rec.attribute14, hr_api.g_varchar2) OR
1354: nvl(hr_loc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1355: nvl(p_rec.attribute15, hr_api.g_varchar2) OR
1348: nvl(hr_loc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1349: nvl(p_rec.attribute12, hr_api.g_varchar2) OR
1350: nvl(hr_loc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1351: nvl(p_rec.attribute13, hr_api.g_varchar2) OR
1352: nvl(hr_loc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1353: nvl(p_rec.attribute14, hr_api.g_varchar2) OR
1354: nvl(hr_loc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1355: nvl(p_rec.attribute15, hr_api.g_varchar2) OR
1356: nvl(hr_loc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1349: nvl(p_rec.attribute12, hr_api.g_varchar2) OR
1350: nvl(hr_loc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1351: nvl(p_rec.attribute13, hr_api.g_varchar2) OR
1352: nvl(hr_loc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1353: nvl(p_rec.attribute14, hr_api.g_varchar2) OR
1354: nvl(hr_loc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1355: nvl(p_rec.attribute15, hr_api.g_varchar2) OR
1356: nvl(hr_loc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1357: nvl(p_rec.attribute16, hr_api.g_varchar2) OR
1350: nvl(hr_loc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1351: nvl(p_rec.attribute13, hr_api.g_varchar2) OR
1352: nvl(hr_loc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1353: nvl(p_rec.attribute14, hr_api.g_varchar2) OR
1354: nvl(hr_loc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1355: nvl(p_rec.attribute15, hr_api.g_varchar2) OR
1356: nvl(hr_loc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1357: nvl(p_rec.attribute16, hr_api.g_varchar2) OR
1358: nvl(hr_loc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1351: nvl(p_rec.attribute13, hr_api.g_varchar2) OR
1352: nvl(hr_loc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1353: nvl(p_rec.attribute14, hr_api.g_varchar2) OR
1354: nvl(hr_loc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1355: nvl(p_rec.attribute15, hr_api.g_varchar2) OR
1356: nvl(hr_loc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1357: nvl(p_rec.attribute16, hr_api.g_varchar2) OR
1358: nvl(hr_loc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1359: nvl(p_rec.attribute17, hr_api.g_varchar2) OR
1352: nvl(hr_loc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1353: nvl(p_rec.attribute14, hr_api.g_varchar2) OR
1354: nvl(hr_loc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1355: nvl(p_rec.attribute15, hr_api.g_varchar2) OR
1356: nvl(hr_loc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1357: nvl(p_rec.attribute16, hr_api.g_varchar2) OR
1358: nvl(hr_loc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1359: nvl(p_rec.attribute17, hr_api.g_varchar2) OR
1360: nvl(hr_loc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1353: nvl(p_rec.attribute14, hr_api.g_varchar2) OR
1354: nvl(hr_loc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1355: nvl(p_rec.attribute15, hr_api.g_varchar2) OR
1356: nvl(hr_loc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1357: nvl(p_rec.attribute16, hr_api.g_varchar2) OR
1358: nvl(hr_loc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1359: nvl(p_rec.attribute17, hr_api.g_varchar2) OR
1360: nvl(hr_loc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1361: nvl(p_rec.attribute18, hr_api.g_varchar2) OR
1354: nvl(hr_loc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1355: nvl(p_rec.attribute15, hr_api.g_varchar2) OR
1356: nvl(hr_loc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1357: nvl(p_rec.attribute16, hr_api.g_varchar2) OR
1358: nvl(hr_loc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1359: nvl(p_rec.attribute17, hr_api.g_varchar2) OR
1360: nvl(hr_loc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1361: nvl(p_rec.attribute18, hr_api.g_varchar2) OR
1362: nvl(hr_loc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1355: nvl(p_rec.attribute15, hr_api.g_varchar2) OR
1356: nvl(hr_loc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1357: nvl(p_rec.attribute16, hr_api.g_varchar2) OR
1358: nvl(hr_loc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1359: nvl(p_rec.attribute17, hr_api.g_varchar2) OR
1360: nvl(hr_loc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1361: nvl(p_rec.attribute18, hr_api.g_varchar2) OR
1362: nvl(hr_loc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1363: nvl(p_rec.attribute19, hr_api.g_varchar2) OR
1356: nvl(hr_loc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1357: nvl(p_rec.attribute16, hr_api.g_varchar2) OR
1358: nvl(hr_loc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1359: nvl(p_rec.attribute17, hr_api.g_varchar2) OR
1360: nvl(hr_loc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1361: nvl(p_rec.attribute18, hr_api.g_varchar2) OR
1362: nvl(hr_loc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1363: nvl(p_rec.attribute19, hr_api.g_varchar2) OR
1364: nvl(hr_loc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1357: nvl(p_rec.attribute16, hr_api.g_varchar2) OR
1358: nvl(hr_loc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1359: nvl(p_rec.attribute17, hr_api.g_varchar2) OR
1360: nvl(hr_loc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1361: nvl(p_rec.attribute18, hr_api.g_varchar2) OR
1362: nvl(hr_loc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1363: nvl(p_rec.attribute19, hr_api.g_varchar2) OR
1364: nvl(hr_loc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1365: nvl(p_rec.attribute20, hr_api.g_varchar2)
1358: nvl(hr_loc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1359: nvl(p_rec.attribute17, hr_api.g_varchar2) OR
1360: nvl(hr_loc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1361: nvl(p_rec.attribute18, hr_api.g_varchar2) OR
1362: nvl(hr_loc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1363: nvl(p_rec.attribute19, hr_api.g_varchar2) OR
1364: nvl(hr_loc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1365: nvl(p_rec.attribute20, hr_api.g_varchar2)
1366: OR
1359: nvl(p_rec.attribute17, hr_api.g_varchar2) OR
1360: nvl(hr_loc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1361: nvl(p_rec.attribute18, hr_api.g_varchar2) OR
1362: nvl(hr_loc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1363: nvl(p_rec.attribute19, hr_api.g_varchar2) OR
1364: nvl(hr_loc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1365: nvl(p_rec.attribute20, hr_api.g_varchar2)
1366: OR
1367: (p_rec.location_id IS NULL)
1360: nvl(hr_loc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1361: nvl(p_rec.attribute18, hr_api.g_varchar2) OR
1362: nvl(hr_loc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1363: nvl(p_rec.attribute19, hr_api.g_varchar2) OR
1364: nvl(hr_loc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1365: nvl(p_rec.attribute20, hr_api.g_varchar2)
1366: OR
1367: (p_rec.location_id IS NULL)
1368: THEN
1361: nvl(p_rec.attribute18, hr_api.g_varchar2) OR
1362: nvl(hr_loc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1363: nvl(p_rec.attribute19, hr_api.g_varchar2) OR
1364: nvl(hr_loc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1365: nvl(p_rec.attribute20, hr_api.g_varchar2)
1366: OR
1367: (p_rec.location_id IS NULL)
1368: THEN
1369: -- Only execute the validation if absolutely necessary:
1422: --
1423: -- JG_HR_LOCATIONS - global localizations DDF
1424: -- ==========================================
1425: --
1426: IF nvl(hr_loc_shd.g_old_rec.global_attribute_category, hr_api.g_varchar2) <>
1427: nvl(p_rec.global_attribute_category, hr_api.g_varchar2) OR
1428: nvl(hr_loc_shd.g_old_rec.global_attribute1, hr_api.g_varchar2) <>
1429: nvl(p_rec.global_attribute1, hr_api.g_varchar2) OR
1430: nvl(hr_loc_shd.g_old_rec.global_attribute2, hr_api.g_varchar2) <>
1423: -- JG_HR_LOCATIONS - global localizations DDF
1424: -- ==========================================
1425: --
1426: IF nvl(hr_loc_shd.g_old_rec.global_attribute_category, hr_api.g_varchar2) <>
1427: nvl(p_rec.global_attribute_category, hr_api.g_varchar2) OR
1428: nvl(hr_loc_shd.g_old_rec.global_attribute1, hr_api.g_varchar2) <>
1429: nvl(p_rec.global_attribute1, hr_api.g_varchar2) OR
1430: nvl(hr_loc_shd.g_old_rec.global_attribute2, hr_api.g_varchar2) <>
1431: nvl(p_rec.global_attribute2, hr_api.g_varchar2) OR
1424: -- ==========================================
1425: --
1426: IF nvl(hr_loc_shd.g_old_rec.global_attribute_category, hr_api.g_varchar2) <>
1427: nvl(p_rec.global_attribute_category, hr_api.g_varchar2) OR
1428: nvl(hr_loc_shd.g_old_rec.global_attribute1, hr_api.g_varchar2) <>
1429: nvl(p_rec.global_attribute1, hr_api.g_varchar2) OR
1430: nvl(hr_loc_shd.g_old_rec.global_attribute2, hr_api.g_varchar2) <>
1431: nvl(p_rec.global_attribute2, hr_api.g_varchar2) OR
1432: nvl(hr_loc_shd.g_old_rec.global_attribute3, hr_api.g_varchar2) <>
1425: --
1426: IF nvl(hr_loc_shd.g_old_rec.global_attribute_category, hr_api.g_varchar2) <>
1427: nvl(p_rec.global_attribute_category, hr_api.g_varchar2) OR
1428: nvl(hr_loc_shd.g_old_rec.global_attribute1, hr_api.g_varchar2) <>
1429: nvl(p_rec.global_attribute1, hr_api.g_varchar2) OR
1430: nvl(hr_loc_shd.g_old_rec.global_attribute2, hr_api.g_varchar2) <>
1431: nvl(p_rec.global_attribute2, hr_api.g_varchar2) OR
1432: nvl(hr_loc_shd.g_old_rec.global_attribute3, hr_api.g_varchar2) <>
1433: nvl(p_rec.global_attribute3, hr_api.g_varchar2) OR
1426: IF nvl(hr_loc_shd.g_old_rec.global_attribute_category, hr_api.g_varchar2) <>
1427: nvl(p_rec.global_attribute_category, hr_api.g_varchar2) OR
1428: nvl(hr_loc_shd.g_old_rec.global_attribute1, hr_api.g_varchar2) <>
1429: nvl(p_rec.global_attribute1, hr_api.g_varchar2) OR
1430: nvl(hr_loc_shd.g_old_rec.global_attribute2, hr_api.g_varchar2) <>
1431: nvl(p_rec.global_attribute2, hr_api.g_varchar2) OR
1432: nvl(hr_loc_shd.g_old_rec.global_attribute3, hr_api.g_varchar2) <>
1433: nvl(p_rec.global_attribute3, hr_api.g_varchar2) OR
1434: nvl(hr_loc_shd.g_old_rec.global_attribute4, hr_api.g_varchar2) <>
1427: nvl(p_rec.global_attribute_category, hr_api.g_varchar2) OR
1428: nvl(hr_loc_shd.g_old_rec.global_attribute1, hr_api.g_varchar2) <>
1429: nvl(p_rec.global_attribute1, hr_api.g_varchar2) OR
1430: nvl(hr_loc_shd.g_old_rec.global_attribute2, hr_api.g_varchar2) <>
1431: nvl(p_rec.global_attribute2, hr_api.g_varchar2) OR
1432: nvl(hr_loc_shd.g_old_rec.global_attribute3, hr_api.g_varchar2) <>
1433: nvl(p_rec.global_attribute3, hr_api.g_varchar2) OR
1434: nvl(hr_loc_shd.g_old_rec.global_attribute4, hr_api.g_varchar2) <>
1435: nvl(p_rec.global_attribute4, hr_api.g_varchar2) OR
1428: nvl(hr_loc_shd.g_old_rec.global_attribute1, hr_api.g_varchar2) <>
1429: nvl(p_rec.global_attribute1, hr_api.g_varchar2) OR
1430: nvl(hr_loc_shd.g_old_rec.global_attribute2, hr_api.g_varchar2) <>
1431: nvl(p_rec.global_attribute2, hr_api.g_varchar2) OR
1432: nvl(hr_loc_shd.g_old_rec.global_attribute3, hr_api.g_varchar2) <>
1433: nvl(p_rec.global_attribute3, hr_api.g_varchar2) OR
1434: nvl(hr_loc_shd.g_old_rec.global_attribute4, hr_api.g_varchar2) <>
1435: nvl(p_rec.global_attribute4, hr_api.g_varchar2) OR
1436: nvl(hr_loc_shd.g_old_rec.global_attribute5, hr_api.g_varchar2) <>
1429: nvl(p_rec.global_attribute1, hr_api.g_varchar2) OR
1430: nvl(hr_loc_shd.g_old_rec.global_attribute2, hr_api.g_varchar2) <>
1431: nvl(p_rec.global_attribute2, hr_api.g_varchar2) OR
1432: nvl(hr_loc_shd.g_old_rec.global_attribute3, hr_api.g_varchar2) <>
1433: nvl(p_rec.global_attribute3, hr_api.g_varchar2) OR
1434: nvl(hr_loc_shd.g_old_rec.global_attribute4, hr_api.g_varchar2) <>
1435: nvl(p_rec.global_attribute4, hr_api.g_varchar2) OR
1436: nvl(hr_loc_shd.g_old_rec.global_attribute5, hr_api.g_varchar2) <>
1437: nvl(p_rec.global_attribute5, hr_api.g_varchar2) OR
1430: nvl(hr_loc_shd.g_old_rec.global_attribute2, hr_api.g_varchar2) <>
1431: nvl(p_rec.global_attribute2, hr_api.g_varchar2) OR
1432: nvl(hr_loc_shd.g_old_rec.global_attribute3, hr_api.g_varchar2) <>
1433: nvl(p_rec.global_attribute3, hr_api.g_varchar2) OR
1434: nvl(hr_loc_shd.g_old_rec.global_attribute4, hr_api.g_varchar2) <>
1435: nvl(p_rec.global_attribute4, hr_api.g_varchar2) OR
1436: nvl(hr_loc_shd.g_old_rec.global_attribute5, hr_api.g_varchar2) <>
1437: nvl(p_rec.global_attribute5, hr_api.g_varchar2) OR
1438: nvl(hr_loc_shd.g_old_rec.global_attribute6, hr_api.g_varchar2) <>
1431: nvl(p_rec.global_attribute2, hr_api.g_varchar2) OR
1432: nvl(hr_loc_shd.g_old_rec.global_attribute3, hr_api.g_varchar2) <>
1433: nvl(p_rec.global_attribute3, hr_api.g_varchar2) OR
1434: nvl(hr_loc_shd.g_old_rec.global_attribute4, hr_api.g_varchar2) <>
1435: nvl(p_rec.global_attribute4, hr_api.g_varchar2) OR
1436: nvl(hr_loc_shd.g_old_rec.global_attribute5, hr_api.g_varchar2) <>
1437: nvl(p_rec.global_attribute5, hr_api.g_varchar2) OR
1438: nvl(hr_loc_shd.g_old_rec.global_attribute6, hr_api.g_varchar2) <>
1439: nvl(p_rec.global_attribute6, hr_api.g_varchar2) OR
1432: nvl(hr_loc_shd.g_old_rec.global_attribute3, hr_api.g_varchar2) <>
1433: nvl(p_rec.global_attribute3, hr_api.g_varchar2) OR
1434: nvl(hr_loc_shd.g_old_rec.global_attribute4, hr_api.g_varchar2) <>
1435: nvl(p_rec.global_attribute4, hr_api.g_varchar2) OR
1436: nvl(hr_loc_shd.g_old_rec.global_attribute5, hr_api.g_varchar2) <>
1437: nvl(p_rec.global_attribute5, hr_api.g_varchar2) OR
1438: nvl(hr_loc_shd.g_old_rec.global_attribute6, hr_api.g_varchar2) <>
1439: nvl(p_rec.global_attribute6, hr_api.g_varchar2) OR
1440: nvl(hr_loc_shd.g_old_rec.global_attribute7, hr_api.g_varchar2) <>
1433: nvl(p_rec.global_attribute3, hr_api.g_varchar2) OR
1434: nvl(hr_loc_shd.g_old_rec.global_attribute4, hr_api.g_varchar2) <>
1435: nvl(p_rec.global_attribute4, hr_api.g_varchar2) OR
1436: nvl(hr_loc_shd.g_old_rec.global_attribute5, hr_api.g_varchar2) <>
1437: nvl(p_rec.global_attribute5, hr_api.g_varchar2) OR
1438: nvl(hr_loc_shd.g_old_rec.global_attribute6, hr_api.g_varchar2) <>
1439: nvl(p_rec.global_attribute6, hr_api.g_varchar2) OR
1440: nvl(hr_loc_shd.g_old_rec.global_attribute7, hr_api.g_varchar2) <>
1441: nvl(p_rec.global_attribute7, hr_api.g_varchar2) OR
1434: nvl(hr_loc_shd.g_old_rec.global_attribute4, hr_api.g_varchar2) <>
1435: nvl(p_rec.global_attribute4, hr_api.g_varchar2) OR
1436: nvl(hr_loc_shd.g_old_rec.global_attribute5, hr_api.g_varchar2) <>
1437: nvl(p_rec.global_attribute5, hr_api.g_varchar2) OR
1438: nvl(hr_loc_shd.g_old_rec.global_attribute6, hr_api.g_varchar2) <>
1439: nvl(p_rec.global_attribute6, hr_api.g_varchar2) OR
1440: nvl(hr_loc_shd.g_old_rec.global_attribute7, hr_api.g_varchar2) <>
1441: nvl(p_rec.global_attribute7, hr_api.g_varchar2) OR
1442: nvl(hr_loc_shd.g_old_rec.global_attribute8, hr_api.g_varchar2) <>
1435: nvl(p_rec.global_attribute4, hr_api.g_varchar2) OR
1436: nvl(hr_loc_shd.g_old_rec.global_attribute5, hr_api.g_varchar2) <>
1437: nvl(p_rec.global_attribute5, hr_api.g_varchar2) OR
1438: nvl(hr_loc_shd.g_old_rec.global_attribute6, hr_api.g_varchar2) <>
1439: nvl(p_rec.global_attribute6, hr_api.g_varchar2) OR
1440: nvl(hr_loc_shd.g_old_rec.global_attribute7, hr_api.g_varchar2) <>
1441: nvl(p_rec.global_attribute7, hr_api.g_varchar2) OR
1442: nvl(hr_loc_shd.g_old_rec.global_attribute8, hr_api.g_varchar2) <>
1443: nvl(p_rec.global_attribute8, hr_api.g_varchar2) OR
1436: nvl(hr_loc_shd.g_old_rec.global_attribute5, hr_api.g_varchar2) <>
1437: nvl(p_rec.global_attribute5, hr_api.g_varchar2) OR
1438: nvl(hr_loc_shd.g_old_rec.global_attribute6, hr_api.g_varchar2) <>
1439: nvl(p_rec.global_attribute6, hr_api.g_varchar2) OR
1440: nvl(hr_loc_shd.g_old_rec.global_attribute7, hr_api.g_varchar2) <>
1441: nvl(p_rec.global_attribute7, hr_api.g_varchar2) OR
1442: nvl(hr_loc_shd.g_old_rec.global_attribute8, hr_api.g_varchar2) <>
1443: nvl(p_rec.global_attribute8, hr_api.g_varchar2) OR
1444: nvl(hr_loc_shd.g_old_rec.global_attribute9, hr_api.g_varchar2) <>
1437: nvl(p_rec.global_attribute5, hr_api.g_varchar2) OR
1438: nvl(hr_loc_shd.g_old_rec.global_attribute6, hr_api.g_varchar2) <>
1439: nvl(p_rec.global_attribute6, hr_api.g_varchar2) OR
1440: nvl(hr_loc_shd.g_old_rec.global_attribute7, hr_api.g_varchar2) <>
1441: nvl(p_rec.global_attribute7, hr_api.g_varchar2) OR
1442: nvl(hr_loc_shd.g_old_rec.global_attribute8, hr_api.g_varchar2) <>
1443: nvl(p_rec.global_attribute8, hr_api.g_varchar2) OR
1444: nvl(hr_loc_shd.g_old_rec.global_attribute9, hr_api.g_varchar2) <>
1445: nvl(p_rec.global_attribute9, hr_api.g_varchar2) OR
1438: nvl(hr_loc_shd.g_old_rec.global_attribute6, hr_api.g_varchar2) <>
1439: nvl(p_rec.global_attribute6, hr_api.g_varchar2) OR
1440: nvl(hr_loc_shd.g_old_rec.global_attribute7, hr_api.g_varchar2) <>
1441: nvl(p_rec.global_attribute7, hr_api.g_varchar2) OR
1442: nvl(hr_loc_shd.g_old_rec.global_attribute8, hr_api.g_varchar2) <>
1443: nvl(p_rec.global_attribute8, hr_api.g_varchar2) OR
1444: nvl(hr_loc_shd.g_old_rec.global_attribute9, hr_api.g_varchar2) <>
1445: nvl(p_rec.global_attribute9, hr_api.g_varchar2) OR
1446: nvl(hr_loc_shd.g_old_rec.global_attribute10, hr_api.g_varchar2) <>
1439: nvl(p_rec.global_attribute6, hr_api.g_varchar2) OR
1440: nvl(hr_loc_shd.g_old_rec.global_attribute7, hr_api.g_varchar2) <>
1441: nvl(p_rec.global_attribute7, hr_api.g_varchar2) OR
1442: nvl(hr_loc_shd.g_old_rec.global_attribute8, hr_api.g_varchar2) <>
1443: nvl(p_rec.global_attribute8, hr_api.g_varchar2) OR
1444: nvl(hr_loc_shd.g_old_rec.global_attribute9, hr_api.g_varchar2) <>
1445: nvl(p_rec.global_attribute9, hr_api.g_varchar2) OR
1446: nvl(hr_loc_shd.g_old_rec.global_attribute10, hr_api.g_varchar2) <>
1447: nvl(p_rec.global_attribute10, hr_api.g_varchar2) OR
1440: nvl(hr_loc_shd.g_old_rec.global_attribute7, hr_api.g_varchar2) <>
1441: nvl(p_rec.global_attribute7, hr_api.g_varchar2) OR
1442: nvl(hr_loc_shd.g_old_rec.global_attribute8, hr_api.g_varchar2) <>
1443: nvl(p_rec.global_attribute8, hr_api.g_varchar2) OR
1444: nvl(hr_loc_shd.g_old_rec.global_attribute9, hr_api.g_varchar2) <>
1445: nvl(p_rec.global_attribute9, hr_api.g_varchar2) OR
1446: nvl(hr_loc_shd.g_old_rec.global_attribute10, hr_api.g_varchar2) <>
1447: nvl(p_rec.global_attribute10, hr_api.g_varchar2) OR
1448: nvl(hr_loc_shd.g_old_rec.global_attribute11, hr_api.g_varchar2) <>
1441: nvl(p_rec.global_attribute7, hr_api.g_varchar2) OR
1442: nvl(hr_loc_shd.g_old_rec.global_attribute8, hr_api.g_varchar2) <>
1443: nvl(p_rec.global_attribute8, hr_api.g_varchar2) OR
1444: nvl(hr_loc_shd.g_old_rec.global_attribute9, hr_api.g_varchar2) <>
1445: nvl(p_rec.global_attribute9, hr_api.g_varchar2) OR
1446: nvl(hr_loc_shd.g_old_rec.global_attribute10, hr_api.g_varchar2) <>
1447: nvl(p_rec.global_attribute10, hr_api.g_varchar2) OR
1448: nvl(hr_loc_shd.g_old_rec.global_attribute11, hr_api.g_varchar2) <>
1449: nvl(p_rec.global_attribute11, hr_api.g_varchar2) OR
1442: nvl(hr_loc_shd.g_old_rec.global_attribute8, hr_api.g_varchar2) <>
1443: nvl(p_rec.global_attribute8, hr_api.g_varchar2) OR
1444: nvl(hr_loc_shd.g_old_rec.global_attribute9, hr_api.g_varchar2) <>
1445: nvl(p_rec.global_attribute9, hr_api.g_varchar2) OR
1446: nvl(hr_loc_shd.g_old_rec.global_attribute10, hr_api.g_varchar2) <>
1447: nvl(p_rec.global_attribute10, hr_api.g_varchar2) OR
1448: nvl(hr_loc_shd.g_old_rec.global_attribute11, hr_api.g_varchar2) <>
1449: nvl(p_rec.global_attribute11, hr_api.g_varchar2) OR
1450: nvl(hr_loc_shd.g_old_rec.global_attribute12, hr_api.g_varchar2) <>
1443: nvl(p_rec.global_attribute8, hr_api.g_varchar2) OR
1444: nvl(hr_loc_shd.g_old_rec.global_attribute9, hr_api.g_varchar2) <>
1445: nvl(p_rec.global_attribute9, hr_api.g_varchar2) OR
1446: nvl(hr_loc_shd.g_old_rec.global_attribute10, hr_api.g_varchar2) <>
1447: nvl(p_rec.global_attribute10, hr_api.g_varchar2) OR
1448: nvl(hr_loc_shd.g_old_rec.global_attribute11, hr_api.g_varchar2) <>
1449: nvl(p_rec.global_attribute11, hr_api.g_varchar2) OR
1450: nvl(hr_loc_shd.g_old_rec.global_attribute12, hr_api.g_varchar2) <>
1451: nvl(p_rec.global_attribute12, hr_api.g_varchar2) OR
1444: nvl(hr_loc_shd.g_old_rec.global_attribute9, hr_api.g_varchar2) <>
1445: nvl(p_rec.global_attribute9, hr_api.g_varchar2) OR
1446: nvl(hr_loc_shd.g_old_rec.global_attribute10, hr_api.g_varchar2) <>
1447: nvl(p_rec.global_attribute10, hr_api.g_varchar2) OR
1448: nvl(hr_loc_shd.g_old_rec.global_attribute11, hr_api.g_varchar2) <>
1449: nvl(p_rec.global_attribute11, hr_api.g_varchar2) OR
1450: nvl(hr_loc_shd.g_old_rec.global_attribute12, hr_api.g_varchar2) <>
1451: nvl(p_rec.global_attribute12, hr_api.g_varchar2) OR
1452: nvl(hr_loc_shd.g_old_rec.global_attribute13, hr_api.g_varchar2) <>
1445: nvl(p_rec.global_attribute9, hr_api.g_varchar2) OR
1446: nvl(hr_loc_shd.g_old_rec.global_attribute10, hr_api.g_varchar2) <>
1447: nvl(p_rec.global_attribute10, hr_api.g_varchar2) OR
1448: nvl(hr_loc_shd.g_old_rec.global_attribute11, hr_api.g_varchar2) <>
1449: nvl(p_rec.global_attribute11, hr_api.g_varchar2) OR
1450: nvl(hr_loc_shd.g_old_rec.global_attribute12, hr_api.g_varchar2) <>
1451: nvl(p_rec.global_attribute12, hr_api.g_varchar2) OR
1452: nvl(hr_loc_shd.g_old_rec.global_attribute13, hr_api.g_varchar2) <>
1453: nvl(p_rec.global_attribute13, hr_api.g_varchar2) OR
1446: nvl(hr_loc_shd.g_old_rec.global_attribute10, hr_api.g_varchar2) <>
1447: nvl(p_rec.global_attribute10, hr_api.g_varchar2) OR
1448: nvl(hr_loc_shd.g_old_rec.global_attribute11, hr_api.g_varchar2) <>
1449: nvl(p_rec.global_attribute11, hr_api.g_varchar2) OR
1450: nvl(hr_loc_shd.g_old_rec.global_attribute12, hr_api.g_varchar2) <>
1451: nvl(p_rec.global_attribute12, hr_api.g_varchar2) OR
1452: nvl(hr_loc_shd.g_old_rec.global_attribute13, hr_api.g_varchar2) <>
1453: nvl(p_rec.global_attribute13, hr_api.g_varchar2) OR
1454: nvl(hr_loc_shd.g_old_rec.global_attribute14, hr_api.g_varchar2) <>
1447: nvl(p_rec.global_attribute10, hr_api.g_varchar2) OR
1448: nvl(hr_loc_shd.g_old_rec.global_attribute11, hr_api.g_varchar2) <>
1449: nvl(p_rec.global_attribute11, hr_api.g_varchar2) OR
1450: nvl(hr_loc_shd.g_old_rec.global_attribute12, hr_api.g_varchar2) <>
1451: nvl(p_rec.global_attribute12, hr_api.g_varchar2) OR
1452: nvl(hr_loc_shd.g_old_rec.global_attribute13, hr_api.g_varchar2) <>
1453: nvl(p_rec.global_attribute13, hr_api.g_varchar2) OR
1454: nvl(hr_loc_shd.g_old_rec.global_attribute14, hr_api.g_varchar2) <>
1455: nvl(p_rec.global_attribute14, hr_api.g_varchar2) OR
1448: nvl(hr_loc_shd.g_old_rec.global_attribute11, hr_api.g_varchar2) <>
1449: nvl(p_rec.global_attribute11, hr_api.g_varchar2) OR
1450: nvl(hr_loc_shd.g_old_rec.global_attribute12, hr_api.g_varchar2) <>
1451: nvl(p_rec.global_attribute12, hr_api.g_varchar2) OR
1452: nvl(hr_loc_shd.g_old_rec.global_attribute13, hr_api.g_varchar2) <>
1453: nvl(p_rec.global_attribute13, hr_api.g_varchar2) OR
1454: nvl(hr_loc_shd.g_old_rec.global_attribute14, hr_api.g_varchar2) <>
1455: nvl(p_rec.global_attribute14, hr_api.g_varchar2) OR
1456: nvl(hr_loc_shd.g_old_rec.global_attribute15, hr_api.g_varchar2) <>
1449: nvl(p_rec.global_attribute11, hr_api.g_varchar2) OR
1450: nvl(hr_loc_shd.g_old_rec.global_attribute12, hr_api.g_varchar2) <>
1451: nvl(p_rec.global_attribute12, hr_api.g_varchar2) OR
1452: nvl(hr_loc_shd.g_old_rec.global_attribute13, hr_api.g_varchar2) <>
1453: nvl(p_rec.global_attribute13, hr_api.g_varchar2) OR
1454: nvl(hr_loc_shd.g_old_rec.global_attribute14, hr_api.g_varchar2) <>
1455: nvl(p_rec.global_attribute14, hr_api.g_varchar2) OR
1456: nvl(hr_loc_shd.g_old_rec.global_attribute15, hr_api.g_varchar2) <>
1457: nvl(p_rec.global_attribute15, hr_api.g_varchar2) OR
1450: nvl(hr_loc_shd.g_old_rec.global_attribute12, hr_api.g_varchar2) <>
1451: nvl(p_rec.global_attribute12, hr_api.g_varchar2) OR
1452: nvl(hr_loc_shd.g_old_rec.global_attribute13, hr_api.g_varchar2) <>
1453: nvl(p_rec.global_attribute13, hr_api.g_varchar2) OR
1454: nvl(hr_loc_shd.g_old_rec.global_attribute14, hr_api.g_varchar2) <>
1455: nvl(p_rec.global_attribute14, hr_api.g_varchar2) OR
1456: nvl(hr_loc_shd.g_old_rec.global_attribute15, hr_api.g_varchar2) <>
1457: nvl(p_rec.global_attribute15, hr_api.g_varchar2) OR
1458: nvl(hr_loc_shd.g_old_rec.global_attribute16, hr_api.g_varchar2) <>
1451: nvl(p_rec.global_attribute12, hr_api.g_varchar2) OR
1452: nvl(hr_loc_shd.g_old_rec.global_attribute13, hr_api.g_varchar2) <>
1453: nvl(p_rec.global_attribute13, hr_api.g_varchar2) OR
1454: nvl(hr_loc_shd.g_old_rec.global_attribute14, hr_api.g_varchar2) <>
1455: nvl(p_rec.global_attribute14, hr_api.g_varchar2) OR
1456: nvl(hr_loc_shd.g_old_rec.global_attribute15, hr_api.g_varchar2) <>
1457: nvl(p_rec.global_attribute15, hr_api.g_varchar2) OR
1458: nvl(hr_loc_shd.g_old_rec.global_attribute16, hr_api.g_varchar2) <>
1459: nvl(p_rec.global_attribute16, hr_api.g_varchar2) OR
1452: nvl(hr_loc_shd.g_old_rec.global_attribute13, hr_api.g_varchar2) <>
1453: nvl(p_rec.global_attribute13, hr_api.g_varchar2) OR
1454: nvl(hr_loc_shd.g_old_rec.global_attribute14, hr_api.g_varchar2) <>
1455: nvl(p_rec.global_attribute14, hr_api.g_varchar2) OR
1456: nvl(hr_loc_shd.g_old_rec.global_attribute15, hr_api.g_varchar2) <>
1457: nvl(p_rec.global_attribute15, hr_api.g_varchar2) OR
1458: nvl(hr_loc_shd.g_old_rec.global_attribute16, hr_api.g_varchar2) <>
1459: nvl(p_rec.global_attribute16, hr_api.g_varchar2) OR
1460: nvl(hr_loc_shd.g_old_rec.global_attribute17, hr_api.g_varchar2) <>
1453: nvl(p_rec.global_attribute13, hr_api.g_varchar2) OR
1454: nvl(hr_loc_shd.g_old_rec.global_attribute14, hr_api.g_varchar2) <>
1455: nvl(p_rec.global_attribute14, hr_api.g_varchar2) OR
1456: nvl(hr_loc_shd.g_old_rec.global_attribute15, hr_api.g_varchar2) <>
1457: nvl(p_rec.global_attribute15, hr_api.g_varchar2) OR
1458: nvl(hr_loc_shd.g_old_rec.global_attribute16, hr_api.g_varchar2) <>
1459: nvl(p_rec.global_attribute16, hr_api.g_varchar2) OR
1460: nvl(hr_loc_shd.g_old_rec.global_attribute17, hr_api.g_varchar2) <>
1461: nvl(p_rec.global_attribute17, hr_api.g_varchar2) OR
1454: nvl(hr_loc_shd.g_old_rec.global_attribute14, hr_api.g_varchar2) <>
1455: nvl(p_rec.global_attribute14, hr_api.g_varchar2) OR
1456: nvl(hr_loc_shd.g_old_rec.global_attribute15, hr_api.g_varchar2) <>
1457: nvl(p_rec.global_attribute15, hr_api.g_varchar2) OR
1458: nvl(hr_loc_shd.g_old_rec.global_attribute16, hr_api.g_varchar2) <>
1459: nvl(p_rec.global_attribute16, hr_api.g_varchar2) OR
1460: nvl(hr_loc_shd.g_old_rec.global_attribute17, hr_api.g_varchar2) <>
1461: nvl(p_rec.global_attribute17, hr_api.g_varchar2) OR
1462: nvl(hr_loc_shd.g_old_rec.global_attribute18, hr_api.g_varchar2) <>
1455: nvl(p_rec.global_attribute14, hr_api.g_varchar2) OR
1456: nvl(hr_loc_shd.g_old_rec.global_attribute15, hr_api.g_varchar2) <>
1457: nvl(p_rec.global_attribute15, hr_api.g_varchar2) OR
1458: nvl(hr_loc_shd.g_old_rec.global_attribute16, hr_api.g_varchar2) <>
1459: nvl(p_rec.global_attribute16, hr_api.g_varchar2) OR
1460: nvl(hr_loc_shd.g_old_rec.global_attribute17, hr_api.g_varchar2) <>
1461: nvl(p_rec.global_attribute17, hr_api.g_varchar2) OR
1462: nvl(hr_loc_shd.g_old_rec.global_attribute18, hr_api.g_varchar2) <>
1463: nvl(p_rec.global_attribute18, hr_api.g_varchar2) OR
1456: nvl(hr_loc_shd.g_old_rec.global_attribute15, hr_api.g_varchar2) <>
1457: nvl(p_rec.global_attribute15, hr_api.g_varchar2) OR
1458: nvl(hr_loc_shd.g_old_rec.global_attribute16, hr_api.g_varchar2) <>
1459: nvl(p_rec.global_attribute16, hr_api.g_varchar2) OR
1460: nvl(hr_loc_shd.g_old_rec.global_attribute17, hr_api.g_varchar2) <>
1461: nvl(p_rec.global_attribute17, hr_api.g_varchar2) OR
1462: nvl(hr_loc_shd.g_old_rec.global_attribute18, hr_api.g_varchar2) <>
1463: nvl(p_rec.global_attribute18, hr_api.g_varchar2) OR
1464: nvl(hr_loc_shd.g_old_rec.global_attribute19, hr_api.g_varchar2) <>
1457: nvl(p_rec.global_attribute15, hr_api.g_varchar2) OR
1458: nvl(hr_loc_shd.g_old_rec.global_attribute16, hr_api.g_varchar2) <>
1459: nvl(p_rec.global_attribute16, hr_api.g_varchar2) OR
1460: nvl(hr_loc_shd.g_old_rec.global_attribute17, hr_api.g_varchar2) <>
1461: nvl(p_rec.global_attribute17, hr_api.g_varchar2) OR
1462: nvl(hr_loc_shd.g_old_rec.global_attribute18, hr_api.g_varchar2) <>
1463: nvl(p_rec.global_attribute18, hr_api.g_varchar2) OR
1464: nvl(hr_loc_shd.g_old_rec.global_attribute19, hr_api.g_varchar2) <>
1465: nvl(p_rec.global_attribute19, hr_api.g_varchar2) OR
1458: nvl(hr_loc_shd.g_old_rec.global_attribute16, hr_api.g_varchar2) <>
1459: nvl(p_rec.global_attribute16, hr_api.g_varchar2) OR
1460: nvl(hr_loc_shd.g_old_rec.global_attribute17, hr_api.g_varchar2) <>
1461: nvl(p_rec.global_attribute17, hr_api.g_varchar2) OR
1462: nvl(hr_loc_shd.g_old_rec.global_attribute18, hr_api.g_varchar2) <>
1463: nvl(p_rec.global_attribute18, hr_api.g_varchar2) OR
1464: nvl(hr_loc_shd.g_old_rec.global_attribute19, hr_api.g_varchar2) <>
1465: nvl(p_rec.global_attribute19, hr_api.g_varchar2) OR
1466: nvl(hr_loc_shd.g_old_rec.global_attribute20, hr_api.g_varchar2) <>
1459: nvl(p_rec.global_attribute16, hr_api.g_varchar2) OR
1460: nvl(hr_loc_shd.g_old_rec.global_attribute17, hr_api.g_varchar2) <>
1461: nvl(p_rec.global_attribute17, hr_api.g_varchar2) OR
1462: nvl(hr_loc_shd.g_old_rec.global_attribute18, hr_api.g_varchar2) <>
1463: nvl(p_rec.global_attribute18, hr_api.g_varchar2) OR
1464: nvl(hr_loc_shd.g_old_rec.global_attribute19, hr_api.g_varchar2) <>
1465: nvl(p_rec.global_attribute19, hr_api.g_varchar2) OR
1466: nvl(hr_loc_shd.g_old_rec.global_attribute20, hr_api.g_varchar2) <>
1467: nvl(p_rec.global_attribute20, hr_api.g_varchar2)
1460: nvl(hr_loc_shd.g_old_rec.global_attribute17, hr_api.g_varchar2) <>
1461: nvl(p_rec.global_attribute17, hr_api.g_varchar2) OR
1462: nvl(hr_loc_shd.g_old_rec.global_attribute18, hr_api.g_varchar2) <>
1463: nvl(p_rec.global_attribute18, hr_api.g_varchar2) OR
1464: nvl(hr_loc_shd.g_old_rec.global_attribute19, hr_api.g_varchar2) <>
1465: nvl(p_rec.global_attribute19, hr_api.g_varchar2) OR
1466: nvl(hr_loc_shd.g_old_rec.global_attribute20, hr_api.g_varchar2) <>
1467: nvl(p_rec.global_attribute20, hr_api.g_varchar2)
1468: OR
1461: nvl(p_rec.global_attribute17, hr_api.g_varchar2) OR
1462: nvl(hr_loc_shd.g_old_rec.global_attribute18, hr_api.g_varchar2) <>
1463: nvl(p_rec.global_attribute18, hr_api.g_varchar2) OR
1464: nvl(hr_loc_shd.g_old_rec.global_attribute19, hr_api.g_varchar2) <>
1465: nvl(p_rec.global_attribute19, hr_api.g_varchar2) OR
1466: nvl(hr_loc_shd.g_old_rec.global_attribute20, hr_api.g_varchar2) <>
1467: nvl(p_rec.global_attribute20, hr_api.g_varchar2)
1468: OR
1469: (p_rec.location_id IS NULL)
1462: nvl(hr_loc_shd.g_old_rec.global_attribute18, hr_api.g_varchar2) <>
1463: nvl(p_rec.global_attribute18, hr_api.g_varchar2) OR
1464: nvl(hr_loc_shd.g_old_rec.global_attribute19, hr_api.g_varchar2) <>
1465: nvl(p_rec.global_attribute19, hr_api.g_varchar2) OR
1466: nvl(hr_loc_shd.g_old_rec.global_attribute20, hr_api.g_varchar2) <>
1467: nvl(p_rec.global_attribute20, hr_api.g_varchar2)
1468: OR
1469: (p_rec.location_id IS NULL)
1470: THEN
1463: nvl(p_rec.global_attribute18, hr_api.g_varchar2) OR
1464: nvl(hr_loc_shd.g_old_rec.global_attribute19, hr_api.g_varchar2) <>
1465: nvl(p_rec.global_attribute19, hr_api.g_varchar2) OR
1466: nvl(hr_loc_shd.g_old_rec.global_attribute20, hr_api.g_varchar2) <>
1467: nvl(p_rec.global_attribute20, hr_api.g_varchar2)
1468: OR
1469: (p_rec.location_id IS NULL)
1470: THEN
1471: -- Only execute the validation if absolutely necessary:
1550: -- at present. If this changes, "CLIENT_INFO" may require setting - see
1551: -- API strategy page 12-29 onwards.
1552: --
1553: IF p_rec.business_group_id IS NOT NULL THEN
1554: hr_api.validate_bus_grp_id(p_rec.business_group_id);
1555: END IF;
1556: --
1557: --
1558: hr_utility.set_location(l_proc, 10);