[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: BEGIN
659: --
664: IF ( p_tax_name IS NOT NULL ) THEN
665: --
666: -- Only continue if tax_name is not null
667: --p_tax_name
668: IF ( p_tax_name <> nvl (hr_loc_shd.g_old_rec.tax_name, hr_api.g_varchar2) )
669: OR (p_location_id IS NULL)
670: --
671: -- Only validate if inserting, or updating with new value
672: --
752: IF ( p_style IS NOT NULL ) THEN
753: --
754: -- Only continue if STYLE is not null
755: --
756: IF ( nvl(hr_loc_shd.g_old_rec.style, hr_api.g_varchar2) <> p_style)
757: OR (p_location_id IS NULL ) THEN
758: --
759: -- Only validate if inserting, or updating with new value
760: --
828: IF ( p_timezone_code IS NOT NULL ) THEN
829: --
830: -- Only continue if TIMEZONE_CODE is not null
831: --
832: IF ( nvl(hr_loc_shd.g_old_rec.timezone_code, hr_api.g_varchar2)
833: <> p_timezone_code) THEN
834: --
835: -- Only validate if inserting, or updating with new value
836: --
1129: END IF;
1130: --
1131: hr_utility.set_location(l_proc, 10);
1132: --
1133: IF nvl(p_rec.business_group_id, hr_api.g_number) <>
1134: nvl (hr_loc_shd.g_old_rec.business_group_id, hr_api.g_number) THEN
1135: l_argument := 'business_group_id';
1136: RAISE l_error;
1137: END IF;
1130: --
1131: hr_utility.set_location(l_proc, 10);
1132: --
1133: IF nvl(p_rec.business_group_id, hr_api.g_number) <>
1134: nvl (hr_loc_shd.g_old_rec.business_group_id, hr_api.g_number) THEN
1135: l_argument := 'business_group_id';
1136: RAISE l_error;
1137: END IF;
1138: --
1137: END IF;
1138: --
1139: EXCEPTION
1140: WHEN l_error THEN
1141: hr_api.argument_changed_error
1142: (p_api_name => l_proc
1143: ,p_argument => l_argument);
1144: WHEN OTHERS THEN
1145: RAISE;
1185: --
1186: -- Address location - regular DF
1187: -- =============================
1188: --
1189: IF nvl(hr_loc_shd.g_old_rec.style, hr_api.g_varchar2) <>
1190: nvl(p_rec.style, hr_api.g_varchar2) OR
1191: nvl(hr_loc_shd.g_old_rec.address_line_1, hr_api.g_varchar2) <>
1192: nvl(p_rec.address_line_1, hr_api.g_varchar2) OR
1193: nvl(hr_loc_shd.g_old_rec.address_line_2, hr_api.g_varchar2) <>
1186: -- Address location - regular DF
1187: -- =============================
1188: --
1189: IF nvl(hr_loc_shd.g_old_rec.style, hr_api.g_varchar2) <>
1190: nvl(p_rec.style, hr_api.g_varchar2) OR
1191: nvl(hr_loc_shd.g_old_rec.address_line_1, hr_api.g_varchar2) <>
1192: nvl(p_rec.address_line_1, hr_api.g_varchar2) OR
1193: nvl(hr_loc_shd.g_old_rec.address_line_2, hr_api.g_varchar2) <>
1194: nvl(p_rec.address_line_2, hr_api.g_varchar2) OR
1187: -- =============================
1188: --
1189: IF nvl(hr_loc_shd.g_old_rec.style, hr_api.g_varchar2) <>
1190: nvl(p_rec.style, hr_api.g_varchar2) OR
1191: nvl(hr_loc_shd.g_old_rec.address_line_1, hr_api.g_varchar2) <>
1192: nvl(p_rec.address_line_1, hr_api.g_varchar2) OR
1193: nvl(hr_loc_shd.g_old_rec.address_line_2, hr_api.g_varchar2) <>
1194: nvl(p_rec.address_line_2, hr_api.g_varchar2) OR
1195: nvl(hr_loc_shd.g_old_rec.address_line_3, hr_api.g_varchar2) <>
1188: --
1189: IF nvl(hr_loc_shd.g_old_rec.style, hr_api.g_varchar2) <>
1190: nvl(p_rec.style, hr_api.g_varchar2) OR
1191: nvl(hr_loc_shd.g_old_rec.address_line_1, hr_api.g_varchar2) <>
1192: nvl(p_rec.address_line_1, hr_api.g_varchar2) OR
1193: nvl(hr_loc_shd.g_old_rec.address_line_2, hr_api.g_varchar2) <>
1194: nvl(p_rec.address_line_2, hr_api.g_varchar2) OR
1195: nvl(hr_loc_shd.g_old_rec.address_line_3, hr_api.g_varchar2) <>
1196: nvl(p_rec.address_line_3, hr_api.g_varchar2) OR
1189: IF nvl(hr_loc_shd.g_old_rec.style, hr_api.g_varchar2) <>
1190: nvl(p_rec.style, hr_api.g_varchar2) OR
1191: nvl(hr_loc_shd.g_old_rec.address_line_1, hr_api.g_varchar2) <>
1192: nvl(p_rec.address_line_1, hr_api.g_varchar2) OR
1193: nvl(hr_loc_shd.g_old_rec.address_line_2, hr_api.g_varchar2) <>
1194: nvl(p_rec.address_line_2, hr_api.g_varchar2) OR
1195: nvl(hr_loc_shd.g_old_rec.address_line_3, hr_api.g_varchar2) <>
1196: nvl(p_rec.address_line_3, hr_api.g_varchar2) OR
1197: nvl(hr_loc_shd.g_old_rec.country, hr_api.g_varchar2) <>
1190: nvl(p_rec.style, hr_api.g_varchar2) OR
1191: nvl(hr_loc_shd.g_old_rec.address_line_1, hr_api.g_varchar2) <>
1192: nvl(p_rec.address_line_1, hr_api.g_varchar2) OR
1193: nvl(hr_loc_shd.g_old_rec.address_line_2, hr_api.g_varchar2) <>
1194: nvl(p_rec.address_line_2, hr_api.g_varchar2) OR
1195: nvl(hr_loc_shd.g_old_rec.address_line_3, hr_api.g_varchar2) <>
1196: nvl(p_rec.address_line_3, hr_api.g_varchar2) OR
1197: nvl(hr_loc_shd.g_old_rec.country, hr_api.g_varchar2) <>
1198: nvl(p_rec.country, hr_api.g_varchar2) OR
1191: nvl(hr_loc_shd.g_old_rec.address_line_1, hr_api.g_varchar2) <>
1192: nvl(p_rec.address_line_1, hr_api.g_varchar2) OR
1193: nvl(hr_loc_shd.g_old_rec.address_line_2, hr_api.g_varchar2) <>
1194: nvl(p_rec.address_line_2, hr_api.g_varchar2) OR
1195: nvl(hr_loc_shd.g_old_rec.address_line_3, hr_api.g_varchar2) <>
1196: nvl(p_rec.address_line_3, hr_api.g_varchar2) OR
1197: nvl(hr_loc_shd.g_old_rec.country, hr_api.g_varchar2) <>
1198: nvl(p_rec.country, hr_api.g_varchar2) OR
1199: nvl(hr_loc_shd.g_old_rec.postal_code, hr_api.g_varchar2) <>
1192: nvl(p_rec.address_line_1, hr_api.g_varchar2) OR
1193: nvl(hr_loc_shd.g_old_rec.address_line_2, hr_api.g_varchar2) <>
1194: nvl(p_rec.address_line_2, hr_api.g_varchar2) OR
1195: nvl(hr_loc_shd.g_old_rec.address_line_3, hr_api.g_varchar2) <>
1196: nvl(p_rec.address_line_3, hr_api.g_varchar2) OR
1197: nvl(hr_loc_shd.g_old_rec.country, hr_api.g_varchar2) <>
1198: nvl(p_rec.country, hr_api.g_varchar2) OR
1199: nvl(hr_loc_shd.g_old_rec.postal_code, hr_api.g_varchar2) <>
1200: nvl(p_rec.postal_code, hr_api.g_varchar2) OR
1193: nvl(hr_loc_shd.g_old_rec.address_line_2, hr_api.g_varchar2) <>
1194: nvl(p_rec.address_line_2, hr_api.g_varchar2) OR
1195: nvl(hr_loc_shd.g_old_rec.address_line_3, hr_api.g_varchar2) <>
1196: nvl(p_rec.address_line_3, hr_api.g_varchar2) OR
1197: nvl(hr_loc_shd.g_old_rec.country, hr_api.g_varchar2) <>
1198: nvl(p_rec.country, hr_api.g_varchar2) OR
1199: nvl(hr_loc_shd.g_old_rec.postal_code, hr_api.g_varchar2) <>
1200: nvl(p_rec.postal_code, hr_api.g_varchar2) OR
1201: nvl(hr_loc_shd.g_old_rec.region_1, hr_api.g_varchar2) <>
1194: nvl(p_rec.address_line_2, hr_api.g_varchar2) OR
1195: nvl(hr_loc_shd.g_old_rec.address_line_3, hr_api.g_varchar2) <>
1196: nvl(p_rec.address_line_3, hr_api.g_varchar2) OR
1197: nvl(hr_loc_shd.g_old_rec.country, hr_api.g_varchar2) <>
1198: nvl(p_rec.country, hr_api.g_varchar2) OR
1199: nvl(hr_loc_shd.g_old_rec.postal_code, hr_api.g_varchar2) <>
1200: nvl(p_rec.postal_code, hr_api.g_varchar2) OR
1201: nvl(hr_loc_shd.g_old_rec.region_1, hr_api.g_varchar2) <>
1202: nvl(p_rec.region_1, hr_api.g_varchar2) OR
1195: nvl(hr_loc_shd.g_old_rec.address_line_3, hr_api.g_varchar2) <>
1196: nvl(p_rec.address_line_3, hr_api.g_varchar2) OR
1197: nvl(hr_loc_shd.g_old_rec.country, hr_api.g_varchar2) <>
1198: nvl(p_rec.country, hr_api.g_varchar2) OR
1199: nvl(hr_loc_shd.g_old_rec.postal_code, hr_api.g_varchar2) <>
1200: nvl(p_rec.postal_code, hr_api.g_varchar2) OR
1201: nvl(hr_loc_shd.g_old_rec.region_1, hr_api.g_varchar2) <>
1202: nvl(p_rec.region_1, hr_api.g_varchar2) OR
1203: nvl(hr_loc_shd.g_old_rec.region_2, hr_api.g_varchar2) <>
1196: nvl(p_rec.address_line_3, hr_api.g_varchar2) OR
1197: nvl(hr_loc_shd.g_old_rec.country, hr_api.g_varchar2) <>
1198: nvl(p_rec.country, hr_api.g_varchar2) OR
1199: nvl(hr_loc_shd.g_old_rec.postal_code, hr_api.g_varchar2) <>
1200: nvl(p_rec.postal_code, hr_api.g_varchar2) OR
1201: nvl(hr_loc_shd.g_old_rec.region_1, hr_api.g_varchar2) <>
1202: nvl(p_rec.region_1, hr_api.g_varchar2) OR
1203: nvl(hr_loc_shd.g_old_rec.region_2, hr_api.g_varchar2) <>
1204: nvl(p_rec.region_2, hr_api.g_varchar2) OR
1197: nvl(hr_loc_shd.g_old_rec.country, hr_api.g_varchar2) <>
1198: nvl(p_rec.country, hr_api.g_varchar2) OR
1199: nvl(hr_loc_shd.g_old_rec.postal_code, hr_api.g_varchar2) <>
1200: nvl(p_rec.postal_code, hr_api.g_varchar2) OR
1201: nvl(hr_loc_shd.g_old_rec.region_1, hr_api.g_varchar2) <>
1202: nvl(p_rec.region_1, hr_api.g_varchar2) OR
1203: nvl(hr_loc_shd.g_old_rec.region_2, hr_api.g_varchar2) <>
1204: nvl(p_rec.region_2, hr_api.g_varchar2) OR
1205: nvl(hr_loc_shd.g_old_rec.region_3, hr_api.g_varchar2) <>
1198: nvl(p_rec.country, hr_api.g_varchar2) OR
1199: nvl(hr_loc_shd.g_old_rec.postal_code, hr_api.g_varchar2) <>
1200: nvl(p_rec.postal_code, hr_api.g_varchar2) OR
1201: nvl(hr_loc_shd.g_old_rec.region_1, hr_api.g_varchar2) <>
1202: nvl(p_rec.region_1, hr_api.g_varchar2) OR
1203: nvl(hr_loc_shd.g_old_rec.region_2, hr_api.g_varchar2) <>
1204: nvl(p_rec.region_2, hr_api.g_varchar2) OR
1205: nvl(hr_loc_shd.g_old_rec.region_3, hr_api.g_varchar2) <>
1206: nvl(p_rec.region_3, hr_api.g_varchar2) OR
1199: nvl(hr_loc_shd.g_old_rec.postal_code, hr_api.g_varchar2) <>
1200: nvl(p_rec.postal_code, hr_api.g_varchar2) OR
1201: nvl(hr_loc_shd.g_old_rec.region_1, hr_api.g_varchar2) <>
1202: nvl(p_rec.region_1, hr_api.g_varchar2) OR
1203: nvl(hr_loc_shd.g_old_rec.region_2, hr_api.g_varchar2) <>
1204: nvl(p_rec.region_2, hr_api.g_varchar2) OR
1205: nvl(hr_loc_shd.g_old_rec.region_3, hr_api.g_varchar2) <>
1206: nvl(p_rec.region_3, hr_api.g_varchar2) OR
1207: nvl(hr_loc_shd.g_old_rec.telephone_number_1, hr_api.g_varchar2) <>
1200: nvl(p_rec.postal_code, hr_api.g_varchar2) OR
1201: nvl(hr_loc_shd.g_old_rec.region_1, hr_api.g_varchar2) <>
1202: nvl(p_rec.region_1, hr_api.g_varchar2) OR
1203: nvl(hr_loc_shd.g_old_rec.region_2, hr_api.g_varchar2) <>
1204: nvl(p_rec.region_2, hr_api.g_varchar2) OR
1205: nvl(hr_loc_shd.g_old_rec.region_3, hr_api.g_varchar2) <>
1206: nvl(p_rec.region_3, hr_api.g_varchar2) OR
1207: nvl(hr_loc_shd.g_old_rec.telephone_number_1, hr_api.g_varchar2) <>
1208: nvl(p_rec.telephone_number_1, hr_api.g_varchar2) OR
1201: nvl(hr_loc_shd.g_old_rec.region_1, hr_api.g_varchar2) <>
1202: nvl(p_rec.region_1, hr_api.g_varchar2) OR
1203: nvl(hr_loc_shd.g_old_rec.region_2, hr_api.g_varchar2) <>
1204: nvl(p_rec.region_2, hr_api.g_varchar2) OR
1205: nvl(hr_loc_shd.g_old_rec.region_3, hr_api.g_varchar2) <>
1206: nvl(p_rec.region_3, hr_api.g_varchar2) OR
1207: nvl(hr_loc_shd.g_old_rec.telephone_number_1, hr_api.g_varchar2) <>
1208: nvl(p_rec.telephone_number_1, hr_api.g_varchar2) OR
1209: nvl(hr_loc_shd.g_old_rec.telephone_number_2, hr_api.g_varchar2) <>
1202: nvl(p_rec.region_1, hr_api.g_varchar2) OR
1203: nvl(hr_loc_shd.g_old_rec.region_2, hr_api.g_varchar2) <>
1204: nvl(p_rec.region_2, hr_api.g_varchar2) OR
1205: nvl(hr_loc_shd.g_old_rec.region_3, hr_api.g_varchar2) <>
1206: nvl(p_rec.region_3, hr_api.g_varchar2) OR
1207: nvl(hr_loc_shd.g_old_rec.telephone_number_1, hr_api.g_varchar2) <>
1208: nvl(p_rec.telephone_number_1, hr_api.g_varchar2) OR
1209: nvl(hr_loc_shd.g_old_rec.telephone_number_2, hr_api.g_varchar2) <>
1210: nvl(p_rec.telephone_number_2, hr_api.g_varchar2) OR
1203: nvl(hr_loc_shd.g_old_rec.region_2, hr_api.g_varchar2) <>
1204: nvl(p_rec.region_2, hr_api.g_varchar2) OR
1205: nvl(hr_loc_shd.g_old_rec.region_3, hr_api.g_varchar2) <>
1206: nvl(p_rec.region_3, hr_api.g_varchar2) OR
1207: nvl(hr_loc_shd.g_old_rec.telephone_number_1, hr_api.g_varchar2) <>
1208: nvl(p_rec.telephone_number_1, hr_api.g_varchar2) OR
1209: nvl(hr_loc_shd.g_old_rec.telephone_number_2, hr_api.g_varchar2) <>
1210: nvl(p_rec.telephone_number_2, hr_api.g_varchar2) OR
1211: nvl(hr_loc_shd.g_old_rec.telephone_number_3, hr_api.g_varchar2) <>
1204: nvl(p_rec.region_2, hr_api.g_varchar2) OR
1205: nvl(hr_loc_shd.g_old_rec.region_3, hr_api.g_varchar2) <>
1206: nvl(p_rec.region_3, hr_api.g_varchar2) OR
1207: nvl(hr_loc_shd.g_old_rec.telephone_number_1, hr_api.g_varchar2) <>
1208: nvl(p_rec.telephone_number_1, hr_api.g_varchar2) OR
1209: nvl(hr_loc_shd.g_old_rec.telephone_number_2, hr_api.g_varchar2) <>
1210: nvl(p_rec.telephone_number_2, hr_api.g_varchar2) OR
1211: nvl(hr_loc_shd.g_old_rec.telephone_number_3, hr_api.g_varchar2) <>
1212: nvl(p_rec.telephone_number_3, hr_api.g_varchar2) OR
1205: nvl(hr_loc_shd.g_old_rec.region_3, hr_api.g_varchar2) <>
1206: nvl(p_rec.region_3, hr_api.g_varchar2) OR
1207: nvl(hr_loc_shd.g_old_rec.telephone_number_1, hr_api.g_varchar2) <>
1208: nvl(p_rec.telephone_number_1, hr_api.g_varchar2) OR
1209: nvl(hr_loc_shd.g_old_rec.telephone_number_2, hr_api.g_varchar2) <>
1210: nvl(p_rec.telephone_number_2, hr_api.g_varchar2) OR
1211: nvl(hr_loc_shd.g_old_rec.telephone_number_3, hr_api.g_varchar2) <>
1212: nvl(p_rec.telephone_number_3, hr_api.g_varchar2) OR
1213: nvl(hr_loc_shd.g_old_rec.town_or_city, hr_api.g_varchar2) <>
1206: nvl(p_rec.region_3, hr_api.g_varchar2) OR
1207: nvl(hr_loc_shd.g_old_rec.telephone_number_1, hr_api.g_varchar2) <>
1208: nvl(p_rec.telephone_number_1, hr_api.g_varchar2) OR
1209: nvl(hr_loc_shd.g_old_rec.telephone_number_2, hr_api.g_varchar2) <>
1210: nvl(p_rec.telephone_number_2, hr_api.g_varchar2) OR
1211: nvl(hr_loc_shd.g_old_rec.telephone_number_3, hr_api.g_varchar2) <>
1212: nvl(p_rec.telephone_number_3, hr_api.g_varchar2) OR
1213: nvl(hr_loc_shd.g_old_rec.town_or_city, hr_api.g_varchar2) <>
1214: nvl(p_rec.town_or_city, hr_api.g_varchar2) OR
1207: nvl(hr_loc_shd.g_old_rec.telephone_number_1, hr_api.g_varchar2) <>
1208: nvl(p_rec.telephone_number_1, hr_api.g_varchar2) OR
1209: nvl(hr_loc_shd.g_old_rec.telephone_number_2, hr_api.g_varchar2) <>
1210: nvl(p_rec.telephone_number_2, hr_api.g_varchar2) OR
1211: nvl(hr_loc_shd.g_old_rec.telephone_number_3, hr_api.g_varchar2) <>
1212: nvl(p_rec.telephone_number_3, hr_api.g_varchar2) OR
1213: nvl(hr_loc_shd.g_old_rec.town_or_city, hr_api.g_varchar2) <>
1214: nvl(p_rec.town_or_city, hr_api.g_varchar2) OR
1215: nvl(hr_loc_shd.g_old_rec.loc_information13, hr_api.g_varchar2) <>
1208: nvl(p_rec.telephone_number_1, hr_api.g_varchar2) OR
1209: nvl(hr_loc_shd.g_old_rec.telephone_number_2, hr_api.g_varchar2) <>
1210: nvl(p_rec.telephone_number_2, hr_api.g_varchar2) OR
1211: nvl(hr_loc_shd.g_old_rec.telephone_number_3, hr_api.g_varchar2) <>
1212: nvl(p_rec.telephone_number_3, hr_api.g_varchar2) OR
1213: nvl(hr_loc_shd.g_old_rec.town_or_city, hr_api.g_varchar2) <>
1214: nvl(p_rec.town_or_city, hr_api.g_varchar2) OR
1215: nvl(hr_loc_shd.g_old_rec.loc_information13, hr_api.g_varchar2) <>
1216: nvl(p_rec.loc_information13, hr_api.g_varchar2) OR
1209: nvl(hr_loc_shd.g_old_rec.telephone_number_2, hr_api.g_varchar2) <>
1210: nvl(p_rec.telephone_number_2, hr_api.g_varchar2) OR
1211: nvl(hr_loc_shd.g_old_rec.telephone_number_3, hr_api.g_varchar2) <>
1212: nvl(p_rec.telephone_number_3, hr_api.g_varchar2) OR
1213: nvl(hr_loc_shd.g_old_rec.town_or_city, hr_api.g_varchar2) <>
1214: nvl(p_rec.town_or_city, hr_api.g_varchar2) OR
1215: nvl(hr_loc_shd.g_old_rec.loc_information13, hr_api.g_varchar2) <>
1216: nvl(p_rec.loc_information13, hr_api.g_varchar2) OR
1217: nvl(hr_loc_shd.g_old_rec.loc_information14, hr_api.g_varchar2) <>
1210: nvl(p_rec.telephone_number_2, hr_api.g_varchar2) OR
1211: nvl(hr_loc_shd.g_old_rec.telephone_number_3, hr_api.g_varchar2) <>
1212: nvl(p_rec.telephone_number_3, hr_api.g_varchar2) OR
1213: nvl(hr_loc_shd.g_old_rec.town_or_city, hr_api.g_varchar2) <>
1214: nvl(p_rec.town_or_city, hr_api.g_varchar2) OR
1215: nvl(hr_loc_shd.g_old_rec.loc_information13, hr_api.g_varchar2) <>
1216: nvl(p_rec.loc_information13, hr_api.g_varchar2) OR
1217: nvl(hr_loc_shd.g_old_rec.loc_information14, hr_api.g_varchar2) <>
1218: nvl(p_rec.loc_information14, hr_api.g_varchar2) OR
1211: nvl(hr_loc_shd.g_old_rec.telephone_number_3, hr_api.g_varchar2) <>
1212: nvl(p_rec.telephone_number_3, hr_api.g_varchar2) OR
1213: nvl(hr_loc_shd.g_old_rec.town_or_city, hr_api.g_varchar2) <>
1214: nvl(p_rec.town_or_city, hr_api.g_varchar2) OR
1215: nvl(hr_loc_shd.g_old_rec.loc_information13, hr_api.g_varchar2) <>
1216: nvl(p_rec.loc_information13, hr_api.g_varchar2) OR
1217: nvl(hr_loc_shd.g_old_rec.loc_information14, hr_api.g_varchar2) <>
1218: nvl(p_rec.loc_information14, hr_api.g_varchar2) OR
1219: nvl(hr_loc_shd.g_old_rec.loc_information15, hr_api.g_varchar2) <>
1212: nvl(p_rec.telephone_number_3, hr_api.g_varchar2) OR
1213: nvl(hr_loc_shd.g_old_rec.town_or_city, hr_api.g_varchar2) <>
1214: nvl(p_rec.town_or_city, hr_api.g_varchar2) OR
1215: nvl(hr_loc_shd.g_old_rec.loc_information13, hr_api.g_varchar2) <>
1216: nvl(p_rec.loc_information13, hr_api.g_varchar2) OR
1217: nvl(hr_loc_shd.g_old_rec.loc_information14, hr_api.g_varchar2) <>
1218: nvl(p_rec.loc_information14, hr_api.g_varchar2) OR
1219: nvl(hr_loc_shd.g_old_rec.loc_information15, hr_api.g_varchar2) <>
1220: nvl(p_rec.loc_information15, hr_api.g_varchar2) OR
1213: nvl(hr_loc_shd.g_old_rec.town_or_city, hr_api.g_varchar2) <>
1214: nvl(p_rec.town_or_city, hr_api.g_varchar2) OR
1215: nvl(hr_loc_shd.g_old_rec.loc_information13, hr_api.g_varchar2) <>
1216: nvl(p_rec.loc_information13, hr_api.g_varchar2) OR
1217: nvl(hr_loc_shd.g_old_rec.loc_information14, hr_api.g_varchar2) <>
1218: nvl(p_rec.loc_information14, hr_api.g_varchar2) OR
1219: nvl(hr_loc_shd.g_old_rec.loc_information15, hr_api.g_varchar2) <>
1220: nvl(p_rec.loc_information15, hr_api.g_varchar2) OR
1221: nvl(hr_loc_shd.g_old_rec.loc_information16, hr_api.g_varchar2) <>
1214: nvl(p_rec.town_or_city, hr_api.g_varchar2) OR
1215: nvl(hr_loc_shd.g_old_rec.loc_information13, hr_api.g_varchar2) <>
1216: nvl(p_rec.loc_information13, hr_api.g_varchar2) OR
1217: nvl(hr_loc_shd.g_old_rec.loc_information14, hr_api.g_varchar2) <>
1218: nvl(p_rec.loc_information14, hr_api.g_varchar2) OR
1219: nvl(hr_loc_shd.g_old_rec.loc_information15, hr_api.g_varchar2) <>
1220: nvl(p_rec.loc_information15, hr_api.g_varchar2) OR
1221: nvl(hr_loc_shd.g_old_rec.loc_information16, hr_api.g_varchar2) <>
1222: nvl(p_rec.loc_information16, hr_api.g_varchar2) OR
1215: nvl(hr_loc_shd.g_old_rec.loc_information13, hr_api.g_varchar2) <>
1216: nvl(p_rec.loc_information13, hr_api.g_varchar2) OR
1217: nvl(hr_loc_shd.g_old_rec.loc_information14, hr_api.g_varchar2) <>
1218: nvl(p_rec.loc_information14, hr_api.g_varchar2) OR
1219: nvl(hr_loc_shd.g_old_rec.loc_information15, hr_api.g_varchar2) <>
1220: nvl(p_rec.loc_information15, hr_api.g_varchar2) OR
1221: nvl(hr_loc_shd.g_old_rec.loc_information16, hr_api.g_varchar2) <>
1222: nvl(p_rec.loc_information16, hr_api.g_varchar2) OR
1223: nvl(hr_loc_shd.g_old_rec.loc_information17, hr_api.g_varchar2) <>
1216: nvl(p_rec.loc_information13, hr_api.g_varchar2) OR
1217: nvl(hr_loc_shd.g_old_rec.loc_information14, hr_api.g_varchar2) <>
1218: nvl(p_rec.loc_information14, hr_api.g_varchar2) OR
1219: nvl(hr_loc_shd.g_old_rec.loc_information15, hr_api.g_varchar2) <>
1220: nvl(p_rec.loc_information15, hr_api.g_varchar2) OR
1221: nvl(hr_loc_shd.g_old_rec.loc_information16, hr_api.g_varchar2) <>
1222: nvl(p_rec.loc_information16, hr_api.g_varchar2) OR
1223: nvl(hr_loc_shd.g_old_rec.loc_information17, hr_api.g_varchar2) <>
1224: nvl(p_rec.loc_information17, hr_api.g_varchar2) OR
1217: nvl(hr_loc_shd.g_old_rec.loc_information14, hr_api.g_varchar2) <>
1218: nvl(p_rec.loc_information14, hr_api.g_varchar2) OR
1219: nvl(hr_loc_shd.g_old_rec.loc_information15, hr_api.g_varchar2) <>
1220: nvl(p_rec.loc_information15, hr_api.g_varchar2) OR
1221: nvl(hr_loc_shd.g_old_rec.loc_information16, hr_api.g_varchar2) <>
1222: nvl(p_rec.loc_information16, hr_api.g_varchar2) OR
1223: nvl(hr_loc_shd.g_old_rec.loc_information17, hr_api.g_varchar2) <>
1224: nvl(p_rec.loc_information17, hr_api.g_varchar2) OR
1225: nvl(hr_loc_shd.g_old_rec.loc_information18, hr_api.g_varchar2) <>
1218: nvl(p_rec.loc_information14, hr_api.g_varchar2) OR
1219: nvl(hr_loc_shd.g_old_rec.loc_information15, hr_api.g_varchar2) <>
1220: nvl(p_rec.loc_information15, hr_api.g_varchar2) OR
1221: nvl(hr_loc_shd.g_old_rec.loc_information16, hr_api.g_varchar2) <>
1222: nvl(p_rec.loc_information16, hr_api.g_varchar2) OR
1223: nvl(hr_loc_shd.g_old_rec.loc_information17, hr_api.g_varchar2) <>
1224: nvl(p_rec.loc_information17, hr_api.g_varchar2) OR
1225: nvl(hr_loc_shd.g_old_rec.loc_information18, hr_api.g_varchar2) <>
1226: nvl(p_rec.loc_information18, hr_api.g_varchar2) OR
1219: nvl(hr_loc_shd.g_old_rec.loc_information15, hr_api.g_varchar2) <>
1220: nvl(p_rec.loc_information15, hr_api.g_varchar2) OR
1221: nvl(hr_loc_shd.g_old_rec.loc_information16, hr_api.g_varchar2) <>
1222: nvl(p_rec.loc_information16, hr_api.g_varchar2) OR
1223: nvl(hr_loc_shd.g_old_rec.loc_information17, hr_api.g_varchar2) <>
1224: nvl(p_rec.loc_information17, hr_api.g_varchar2) OR
1225: nvl(hr_loc_shd.g_old_rec.loc_information18, hr_api.g_varchar2) <>
1226: nvl(p_rec.loc_information18, hr_api.g_varchar2) OR
1227: nvl(hr_loc_shd.g_old_rec.loc_information19, hr_api.g_varchar2) <>
1220: nvl(p_rec.loc_information15, hr_api.g_varchar2) OR
1221: nvl(hr_loc_shd.g_old_rec.loc_information16, hr_api.g_varchar2) <>
1222: nvl(p_rec.loc_information16, hr_api.g_varchar2) OR
1223: nvl(hr_loc_shd.g_old_rec.loc_information17, hr_api.g_varchar2) <>
1224: nvl(p_rec.loc_information17, hr_api.g_varchar2) OR
1225: nvl(hr_loc_shd.g_old_rec.loc_information18, hr_api.g_varchar2) <>
1226: nvl(p_rec.loc_information18, hr_api.g_varchar2) OR
1227: nvl(hr_loc_shd.g_old_rec.loc_information19, hr_api.g_varchar2) <>
1228: nvl(p_rec.loc_information19, hr_api.g_varchar2) OR
1221: nvl(hr_loc_shd.g_old_rec.loc_information16, hr_api.g_varchar2) <>
1222: nvl(p_rec.loc_information16, hr_api.g_varchar2) OR
1223: nvl(hr_loc_shd.g_old_rec.loc_information17, hr_api.g_varchar2) <>
1224: nvl(p_rec.loc_information17, hr_api.g_varchar2) OR
1225: nvl(hr_loc_shd.g_old_rec.loc_information18, hr_api.g_varchar2) <>
1226: nvl(p_rec.loc_information18, hr_api.g_varchar2) OR
1227: nvl(hr_loc_shd.g_old_rec.loc_information19, hr_api.g_varchar2) <>
1228: nvl(p_rec.loc_information19, hr_api.g_varchar2) OR
1229: nvl(hr_loc_shd.g_old_rec.loc_information20, hr_api.g_varchar2) <>
1222: nvl(p_rec.loc_information16, hr_api.g_varchar2) OR
1223: nvl(hr_loc_shd.g_old_rec.loc_information17, hr_api.g_varchar2) <>
1224: nvl(p_rec.loc_information17, hr_api.g_varchar2) OR
1225: nvl(hr_loc_shd.g_old_rec.loc_information18, hr_api.g_varchar2) <>
1226: nvl(p_rec.loc_information18, hr_api.g_varchar2) OR
1227: nvl(hr_loc_shd.g_old_rec.loc_information19, hr_api.g_varchar2) <>
1228: nvl(p_rec.loc_information19, hr_api.g_varchar2) OR
1229: nvl(hr_loc_shd.g_old_rec.loc_information20, hr_api.g_varchar2) <>
1230: nvl(p_rec.loc_information20, hr_api.g_varchar2) OR
1223: nvl(hr_loc_shd.g_old_rec.loc_information17, hr_api.g_varchar2) <>
1224: nvl(p_rec.loc_information17, hr_api.g_varchar2) OR
1225: nvl(hr_loc_shd.g_old_rec.loc_information18, hr_api.g_varchar2) <>
1226: nvl(p_rec.loc_information18, hr_api.g_varchar2) OR
1227: nvl(hr_loc_shd.g_old_rec.loc_information19, hr_api.g_varchar2) <>
1228: nvl(p_rec.loc_information19, hr_api.g_varchar2) OR
1229: nvl(hr_loc_shd.g_old_rec.loc_information20, hr_api.g_varchar2) <>
1230: nvl(p_rec.loc_information20, hr_api.g_varchar2) OR
1231: (p_rec.location_id IS NULL)
1224: nvl(p_rec.loc_information17, hr_api.g_varchar2) OR
1225: nvl(hr_loc_shd.g_old_rec.loc_information18, hr_api.g_varchar2) <>
1226: nvl(p_rec.loc_information18, hr_api.g_varchar2) OR
1227: nvl(hr_loc_shd.g_old_rec.loc_information19, hr_api.g_varchar2) <>
1228: nvl(p_rec.loc_information19, hr_api.g_varchar2) OR
1229: nvl(hr_loc_shd.g_old_rec.loc_information20, hr_api.g_varchar2) <>
1230: nvl(p_rec.loc_information20, hr_api.g_varchar2) OR
1231: (p_rec.location_id IS NULL)
1232: THEN
1225: nvl(hr_loc_shd.g_old_rec.loc_information18, hr_api.g_varchar2) <>
1226: nvl(p_rec.loc_information18, hr_api.g_varchar2) OR
1227: nvl(hr_loc_shd.g_old_rec.loc_information19, hr_api.g_varchar2) <>
1228: nvl(p_rec.loc_information19, hr_api.g_varchar2) OR
1229: nvl(hr_loc_shd.g_old_rec.loc_information20, hr_api.g_varchar2) <>
1230: nvl(p_rec.loc_information20, hr_api.g_varchar2) OR
1231: (p_rec.location_id IS NULL)
1232: THEN
1233: -- Only execute the validation if absolutely necessary:
1226: nvl(p_rec.loc_information18, hr_api.g_varchar2) OR
1227: nvl(hr_loc_shd.g_old_rec.loc_information19, hr_api.g_varchar2) <>
1228: nvl(p_rec.loc_information19, hr_api.g_varchar2) OR
1229: nvl(hr_loc_shd.g_old_rec.loc_information20, hr_api.g_varchar2) <>
1230: nvl(p_rec.loc_information20, hr_api.g_varchar2) OR
1231: (p_rec.location_id IS NULL)
1232: THEN
1233: -- Only execute the validation if absolutely necessary:
1234: -- a) During update, the structure column value or any
1286: --
1287: -- HR_LOCATIONS - flexible address DDF
1288: -- ===================================
1289: --
1290: IF nvl(hr_loc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1291: nvl(p_rec.attribute_category, hr_api.g_varchar2) OR
1292: nvl(hr_loc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1293: nvl(p_rec.attribute1, hr_api.g_varchar2) OR
1294: nvl(hr_loc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1287: -- HR_LOCATIONS - flexible address DDF
1288: -- ===================================
1289: --
1290: IF nvl(hr_loc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1291: nvl(p_rec.attribute_category, hr_api.g_varchar2) OR
1292: nvl(hr_loc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1293: nvl(p_rec.attribute1, hr_api.g_varchar2) OR
1294: nvl(hr_loc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1295: nvl(p_rec.attribute2, hr_api.g_varchar2) OR
1288: -- ===================================
1289: --
1290: IF nvl(hr_loc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1291: nvl(p_rec.attribute_category, hr_api.g_varchar2) OR
1292: nvl(hr_loc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1293: nvl(p_rec.attribute1, hr_api.g_varchar2) OR
1294: nvl(hr_loc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1295: nvl(p_rec.attribute2, hr_api.g_varchar2) OR
1296: nvl(hr_loc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1289: --
1290: IF nvl(hr_loc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1291: nvl(p_rec.attribute_category, hr_api.g_varchar2) OR
1292: nvl(hr_loc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1293: nvl(p_rec.attribute1, hr_api.g_varchar2) OR
1294: nvl(hr_loc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1295: nvl(p_rec.attribute2, hr_api.g_varchar2) OR
1296: nvl(hr_loc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1297: nvl(p_rec.attribute3, hr_api.g_varchar2) OR
1290: IF nvl(hr_loc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1291: nvl(p_rec.attribute_category, hr_api.g_varchar2) OR
1292: nvl(hr_loc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1293: nvl(p_rec.attribute1, hr_api.g_varchar2) OR
1294: nvl(hr_loc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1295: nvl(p_rec.attribute2, hr_api.g_varchar2) OR
1296: nvl(hr_loc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1297: nvl(p_rec.attribute3, hr_api.g_varchar2) OR
1298: nvl(hr_loc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1291: nvl(p_rec.attribute_category, hr_api.g_varchar2) OR
1292: nvl(hr_loc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1293: nvl(p_rec.attribute1, hr_api.g_varchar2) OR
1294: nvl(hr_loc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1295: nvl(p_rec.attribute2, hr_api.g_varchar2) OR
1296: nvl(hr_loc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1297: nvl(p_rec.attribute3, hr_api.g_varchar2) OR
1298: nvl(hr_loc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1299: nvl(p_rec.attribute4, hr_api.g_varchar2) OR
1292: nvl(hr_loc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1293: nvl(p_rec.attribute1, hr_api.g_varchar2) OR
1294: nvl(hr_loc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1295: nvl(p_rec.attribute2, hr_api.g_varchar2) OR
1296: nvl(hr_loc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1297: nvl(p_rec.attribute3, hr_api.g_varchar2) OR
1298: nvl(hr_loc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1299: nvl(p_rec.attribute4, hr_api.g_varchar2) OR
1300: nvl(hr_loc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1293: nvl(p_rec.attribute1, hr_api.g_varchar2) OR
1294: nvl(hr_loc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1295: nvl(p_rec.attribute2, hr_api.g_varchar2) OR
1296: nvl(hr_loc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1297: nvl(p_rec.attribute3, hr_api.g_varchar2) OR
1298: nvl(hr_loc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1299: nvl(p_rec.attribute4, hr_api.g_varchar2) OR
1300: nvl(hr_loc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1301: nvl(p_rec.attribute5, hr_api.g_varchar2) OR
1294: nvl(hr_loc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1295: nvl(p_rec.attribute2, hr_api.g_varchar2) OR
1296: nvl(hr_loc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1297: nvl(p_rec.attribute3, hr_api.g_varchar2) OR
1298: nvl(hr_loc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1299: nvl(p_rec.attribute4, hr_api.g_varchar2) OR
1300: nvl(hr_loc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1301: nvl(p_rec.attribute5, hr_api.g_varchar2) OR
1302: nvl(hr_loc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1295: nvl(p_rec.attribute2, hr_api.g_varchar2) OR
1296: nvl(hr_loc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1297: nvl(p_rec.attribute3, hr_api.g_varchar2) OR
1298: nvl(hr_loc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1299: nvl(p_rec.attribute4, hr_api.g_varchar2) OR
1300: nvl(hr_loc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1301: nvl(p_rec.attribute5, hr_api.g_varchar2) OR
1302: nvl(hr_loc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1303: nvl(p_rec.attribute6, hr_api.g_varchar2) OR
1296: nvl(hr_loc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1297: nvl(p_rec.attribute3, hr_api.g_varchar2) OR
1298: nvl(hr_loc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1299: nvl(p_rec.attribute4, hr_api.g_varchar2) OR
1300: nvl(hr_loc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1301: nvl(p_rec.attribute5, hr_api.g_varchar2) OR
1302: nvl(hr_loc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1303: nvl(p_rec.attribute6, hr_api.g_varchar2) OR
1304: nvl(hr_loc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1297: nvl(p_rec.attribute3, hr_api.g_varchar2) OR
1298: nvl(hr_loc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1299: nvl(p_rec.attribute4, hr_api.g_varchar2) OR
1300: nvl(hr_loc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1301: nvl(p_rec.attribute5, hr_api.g_varchar2) OR
1302: nvl(hr_loc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1303: nvl(p_rec.attribute6, hr_api.g_varchar2) OR
1304: nvl(hr_loc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1305: nvl(p_rec.attribute7, hr_api.g_varchar2) OR
1298: nvl(hr_loc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1299: nvl(p_rec.attribute4, hr_api.g_varchar2) OR
1300: nvl(hr_loc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1301: nvl(p_rec.attribute5, hr_api.g_varchar2) OR
1302: nvl(hr_loc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1303: nvl(p_rec.attribute6, hr_api.g_varchar2) OR
1304: nvl(hr_loc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1305: nvl(p_rec.attribute7, hr_api.g_varchar2) OR
1306: nvl(hr_loc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1299: nvl(p_rec.attribute4, hr_api.g_varchar2) OR
1300: nvl(hr_loc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1301: nvl(p_rec.attribute5, hr_api.g_varchar2) OR
1302: nvl(hr_loc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1303: nvl(p_rec.attribute6, hr_api.g_varchar2) OR
1304: nvl(hr_loc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1305: nvl(p_rec.attribute7, hr_api.g_varchar2) OR
1306: nvl(hr_loc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1307: nvl(p_rec.attribute8, hr_api.g_varchar2) OR
1300: nvl(hr_loc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1301: nvl(p_rec.attribute5, hr_api.g_varchar2) OR
1302: nvl(hr_loc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1303: nvl(p_rec.attribute6, hr_api.g_varchar2) OR
1304: nvl(hr_loc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1305: nvl(p_rec.attribute7, hr_api.g_varchar2) OR
1306: nvl(hr_loc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1307: nvl(p_rec.attribute8, hr_api.g_varchar2) OR
1308: nvl(hr_loc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1301: nvl(p_rec.attribute5, hr_api.g_varchar2) OR
1302: nvl(hr_loc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1303: nvl(p_rec.attribute6, hr_api.g_varchar2) OR
1304: nvl(hr_loc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1305: nvl(p_rec.attribute7, hr_api.g_varchar2) OR
1306: nvl(hr_loc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1307: nvl(p_rec.attribute8, hr_api.g_varchar2) OR
1308: nvl(hr_loc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1309: nvl(p_rec.attribute9, hr_api.g_varchar2) OR
1302: nvl(hr_loc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1303: nvl(p_rec.attribute6, hr_api.g_varchar2) OR
1304: nvl(hr_loc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1305: nvl(p_rec.attribute7, hr_api.g_varchar2) OR
1306: nvl(hr_loc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1307: nvl(p_rec.attribute8, hr_api.g_varchar2) OR
1308: nvl(hr_loc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1309: nvl(p_rec.attribute9, hr_api.g_varchar2) OR
1310: nvl(hr_loc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1303: nvl(p_rec.attribute6, hr_api.g_varchar2) OR
1304: nvl(hr_loc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1305: nvl(p_rec.attribute7, hr_api.g_varchar2) OR
1306: nvl(hr_loc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1307: nvl(p_rec.attribute8, hr_api.g_varchar2) OR
1308: nvl(hr_loc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1309: nvl(p_rec.attribute9, hr_api.g_varchar2) OR
1310: nvl(hr_loc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1311: nvl(p_rec.attribute10, hr_api.g_varchar2) OR
1304: nvl(hr_loc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1305: nvl(p_rec.attribute7, hr_api.g_varchar2) OR
1306: nvl(hr_loc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1307: nvl(p_rec.attribute8, hr_api.g_varchar2) OR
1308: nvl(hr_loc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1309: nvl(p_rec.attribute9, hr_api.g_varchar2) OR
1310: nvl(hr_loc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1311: nvl(p_rec.attribute10, hr_api.g_varchar2) OR
1312: nvl(hr_loc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1305: nvl(p_rec.attribute7, hr_api.g_varchar2) OR
1306: nvl(hr_loc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1307: nvl(p_rec.attribute8, hr_api.g_varchar2) OR
1308: nvl(hr_loc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1309: nvl(p_rec.attribute9, hr_api.g_varchar2) OR
1310: nvl(hr_loc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1311: nvl(p_rec.attribute10, hr_api.g_varchar2) OR
1312: nvl(hr_loc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1313: nvl(p_rec.attribute11, hr_api.g_varchar2) OR
1306: nvl(hr_loc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1307: nvl(p_rec.attribute8, hr_api.g_varchar2) OR
1308: nvl(hr_loc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1309: nvl(p_rec.attribute9, hr_api.g_varchar2) OR
1310: nvl(hr_loc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1311: nvl(p_rec.attribute10, hr_api.g_varchar2) OR
1312: nvl(hr_loc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1313: nvl(p_rec.attribute11, hr_api.g_varchar2) OR
1314: nvl(hr_loc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1307: nvl(p_rec.attribute8, hr_api.g_varchar2) OR
1308: nvl(hr_loc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1309: nvl(p_rec.attribute9, hr_api.g_varchar2) OR
1310: nvl(hr_loc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1311: nvl(p_rec.attribute10, hr_api.g_varchar2) OR
1312: nvl(hr_loc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1313: nvl(p_rec.attribute11, hr_api.g_varchar2) OR
1314: nvl(hr_loc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1315: nvl(p_rec.attribute12, hr_api.g_varchar2) OR
1308: nvl(hr_loc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1309: nvl(p_rec.attribute9, hr_api.g_varchar2) OR
1310: nvl(hr_loc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1311: nvl(p_rec.attribute10, hr_api.g_varchar2) OR
1312: nvl(hr_loc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1313: nvl(p_rec.attribute11, hr_api.g_varchar2) OR
1314: nvl(hr_loc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1315: nvl(p_rec.attribute12, hr_api.g_varchar2) OR
1316: nvl(hr_loc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1309: nvl(p_rec.attribute9, hr_api.g_varchar2) OR
1310: nvl(hr_loc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1311: nvl(p_rec.attribute10, hr_api.g_varchar2) OR
1312: nvl(hr_loc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1313: nvl(p_rec.attribute11, hr_api.g_varchar2) OR
1314: nvl(hr_loc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1315: nvl(p_rec.attribute12, hr_api.g_varchar2) OR
1316: nvl(hr_loc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1317: nvl(p_rec.attribute13, hr_api.g_varchar2) OR
1310: nvl(hr_loc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1311: nvl(p_rec.attribute10, hr_api.g_varchar2) OR
1312: nvl(hr_loc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1313: nvl(p_rec.attribute11, hr_api.g_varchar2) OR
1314: nvl(hr_loc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1315: nvl(p_rec.attribute12, hr_api.g_varchar2) OR
1316: nvl(hr_loc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1317: nvl(p_rec.attribute13, hr_api.g_varchar2) OR
1318: nvl(hr_loc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1311: nvl(p_rec.attribute10, hr_api.g_varchar2) OR
1312: nvl(hr_loc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1313: nvl(p_rec.attribute11, hr_api.g_varchar2) OR
1314: nvl(hr_loc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1315: nvl(p_rec.attribute12, hr_api.g_varchar2) OR
1316: nvl(hr_loc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1317: nvl(p_rec.attribute13, hr_api.g_varchar2) OR
1318: nvl(hr_loc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1319: nvl(p_rec.attribute14, hr_api.g_varchar2) OR
1312: nvl(hr_loc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1313: nvl(p_rec.attribute11, hr_api.g_varchar2) OR
1314: nvl(hr_loc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1315: nvl(p_rec.attribute12, hr_api.g_varchar2) OR
1316: nvl(hr_loc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1317: nvl(p_rec.attribute13, hr_api.g_varchar2) OR
1318: nvl(hr_loc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1319: nvl(p_rec.attribute14, hr_api.g_varchar2) OR
1320: nvl(hr_loc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1313: nvl(p_rec.attribute11, hr_api.g_varchar2) OR
1314: nvl(hr_loc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1315: nvl(p_rec.attribute12, hr_api.g_varchar2) OR
1316: nvl(hr_loc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1317: nvl(p_rec.attribute13, hr_api.g_varchar2) OR
1318: nvl(hr_loc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1319: nvl(p_rec.attribute14, hr_api.g_varchar2) OR
1320: nvl(hr_loc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1321: nvl(p_rec.attribute15, hr_api.g_varchar2) OR
1314: nvl(hr_loc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1315: nvl(p_rec.attribute12, hr_api.g_varchar2) OR
1316: nvl(hr_loc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1317: nvl(p_rec.attribute13, hr_api.g_varchar2) OR
1318: nvl(hr_loc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1319: nvl(p_rec.attribute14, hr_api.g_varchar2) OR
1320: nvl(hr_loc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1321: nvl(p_rec.attribute15, hr_api.g_varchar2) OR
1322: nvl(hr_loc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1315: nvl(p_rec.attribute12, hr_api.g_varchar2) OR
1316: nvl(hr_loc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1317: nvl(p_rec.attribute13, hr_api.g_varchar2) OR
1318: nvl(hr_loc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1319: nvl(p_rec.attribute14, hr_api.g_varchar2) OR
1320: nvl(hr_loc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1321: nvl(p_rec.attribute15, hr_api.g_varchar2) OR
1322: nvl(hr_loc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1323: nvl(p_rec.attribute16, hr_api.g_varchar2) OR
1316: nvl(hr_loc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1317: nvl(p_rec.attribute13, hr_api.g_varchar2) OR
1318: nvl(hr_loc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1319: nvl(p_rec.attribute14, hr_api.g_varchar2) OR
1320: nvl(hr_loc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1321: nvl(p_rec.attribute15, hr_api.g_varchar2) OR
1322: nvl(hr_loc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1323: nvl(p_rec.attribute16, hr_api.g_varchar2) OR
1324: nvl(hr_loc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1317: nvl(p_rec.attribute13, hr_api.g_varchar2) OR
1318: nvl(hr_loc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1319: nvl(p_rec.attribute14, hr_api.g_varchar2) OR
1320: nvl(hr_loc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1321: nvl(p_rec.attribute15, hr_api.g_varchar2) OR
1322: nvl(hr_loc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1323: nvl(p_rec.attribute16, hr_api.g_varchar2) OR
1324: nvl(hr_loc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1325: nvl(p_rec.attribute17, hr_api.g_varchar2) OR
1318: nvl(hr_loc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1319: nvl(p_rec.attribute14, hr_api.g_varchar2) OR
1320: nvl(hr_loc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1321: nvl(p_rec.attribute15, hr_api.g_varchar2) OR
1322: nvl(hr_loc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1323: nvl(p_rec.attribute16, hr_api.g_varchar2) OR
1324: nvl(hr_loc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1325: nvl(p_rec.attribute17, hr_api.g_varchar2) OR
1326: nvl(hr_loc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1319: nvl(p_rec.attribute14, hr_api.g_varchar2) OR
1320: nvl(hr_loc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1321: nvl(p_rec.attribute15, hr_api.g_varchar2) OR
1322: nvl(hr_loc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1323: nvl(p_rec.attribute16, hr_api.g_varchar2) OR
1324: nvl(hr_loc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1325: nvl(p_rec.attribute17, hr_api.g_varchar2) OR
1326: nvl(hr_loc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1327: nvl(p_rec.attribute18, hr_api.g_varchar2) OR
1320: nvl(hr_loc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1321: nvl(p_rec.attribute15, hr_api.g_varchar2) OR
1322: nvl(hr_loc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1323: nvl(p_rec.attribute16, hr_api.g_varchar2) OR
1324: nvl(hr_loc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1325: nvl(p_rec.attribute17, hr_api.g_varchar2) OR
1326: nvl(hr_loc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1327: nvl(p_rec.attribute18, hr_api.g_varchar2) OR
1328: nvl(hr_loc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1321: nvl(p_rec.attribute15, hr_api.g_varchar2) OR
1322: nvl(hr_loc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1323: nvl(p_rec.attribute16, hr_api.g_varchar2) OR
1324: nvl(hr_loc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1325: nvl(p_rec.attribute17, hr_api.g_varchar2) OR
1326: nvl(hr_loc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1327: nvl(p_rec.attribute18, hr_api.g_varchar2) OR
1328: nvl(hr_loc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1329: nvl(p_rec.attribute19, hr_api.g_varchar2) OR
1322: nvl(hr_loc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1323: nvl(p_rec.attribute16, hr_api.g_varchar2) OR
1324: nvl(hr_loc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1325: nvl(p_rec.attribute17, hr_api.g_varchar2) OR
1326: nvl(hr_loc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1327: nvl(p_rec.attribute18, hr_api.g_varchar2) OR
1328: nvl(hr_loc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1329: nvl(p_rec.attribute19, hr_api.g_varchar2) OR
1330: nvl(hr_loc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1323: nvl(p_rec.attribute16, hr_api.g_varchar2) OR
1324: nvl(hr_loc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1325: nvl(p_rec.attribute17, hr_api.g_varchar2) OR
1326: nvl(hr_loc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1327: nvl(p_rec.attribute18, hr_api.g_varchar2) OR
1328: nvl(hr_loc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1329: nvl(p_rec.attribute19, hr_api.g_varchar2) OR
1330: nvl(hr_loc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1331: nvl(p_rec.attribute20, hr_api.g_varchar2)
1324: nvl(hr_loc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1325: nvl(p_rec.attribute17, hr_api.g_varchar2) OR
1326: nvl(hr_loc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1327: nvl(p_rec.attribute18, hr_api.g_varchar2) OR
1328: nvl(hr_loc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1329: nvl(p_rec.attribute19, hr_api.g_varchar2) OR
1330: nvl(hr_loc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1331: nvl(p_rec.attribute20, hr_api.g_varchar2)
1332: OR
1325: nvl(p_rec.attribute17, hr_api.g_varchar2) OR
1326: nvl(hr_loc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1327: nvl(p_rec.attribute18, hr_api.g_varchar2) OR
1328: nvl(hr_loc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1329: nvl(p_rec.attribute19, hr_api.g_varchar2) OR
1330: nvl(hr_loc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1331: nvl(p_rec.attribute20, hr_api.g_varchar2)
1332: OR
1333: (p_rec.location_id IS NULL)
1326: nvl(hr_loc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1327: nvl(p_rec.attribute18, hr_api.g_varchar2) OR
1328: nvl(hr_loc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1329: nvl(p_rec.attribute19, hr_api.g_varchar2) OR
1330: nvl(hr_loc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1331: nvl(p_rec.attribute20, hr_api.g_varchar2)
1332: OR
1333: (p_rec.location_id IS NULL)
1334: THEN
1327: nvl(p_rec.attribute18, hr_api.g_varchar2) OR
1328: nvl(hr_loc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1329: nvl(p_rec.attribute19, hr_api.g_varchar2) OR
1330: nvl(hr_loc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1331: nvl(p_rec.attribute20, hr_api.g_varchar2)
1332: OR
1333: (p_rec.location_id IS NULL)
1334: THEN
1335: -- Only execute the validation if absolutely necessary:
1388: --
1389: -- JG_HR_LOCATIONS - global localizations DDF
1390: -- ==========================================
1391: --
1392: IF nvl(hr_loc_shd.g_old_rec.global_attribute_category, hr_api.g_varchar2) <>
1393: nvl(p_rec.global_attribute_category, hr_api.g_varchar2) OR
1394: nvl(hr_loc_shd.g_old_rec.global_attribute1, hr_api.g_varchar2) <>
1395: nvl(p_rec.global_attribute1, hr_api.g_varchar2) OR
1396: nvl(hr_loc_shd.g_old_rec.global_attribute2, hr_api.g_varchar2) <>
1389: -- JG_HR_LOCATIONS - global localizations DDF
1390: -- ==========================================
1391: --
1392: IF nvl(hr_loc_shd.g_old_rec.global_attribute_category, hr_api.g_varchar2) <>
1393: nvl(p_rec.global_attribute_category, hr_api.g_varchar2) OR
1394: nvl(hr_loc_shd.g_old_rec.global_attribute1, hr_api.g_varchar2) <>
1395: nvl(p_rec.global_attribute1, hr_api.g_varchar2) OR
1396: nvl(hr_loc_shd.g_old_rec.global_attribute2, hr_api.g_varchar2) <>
1397: nvl(p_rec.global_attribute2, hr_api.g_varchar2) OR
1390: -- ==========================================
1391: --
1392: IF nvl(hr_loc_shd.g_old_rec.global_attribute_category, hr_api.g_varchar2) <>
1393: nvl(p_rec.global_attribute_category, hr_api.g_varchar2) OR
1394: nvl(hr_loc_shd.g_old_rec.global_attribute1, hr_api.g_varchar2) <>
1395: nvl(p_rec.global_attribute1, hr_api.g_varchar2) OR
1396: nvl(hr_loc_shd.g_old_rec.global_attribute2, hr_api.g_varchar2) <>
1397: nvl(p_rec.global_attribute2, hr_api.g_varchar2) OR
1398: nvl(hr_loc_shd.g_old_rec.global_attribute3, hr_api.g_varchar2) <>
1391: --
1392: IF nvl(hr_loc_shd.g_old_rec.global_attribute_category, hr_api.g_varchar2) <>
1393: nvl(p_rec.global_attribute_category, hr_api.g_varchar2) OR
1394: nvl(hr_loc_shd.g_old_rec.global_attribute1, hr_api.g_varchar2) <>
1395: nvl(p_rec.global_attribute1, hr_api.g_varchar2) OR
1396: nvl(hr_loc_shd.g_old_rec.global_attribute2, hr_api.g_varchar2) <>
1397: nvl(p_rec.global_attribute2, hr_api.g_varchar2) OR
1398: nvl(hr_loc_shd.g_old_rec.global_attribute3, hr_api.g_varchar2) <>
1399: nvl(p_rec.global_attribute3, hr_api.g_varchar2) OR
1392: IF nvl(hr_loc_shd.g_old_rec.global_attribute_category, hr_api.g_varchar2) <>
1393: nvl(p_rec.global_attribute_category, hr_api.g_varchar2) OR
1394: nvl(hr_loc_shd.g_old_rec.global_attribute1, hr_api.g_varchar2) <>
1395: nvl(p_rec.global_attribute1, hr_api.g_varchar2) OR
1396: nvl(hr_loc_shd.g_old_rec.global_attribute2, hr_api.g_varchar2) <>
1397: nvl(p_rec.global_attribute2, hr_api.g_varchar2) OR
1398: nvl(hr_loc_shd.g_old_rec.global_attribute3, hr_api.g_varchar2) <>
1399: nvl(p_rec.global_attribute3, hr_api.g_varchar2) OR
1400: nvl(hr_loc_shd.g_old_rec.global_attribute4, hr_api.g_varchar2) <>
1393: nvl(p_rec.global_attribute_category, hr_api.g_varchar2) OR
1394: nvl(hr_loc_shd.g_old_rec.global_attribute1, hr_api.g_varchar2) <>
1395: nvl(p_rec.global_attribute1, hr_api.g_varchar2) OR
1396: nvl(hr_loc_shd.g_old_rec.global_attribute2, hr_api.g_varchar2) <>
1397: nvl(p_rec.global_attribute2, hr_api.g_varchar2) OR
1398: nvl(hr_loc_shd.g_old_rec.global_attribute3, hr_api.g_varchar2) <>
1399: nvl(p_rec.global_attribute3, hr_api.g_varchar2) OR
1400: nvl(hr_loc_shd.g_old_rec.global_attribute4, hr_api.g_varchar2) <>
1401: nvl(p_rec.global_attribute4, hr_api.g_varchar2) OR
1394: nvl(hr_loc_shd.g_old_rec.global_attribute1, hr_api.g_varchar2) <>
1395: nvl(p_rec.global_attribute1, hr_api.g_varchar2) OR
1396: nvl(hr_loc_shd.g_old_rec.global_attribute2, hr_api.g_varchar2) <>
1397: nvl(p_rec.global_attribute2, hr_api.g_varchar2) OR
1398: nvl(hr_loc_shd.g_old_rec.global_attribute3, hr_api.g_varchar2) <>
1399: nvl(p_rec.global_attribute3, hr_api.g_varchar2) OR
1400: nvl(hr_loc_shd.g_old_rec.global_attribute4, hr_api.g_varchar2) <>
1401: nvl(p_rec.global_attribute4, hr_api.g_varchar2) OR
1402: nvl(hr_loc_shd.g_old_rec.global_attribute5, hr_api.g_varchar2) <>
1395: nvl(p_rec.global_attribute1, hr_api.g_varchar2) OR
1396: nvl(hr_loc_shd.g_old_rec.global_attribute2, hr_api.g_varchar2) <>
1397: nvl(p_rec.global_attribute2, hr_api.g_varchar2) OR
1398: nvl(hr_loc_shd.g_old_rec.global_attribute3, hr_api.g_varchar2) <>
1399: nvl(p_rec.global_attribute3, hr_api.g_varchar2) OR
1400: nvl(hr_loc_shd.g_old_rec.global_attribute4, hr_api.g_varchar2) <>
1401: nvl(p_rec.global_attribute4, hr_api.g_varchar2) OR
1402: nvl(hr_loc_shd.g_old_rec.global_attribute5, hr_api.g_varchar2) <>
1403: nvl(p_rec.global_attribute5, hr_api.g_varchar2) OR
1396: nvl(hr_loc_shd.g_old_rec.global_attribute2, hr_api.g_varchar2) <>
1397: nvl(p_rec.global_attribute2, hr_api.g_varchar2) OR
1398: nvl(hr_loc_shd.g_old_rec.global_attribute3, hr_api.g_varchar2) <>
1399: nvl(p_rec.global_attribute3, hr_api.g_varchar2) OR
1400: nvl(hr_loc_shd.g_old_rec.global_attribute4, hr_api.g_varchar2) <>
1401: nvl(p_rec.global_attribute4, hr_api.g_varchar2) OR
1402: nvl(hr_loc_shd.g_old_rec.global_attribute5, hr_api.g_varchar2) <>
1403: nvl(p_rec.global_attribute5, hr_api.g_varchar2) OR
1404: nvl(hr_loc_shd.g_old_rec.global_attribute6, hr_api.g_varchar2) <>
1397: nvl(p_rec.global_attribute2, hr_api.g_varchar2) OR
1398: nvl(hr_loc_shd.g_old_rec.global_attribute3, hr_api.g_varchar2) <>
1399: nvl(p_rec.global_attribute3, hr_api.g_varchar2) OR
1400: nvl(hr_loc_shd.g_old_rec.global_attribute4, hr_api.g_varchar2) <>
1401: nvl(p_rec.global_attribute4, hr_api.g_varchar2) OR
1402: nvl(hr_loc_shd.g_old_rec.global_attribute5, hr_api.g_varchar2) <>
1403: nvl(p_rec.global_attribute5, hr_api.g_varchar2) OR
1404: nvl(hr_loc_shd.g_old_rec.global_attribute6, hr_api.g_varchar2) <>
1405: nvl(p_rec.global_attribute6, hr_api.g_varchar2) OR
1398: nvl(hr_loc_shd.g_old_rec.global_attribute3, hr_api.g_varchar2) <>
1399: nvl(p_rec.global_attribute3, hr_api.g_varchar2) OR
1400: nvl(hr_loc_shd.g_old_rec.global_attribute4, hr_api.g_varchar2) <>
1401: nvl(p_rec.global_attribute4, hr_api.g_varchar2) OR
1402: nvl(hr_loc_shd.g_old_rec.global_attribute5, hr_api.g_varchar2) <>
1403: nvl(p_rec.global_attribute5, hr_api.g_varchar2) OR
1404: nvl(hr_loc_shd.g_old_rec.global_attribute6, hr_api.g_varchar2) <>
1405: nvl(p_rec.global_attribute6, hr_api.g_varchar2) OR
1406: nvl(hr_loc_shd.g_old_rec.global_attribute7, hr_api.g_varchar2) <>
1399: nvl(p_rec.global_attribute3, hr_api.g_varchar2) OR
1400: nvl(hr_loc_shd.g_old_rec.global_attribute4, hr_api.g_varchar2) <>
1401: nvl(p_rec.global_attribute4, hr_api.g_varchar2) OR
1402: nvl(hr_loc_shd.g_old_rec.global_attribute5, hr_api.g_varchar2) <>
1403: nvl(p_rec.global_attribute5, hr_api.g_varchar2) OR
1404: nvl(hr_loc_shd.g_old_rec.global_attribute6, hr_api.g_varchar2) <>
1405: nvl(p_rec.global_attribute6, hr_api.g_varchar2) OR
1406: nvl(hr_loc_shd.g_old_rec.global_attribute7, hr_api.g_varchar2) <>
1407: nvl(p_rec.global_attribute7, hr_api.g_varchar2) OR
1400: nvl(hr_loc_shd.g_old_rec.global_attribute4, hr_api.g_varchar2) <>
1401: nvl(p_rec.global_attribute4, hr_api.g_varchar2) OR
1402: nvl(hr_loc_shd.g_old_rec.global_attribute5, hr_api.g_varchar2) <>
1403: nvl(p_rec.global_attribute5, hr_api.g_varchar2) OR
1404: nvl(hr_loc_shd.g_old_rec.global_attribute6, hr_api.g_varchar2) <>
1405: nvl(p_rec.global_attribute6, hr_api.g_varchar2) OR
1406: nvl(hr_loc_shd.g_old_rec.global_attribute7, hr_api.g_varchar2) <>
1407: nvl(p_rec.global_attribute7, hr_api.g_varchar2) OR
1408: nvl(hr_loc_shd.g_old_rec.global_attribute8, hr_api.g_varchar2) <>
1401: nvl(p_rec.global_attribute4, hr_api.g_varchar2) OR
1402: nvl(hr_loc_shd.g_old_rec.global_attribute5, hr_api.g_varchar2) <>
1403: nvl(p_rec.global_attribute5, hr_api.g_varchar2) OR
1404: nvl(hr_loc_shd.g_old_rec.global_attribute6, hr_api.g_varchar2) <>
1405: nvl(p_rec.global_attribute6, hr_api.g_varchar2) OR
1406: nvl(hr_loc_shd.g_old_rec.global_attribute7, hr_api.g_varchar2) <>
1407: nvl(p_rec.global_attribute7, hr_api.g_varchar2) OR
1408: nvl(hr_loc_shd.g_old_rec.global_attribute8, hr_api.g_varchar2) <>
1409: nvl(p_rec.global_attribute8, hr_api.g_varchar2) OR
1402: nvl(hr_loc_shd.g_old_rec.global_attribute5, hr_api.g_varchar2) <>
1403: nvl(p_rec.global_attribute5, hr_api.g_varchar2) OR
1404: nvl(hr_loc_shd.g_old_rec.global_attribute6, hr_api.g_varchar2) <>
1405: nvl(p_rec.global_attribute6, hr_api.g_varchar2) OR
1406: nvl(hr_loc_shd.g_old_rec.global_attribute7, hr_api.g_varchar2) <>
1407: nvl(p_rec.global_attribute7, hr_api.g_varchar2) OR
1408: nvl(hr_loc_shd.g_old_rec.global_attribute8, hr_api.g_varchar2) <>
1409: nvl(p_rec.global_attribute8, hr_api.g_varchar2) OR
1410: nvl(hr_loc_shd.g_old_rec.global_attribute9, hr_api.g_varchar2) <>
1403: nvl(p_rec.global_attribute5, hr_api.g_varchar2) OR
1404: nvl(hr_loc_shd.g_old_rec.global_attribute6, hr_api.g_varchar2) <>
1405: nvl(p_rec.global_attribute6, hr_api.g_varchar2) OR
1406: nvl(hr_loc_shd.g_old_rec.global_attribute7, hr_api.g_varchar2) <>
1407: nvl(p_rec.global_attribute7, hr_api.g_varchar2) OR
1408: nvl(hr_loc_shd.g_old_rec.global_attribute8, hr_api.g_varchar2) <>
1409: nvl(p_rec.global_attribute8, hr_api.g_varchar2) OR
1410: nvl(hr_loc_shd.g_old_rec.global_attribute9, hr_api.g_varchar2) <>
1411: nvl(p_rec.global_attribute9, hr_api.g_varchar2) OR
1404: nvl(hr_loc_shd.g_old_rec.global_attribute6, hr_api.g_varchar2) <>
1405: nvl(p_rec.global_attribute6, hr_api.g_varchar2) OR
1406: nvl(hr_loc_shd.g_old_rec.global_attribute7, hr_api.g_varchar2) <>
1407: nvl(p_rec.global_attribute7, hr_api.g_varchar2) OR
1408: nvl(hr_loc_shd.g_old_rec.global_attribute8, hr_api.g_varchar2) <>
1409: nvl(p_rec.global_attribute8, hr_api.g_varchar2) OR
1410: nvl(hr_loc_shd.g_old_rec.global_attribute9, hr_api.g_varchar2) <>
1411: nvl(p_rec.global_attribute9, hr_api.g_varchar2) OR
1412: nvl(hr_loc_shd.g_old_rec.global_attribute10, hr_api.g_varchar2) <>
1405: nvl(p_rec.global_attribute6, hr_api.g_varchar2) OR
1406: nvl(hr_loc_shd.g_old_rec.global_attribute7, hr_api.g_varchar2) <>
1407: nvl(p_rec.global_attribute7, hr_api.g_varchar2) OR
1408: nvl(hr_loc_shd.g_old_rec.global_attribute8, hr_api.g_varchar2) <>
1409: nvl(p_rec.global_attribute8, hr_api.g_varchar2) OR
1410: nvl(hr_loc_shd.g_old_rec.global_attribute9, hr_api.g_varchar2) <>
1411: nvl(p_rec.global_attribute9, hr_api.g_varchar2) OR
1412: nvl(hr_loc_shd.g_old_rec.global_attribute10, hr_api.g_varchar2) <>
1413: nvl(p_rec.global_attribute10, hr_api.g_varchar2) OR
1406: nvl(hr_loc_shd.g_old_rec.global_attribute7, hr_api.g_varchar2) <>
1407: nvl(p_rec.global_attribute7, hr_api.g_varchar2) OR
1408: nvl(hr_loc_shd.g_old_rec.global_attribute8, hr_api.g_varchar2) <>
1409: nvl(p_rec.global_attribute8, hr_api.g_varchar2) OR
1410: nvl(hr_loc_shd.g_old_rec.global_attribute9, hr_api.g_varchar2) <>
1411: nvl(p_rec.global_attribute9, hr_api.g_varchar2) OR
1412: nvl(hr_loc_shd.g_old_rec.global_attribute10, hr_api.g_varchar2) <>
1413: nvl(p_rec.global_attribute10, hr_api.g_varchar2) OR
1414: nvl(hr_loc_shd.g_old_rec.global_attribute11, hr_api.g_varchar2) <>
1407: nvl(p_rec.global_attribute7, hr_api.g_varchar2) OR
1408: nvl(hr_loc_shd.g_old_rec.global_attribute8, hr_api.g_varchar2) <>
1409: nvl(p_rec.global_attribute8, hr_api.g_varchar2) OR
1410: nvl(hr_loc_shd.g_old_rec.global_attribute9, hr_api.g_varchar2) <>
1411: nvl(p_rec.global_attribute9, hr_api.g_varchar2) OR
1412: nvl(hr_loc_shd.g_old_rec.global_attribute10, hr_api.g_varchar2) <>
1413: nvl(p_rec.global_attribute10, hr_api.g_varchar2) OR
1414: nvl(hr_loc_shd.g_old_rec.global_attribute11, hr_api.g_varchar2) <>
1415: nvl(p_rec.global_attribute11, hr_api.g_varchar2) OR
1408: nvl(hr_loc_shd.g_old_rec.global_attribute8, hr_api.g_varchar2) <>
1409: nvl(p_rec.global_attribute8, hr_api.g_varchar2) OR
1410: nvl(hr_loc_shd.g_old_rec.global_attribute9, hr_api.g_varchar2) <>
1411: nvl(p_rec.global_attribute9, hr_api.g_varchar2) OR
1412: nvl(hr_loc_shd.g_old_rec.global_attribute10, hr_api.g_varchar2) <>
1413: nvl(p_rec.global_attribute10, hr_api.g_varchar2) OR
1414: nvl(hr_loc_shd.g_old_rec.global_attribute11, hr_api.g_varchar2) <>
1415: nvl(p_rec.global_attribute11, hr_api.g_varchar2) OR
1416: nvl(hr_loc_shd.g_old_rec.global_attribute12, hr_api.g_varchar2) <>
1409: nvl(p_rec.global_attribute8, hr_api.g_varchar2) OR
1410: nvl(hr_loc_shd.g_old_rec.global_attribute9, hr_api.g_varchar2) <>
1411: nvl(p_rec.global_attribute9, hr_api.g_varchar2) OR
1412: nvl(hr_loc_shd.g_old_rec.global_attribute10, hr_api.g_varchar2) <>
1413: nvl(p_rec.global_attribute10, hr_api.g_varchar2) OR
1414: nvl(hr_loc_shd.g_old_rec.global_attribute11, hr_api.g_varchar2) <>
1415: nvl(p_rec.global_attribute11, hr_api.g_varchar2) OR
1416: nvl(hr_loc_shd.g_old_rec.global_attribute12, hr_api.g_varchar2) <>
1417: nvl(p_rec.global_attribute12, hr_api.g_varchar2) OR
1410: nvl(hr_loc_shd.g_old_rec.global_attribute9, hr_api.g_varchar2) <>
1411: nvl(p_rec.global_attribute9, hr_api.g_varchar2) OR
1412: nvl(hr_loc_shd.g_old_rec.global_attribute10, hr_api.g_varchar2) <>
1413: nvl(p_rec.global_attribute10, hr_api.g_varchar2) OR
1414: nvl(hr_loc_shd.g_old_rec.global_attribute11, hr_api.g_varchar2) <>
1415: nvl(p_rec.global_attribute11, hr_api.g_varchar2) OR
1416: nvl(hr_loc_shd.g_old_rec.global_attribute12, hr_api.g_varchar2) <>
1417: nvl(p_rec.global_attribute12, hr_api.g_varchar2) OR
1418: nvl(hr_loc_shd.g_old_rec.global_attribute13, hr_api.g_varchar2) <>
1411: nvl(p_rec.global_attribute9, hr_api.g_varchar2) OR
1412: nvl(hr_loc_shd.g_old_rec.global_attribute10, hr_api.g_varchar2) <>
1413: nvl(p_rec.global_attribute10, hr_api.g_varchar2) OR
1414: nvl(hr_loc_shd.g_old_rec.global_attribute11, hr_api.g_varchar2) <>
1415: nvl(p_rec.global_attribute11, hr_api.g_varchar2) OR
1416: nvl(hr_loc_shd.g_old_rec.global_attribute12, hr_api.g_varchar2) <>
1417: nvl(p_rec.global_attribute12, hr_api.g_varchar2) OR
1418: nvl(hr_loc_shd.g_old_rec.global_attribute13, hr_api.g_varchar2) <>
1419: nvl(p_rec.global_attribute13, hr_api.g_varchar2) OR
1412: nvl(hr_loc_shd.g_old_rec.global_attribute10, hr_api.g_varchar2) <>
1413: nvl(p_rec.global_attribute10, hr_api.g_varchar2) OR
1414: nvl(hr_loc_shd.g_old_rec.global_attribute11, hr_api.g_varchar2) <>
1415: nvl(p_rec.global_attribute11, hr_api.g_varchar2) OR
1416: nvl(hr_loc_shd.g_old_rec.global_attribute12, hr_api.g_varchar2) <>
1417: nvl(p_rec.global_attribute12, hr_api.g_varchar2) OR
1418: nvl(hr_loc_shd.g_old_rec.global_attribute13, hr_api.g_varchar2) <>
1419: nvl(p_rec.global_attribute13, hr_api.g_varchar2) OR
1420: nvl(hr_loc_shd.g_old_rec.global_attribute14, hr_api.g_varchar2) <>
1413: nvl(p_rec.global_attribute10, hr_api.g_varchar2) OR
1414: nvl(hr_loc_shd.g_old_rec.global_attribute11, hr_api.g_varchar2) <>
1415: nvl(p_rec.global_attribute11, hr_api.g_varchar2) OR
1416: nvl(hr_loc_shd.g_old_rec.global_attribute12, hr_api.g_varchar2) <>
1417: nvl(p_rec.global_attribute12, hr_api.g_varchar2) OR
1418: nvl(hr_loc_shd.g_old_rec.global_attribute13, hr_api.g_varchar2) <>
1419: nvl(p_rec.global_attribute13, hr_api.g_varchar2) OR
1420: nvl(hr_loc_shd.g_old_rec.global_attribute14, hr_api.g_varchar2) <>
1421: nvl(p_rec.global_attribute14, hr_api.g_varchar2) OR
1414: nvl(hr_loc_shd.g_old_rec.global_attribute11, hr_api.g_varchar2) <>
1415: nvl(p_rec.global_attribute11, hr_api.g_varchar2) OR
1416: nvl(hr_loc_shd.g_old_rec.global_attribute12, hr_api.g_varchar2) <>
1417: nvl(p_rec.global_attribute12, hr_api.g_varchar2) OR
1418: nvl(hr_loc_shd.g_old_rec.global_attribute13, hr_api.g_varchar2) <>
1419: nvl(p_rec.global_attribute13, hr_api.g_varchar2) OR
1420: nvl(hr_loc_shd.g_old_rec.global_attribute14, hr_api.g_varchar2) <>
1421: nvl(p_rec.global_attribute14, hr_api.g_varchar2) OR
1422: nvl(hr_loc_shd.g_old_rec.global_attribute15, hr_api.g_varchar2) <>
1415: nvl(p_rec.global_attribute11, hr_api.g_varchar2) OR
1416: nvl(hr_loc_shd.g_old_rec.global_attribute12, hr_api.g_varchar2) <>
1417: nvl(p_rec.global_attribute12, hr_api.g_varchar2) OR
1418: nvl(hr_loc_shd.g_old_rec.global_attribute13, hr_api.g_varchar2) <>
1419: nvl(p_rec.global_attribute13, hr_api.g_varchar2) OR
1420: nvl(hr_loc_shd.g_old_rec.global_attribute14, hr_api.g_varchar2) <>
1421: nvl(p_rec.global_attribute14, hr_api.g_varchar2) OR
1422: nvl(hr_loc_shd.g_old_rec.global_attribute15, hr_api.g_varchar2) <>
1423: nvl(p_rec.global_attribute15, hr_api.g_varchar2) OR
1416: nvl(hr_loc_shd.g_old_rec.global_attribute12, hr_api.g_varchar2) <>
1417: nvl(p_rec.global_attribute12, hr_api.g_varchar2) OR
1418: nvl(hr_loc_shd.g_old_rec.global_attribute13, hr_api.g_varchar2) <>
1419: nvl(p_rec.global_attribute13, hr_api.g_varchar2) OR
1420: nvl(hr_loc_shd.g_old_rec.global_attribute14, hr_api.g_varchar2) <>
1421: nvl(p_rec.global_attribute14, hr_api.g_varchar2) OR
1422: nvl(hr_loc_shd.g_old_rec.global_attribute15, hr_api.g_varchar2) <>
1423: nvl(p_rec.global_attribute15, hr_api.g_varchar2) OR
1424: nvl(hr_loc_shd.g_old_rec.global_attribute16, hr_api.g_varchar2) <>
1417: nvl(p_rec.global_attribute12, hr_api.g_varchar2) OR
1418: nvl(hr_loc_shd.g_old_rec.global_attribute13, hr_api.g_varchar2) <>
1419: nvl(p_rec.global_attribute13, hr_api.g_varchar2) OR
1420: nvl(hr_loc_shd.g_old_rec.global_attribute14, hr_api.g_varchar2) <>
1421: nvl(p_rec.global_attribute14, hr_api.g_varchar2) OR
1422: nvl(hr_loc_shd.g_old_rec.global_attribute15, hr_api.g_varchar2) <>
1423: nvl(p_rec.global_attribute15, hr_api.g_varchar2) OR
1424: nvl(hr_loc_shd.g_old_rec.global_attribute16, hr_api.g_varchar2) <>
1425: nvl(p_rec.global_attribute16, hr_api.g_varchar2) OR
1418: nvl(hr_loc_shd.g_old_rec.global_attribute13, hr_api.g_varchar2) <>
1419: nvl(p_rec.global_attribute13, hr_api.g_varchar2) OR
1420: nvl(hr_loc_shd.g_old_rec.global_attribute14, hr_api.g_varchar2) <>
1421: nvl(p_rec.global_attribute14, hr_api.g_varchar2) OR
1422: nvl(hr_loc_shd.g_old_rec.global_attribute15, hr_api.g_varchar2) <>
1423: nvl(p_rec.global_attribute15, hr_api.g_varchar2) OR
1424: nvl(hr_loc_shd.g_old_rec.global_attribute16, hr_api.g_varchar2) <>
1425: nvl(p_rec.global_attribute16, hr_api.g_varchar2) OR
1426: nvl(hr_loc_shd.g_old_rec.global_attribute17, hr_api.g_varchar2) <>
1419: nvl(p_rec.global_attribute13, hr_api.g_varchar2) OR
1420: nvl(hr_loc_shd.g_old_rec.global_attribute14, hr_api.g_varchar2) <>
1421: nvl(p_rec.global_attribute14, hr_api.g_varchar2) OR
1422: nvl(hr_loc_shd.g_old_rec.global_attribute15, hr_api.g_varchar2) <>
1423: nvl(p_rec.global_attribute15, hr_api.g_varchar2) OR
1424: nvl(hr_loc_shd.g_old_rec.global_attribute16, hr_api.g_varchar2) <>
1425: nvl(p_rec.global_attribute16, hr_api.g_varchar2) OR
1426: nvl(hr_loc_shd.g_old_rec.global_attribute17, hr_api.g_varchar2) <>
1427: nvl(p_rec.global_attribute17, hr_api.g_varchar2) OR
1420: nvl(hr_loc_shd.g_old_rec.global_attribute14, hr_api.g_varchar2) <>
1421: nvl(p_rec.global_attribute14, hr_api.g_varchar2) OR
1422: nvl(hr_loc_shd.g_old_rec.global_attribute15, hr_api.g_varchar2) <>
1423: nvl(p_rec.global_attribute15, hr_api.g_varchar2) OR
1424: nvl(hr_loc_shd.g_old_rec.global_attribute16, hr_api.g_varchar2) <>
1425: nvl(p_rec.global_attribute16, hr_api.g_varchar2) OR
1426: nvl(hr_loc_shd.g_old_rec.global_attribute17, hr_api.g_varchar2) <>
1427: nvl(p_rec.global_attribute17, hr_api.g_varchar2) OR
1428: nvl(hr_loc_shd.g_old_rec.global_attribute18, hr_api.g_varchar2) <>
1421: nvl(p_rec.global_attribute14, hr_api.g_varchar2) OR
1422: nvl(hr_loc_shd.g_old_rec.global_attribute15, hr_api.g_varchar2) <>
1423: nvl(p_rec.global_attribute15, hr_api.g_varchar2) OR
1424: nvl(hr_loc_shd.g_old_rec.global_attribute16, hr_api.g_varchar2) <>
1425: nvl(p_rec.global_attribute16, hr_api.g_varchar2) OR
1426: nvl(hr_loc_shd.g_old_rec.global_attribute17, hr_api.g_varchar2) <>
1427: nvl(p_rec.global_attribute17, hr_api.g_varchar2) OR
1428: nvl(hr_loc_shd.g_old_rec.global_attribute18, hr_api.g_varchar2) <>
1429: nvl(p_rec.global_attribute18, hr_api.g_varchar2) OR
1422: nvl(hr_loc_shd.g_old_rec.global_attribute15, hr_api.g_varchar2) <>
1423: nvl(p_rec.global_attribute15, hr_api.g_varchar2) OR
1424: nvl(hr_loc_shd.g_old_rec.global_attribute16, hr_api.g_varchar2) <>
1425: nvl(p_rec.global_attribute16, hr_api.g_varchar2) OR
1426: nvl(hr_loc_shd.g_old_rec.global_attribute17, hr_api.g_varchar2) <>
1427: nvl(p_rec.global_attribute17, hr_api.g_varchar2) OR
1428: nvl(hr_loc_shd.g_old_rec.global_attribute18, hr_api.g_varchar2) <>
1429: nvl(p_rec.global_attribute18, hr_api.g_varchar2) OR
1430: nvl(hr_loc_shd.g_old_rec.global_attribute19, hr_api.g_varchar2) <>
1423: nvl(p_rec.global_attribute15, hr_api.g_varchar2) OR
1424: nvl(hr_loc_shd.g_old_rec.global_attribute16, hr_api.g_varchar2) <>
1425: nvl(p_rec.global_attribute16, hr_api.g_varchar2) OR
1426: nvl(hr_loc_shd.g_old_rec.global_attribute17, hr_api.g_varchar2) <>
1427: nvl(p_rec.global_attribute17, hr_api.g_varchar2) OR
1428: nvl(hr_loc_shd.g_old_rec.global_attribute18, hr_api.g_varchar2) <>
1429: nvl(p_rec.global_attribute18, hr_api.g_varchar2) OR
1430: nvl(hr_loc_shd.g_old_rec.global_attribute19, hr_api.g_varchar2) <>
1431: nvl(p_rec.global_attribute19, hr_api.g_varchar2) OR
1424: nvl(hr_loc_shd.g_old_rec.global_attribute16, hr_api.g_varchar2) <>
1425: nvl(p_rec.global_attribute16, hr_api.g_varchar2) OR
1426: nvl(hr_loc_shd.g_old_rec.global_attribute17, hr_api.g_varchar2) <>
1427: nvl(p_rec.global_attribute17, hr_api.g_varchar2) OR
1428: nvl(hr_loc_shd.g_old_rec.global_attribute18, hr_api.g_varchar2) <>
1429: nvl(p_rec.global_attribute18, hr_api.g_varchar2) OR
1430: nvl(hr_loc_shd.g_old_rec.global_attribute19, hr_api.g_varchar2) <>
1431: nvl(p_rec.global_attribute19, hr_api.g_varchar2) OR
1432: nvl(hr_loc_shd.g_old_rec.global_attribute20, hr_api.g_varchar2) <>
1425: nvl(p_rec.global_attribute16, hr_api.g_varchar2) OR
1426: nvl(hr_loc_shd.g_old_rec.global_attribute17, hr_api.g_varchar2) <>
1427: nvl(p_rec.global_attribute17, hr_api.g_varchar2) OR
1428: nvl(hr_loc_shd.g_old_rec.global_attribute18, hr_api.g_varchar2) <>
1429: nvl(p_rec.global_attribute18, hr_api.g_varchar2) OR
1430: nvl(hr_loc_shd.g_old_rec.global_attribute19, hr_api.g_varchar2) <>
1431: nvl(p_rec.global_attribute19, hr_api.g_varchar2) OR
1432: nvl(hr_loc_shd.g_old_rec.global_attribute20, hr_api.g_varchar2) <>
1433: nvl(p_rec.global_attribute20, hr_api.g_varchar2)
1426: nvl(hr_loc_shd.g_old_rec.global_attribute17, hr_api.g_varchar2) <>
1427: nvl(p_rec.global_attribute17, hr_api.g_varchar2) OR
1428: nvl(hr_loc_shd.g_old_rec.global_attribute18, hr_api.g_varchar2) <>
1429: nvl(p_rec.global_attribute18, hr_api.g_varchar2) OR
1430: nvl(hr_loc_shd.g_old_rec.global_attribute19, hr_api.g_varchar2) <>
1431: nvl(p_rec.global_attribute19, hr_api.g_varchar2) OR
1432: nvl(hr_loc_shd.g_old_rec.global_attribute20, hr_api.g_varchar2) <>
1433: nvl(p_rec.global_attribute20, hr_api.g_varchar2)
1434: OR
1427: nvl(p_rec.global_attribute17, hr_api.g_varchar2) OR
1428: nvl(hr_loc_shd.g_old_rec.global_attribute18, hr_api.g_varchar2) <>
1429: nvl(p_rec.global_attribute18, hr_api.g_varchar2) OR
1430: nvl(hr_loc_shd.g_old_rec.global_attribute19, hr_api.g_varchar2) <>
1431: nvl(p_rec.global_attribute19, hr_api.g_varchar2) OR
1432: nvl(hr_loc_shd.g_old_rec.global_attribute20, hr_api.g_varchar2) <>
1433: nvl(p_rec.global_attribute20, hr_api.g_varchar2)
1434: OR
1435: (p_rec.location_id IS NULL)
1428: nvl(hr_loc_shd.g_old_rec.global_attribute18, hr_api.g_varchar2) <>
1429: nvl(p_rec.global_attribute18, hr_api.g_varchar2) OR
1430: nvl(hr_loc_shd.g_old_rec.global_attribute19, hr_api.g_varchar2) <>
1431: nvl(p_rec.global_attribute19, hr_api.g_varchar2) OR
1432: nvl(hr_loc_shd.g_old_rec.global_attribute20, hr_api.g_varchar2) <>
1433: nvl(p_rec.global_attribute20, hr_api.g_varchar2)
1434: OR
1435: (p_rec.location_id IS NULL)
1436: THEN
1429: nvl(p_rec.global_attribute18, hr_api.g_varchar2) OR
1430: nvl(hr_loc_shd.g_old_rec.global_attribute19, hr_api.g_varchar2) <>
1431: nvl(p_rec.global_attribute19, hr_api.g_varchar2) OR
1432: nvl(hr_loc_shd.g_old_rec.global_attribute20, hr_api.g_varchar2) <>
1433: nvl(p_rec.global_attribute20, hr_api.g_varchar2)
1434: OR
1435: (p_rec.location_id IS NULL)
1436: THEN
1437: -- Only execute the validation if absolutely necessary:
1516: -- at present. If this changes, "CLIENT_INFO" may require setting - see
1517: -- API strategy page 12-29 onwards.
1518: --
1519: IF p_rec.business_group_id IS NOT NULL THEN
1520: hr_api.validate_bus_grp_id(p_rec.business_group_id);
1521: END IF;
1522: --
1523: --
1524: hr_utility.set_location(l_proc, 10);