eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_LOC_BUS dependencies on HR_LOC_SHD

Line 255: nvl (hr_loc_shd.g_old_rec.ship_to_location_id, hr_api.g_number) OR

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: --

Line 257: nvl (hr_loc_shd.g_old_rec.ship_to_site_flag, hr_api.g_varchar2) THEN

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: --

Line 420: (p_designated_receiver_id <> nvl (hr_loc_shd.g_old_rec.designated_receiver_id,

416: --
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

Line 559: IF ( p_inventory_organization_id <> nvl (hr_loc_shd.g_old_rec.inventory_organization_id, hr_api.g_number) ) OR

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

Line 680: IF ( p_tax_name <> nvl (hr_loc_shd.g_old_rec.tax_name, hr_api.g_varchar2) )

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: --

Line 767: IF ( nvl(hr_loc_shd.g_old_rec.style, hr_api.g_varchar2) <> p_style)

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: --

Line 843: IF ( nvl(hr_loc_shd.g_old_rec.timezone_code, hr_api.g_varchar2)

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: --

Line 1144: PROCEDURE chk_non_updateable_args(p_rec IN hr_loc_shd.g_rec_type) IS

1140: --
1141: -- {End Of Comments}
1142: -- ---------------------------------------------------------------------------
1143: --
1144: PROCEDURE chk_non_updateable_args(p_rec IN hr_loc_shd.g_rec_type) IS
1145: --
1146: l_proc VARCHAR2(72) := g_package||'chk_non_updateable_args';
1147: l_error EXCEPTION;
1148: l_argument VARCHAR2(30);

Line 1156: IF NOT hr_loc_shd.api_updating

1152: --
1153: -- Only proceed with validation if a row exists for
1154: -- the current record in the HR Schema
1155: --
1156: IF NOT hr_loc_shd.api_updating
1157: (p_location_id => p_rec.location_id,
1158: p_object_version_number => p_rec.object_version_number)
1159: THEN
1160: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 1168: nvl (hr_loc_shd.g_old_rec.business_group_id, hr_api.g_number) THEN

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: --

Line 1212: (p_rec IN hr_loc_shd.g_rec_type) IS

1208: -- Internal Row Handler Use Only.
1209: --
1210: -- ---------------------------------------------------------------------------
1211: PROCEDURE chk_df
1212: (p_rec IN hr_loc_shd.g_rec_type) IS
1213: --
1214: l_proc VARCHAR2(72) := g_package||'chk_df';
1215: --
1216: BEGIN

Line 1223: IF nvl(hr_loc_shd.g_old_rec.style, hr_api.g_varchar2) <>

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) <>

Line 1225: nvl(hr_loc_shd.g_old_rec.address_line_1, hr_api.g_varchar2) <>

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) <>

Line 1227: nvl(hr_loc_shd.g_old_rec.address_line_2, hr_api.g_varchar2) <>

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) <>

Line 1229: nvl(hr_loc_shd.g_old_rec.address_line_3, hr_api.g_varchar2) <>

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) <>

Line 1231: nvl(hr_loc_shd.g_old_rec.country, hr_api.g_varchar2) <>

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) <>

Line 1233: nvl(hr_loc_shd.g_old_rec.postal_code, hr_api.g_varchar2) <>

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) <>

Line 1235: nvl(hr_loc_shd.g_old_rec.region_1, hr_api.g_varchar2) <>

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) <>

Line 1237: nvl(hr_loc_shd.g_old_rec.region_2, hr_api.g_varchar2) <>

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) <>

Line 1239: nvl(hr_loc_shd.g_old_rec.region_3, hr_api.g_varchar2) <>

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) <>

Line 1241: nvl(hr_loc_shd.g_old_rec.telephone_number_1, hr_api.g_varchar2) <>

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) <>

Line 1243: nvl(hr_loc_shd.g_old_rec.telephone_number_2, hr_api.g_varchar2) <>

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) <>

Line 1245: nvl(hr_loc_shd.g_old_rec.telephone_number_3, hr_api.g_varchar2) <>

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) <>

Line 1247: nvl(hr_loc_shd.g_old_rec.town_or_city, hr_api.g_varchar2) <>

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) <>

Line 1249: nvl(hr_loc_shd.g_old_rec.loc_information13, hr_api.g_varchar2) <>

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) <>

Line 1251: nvl(hr_loc_shd.g_old_rec.loc_information14, hr_api.g_varchar2) <>

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) <>

Line 1253: nvl(hr_loc_shd.g_old_rec.loc_information15, hr_api.g_varchar2) <>

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) <>

Line 1255: nvl(hr_loc_shd.g_old_rec.loc_information16, hr_api.g_varchar2) <>

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) <>

Line 1257: nvl(hr_loc_shd.g_old_rec.loc_information17, hr_api.g_varchar2) <>

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) <>

Line 1259: nvl(hr_loc_shd.g_old_rec.loc_information18, hr_api.g_varchar2) <>

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) <>

Line 1261: nvl(hr_loc_shd.g_old_rec.loc_information19, hr_api.g_varchar2) <>

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)

Line 1263: nvl(hr_loc_shd.g_old_rec.loc_information20, hr_api.g_varchar2) <>

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:

Line 1324: IF nvl(hr_loc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

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) <>

Line 1326: nvl(hr_loc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

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) <>

Line 1328: nvl(hr_loc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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) <>

Line 1330: nvl(hr_loc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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) <>

Line 1332: nvl(hr_loc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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) <>

Line 1334: nvl(hr_loc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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) <>

Line 1336: nvl(hr_loc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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) <>

Line 1338: nvl(hr_loc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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) <>

Line 1340: nvl(hr_loc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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) <>

Line 1342: nvl(hr_loc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

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) <>

Line 1344: nvl(hr_loc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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) <>

Line 1346: nvl(hr_loc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

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) <>

Line 1348: nvl(hr_loc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

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) <>

Line 1350: nvl(hr_loc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

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) <>

Line 1352: nvl(hr_loc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

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) <>

Line 1354: nvl(hr_loc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

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) <>

Line 1356: nvl(hr_loc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

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) <>

Line 1358: nvl(hr_loc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

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) <>

Line 1360: nvl(hr_loc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

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) <>

Line 1362: nvl(hr_loc_shd.g_old_rec.attribute19, 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

Line 1364: nvl(hr_loc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

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

Line 1426: IF nvl(hr_loc_shd.g_old_rec.global_attribute_category, hr_api.g_varchar2) <>

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) <>

Line 1428: nvl(hr_loc_shd.g_old_rec.global_attribute1, hr_api.g_varchar2) <>

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) <>

Line 1430: nvl(hr_loc_shd.g_old_rec.global_attribute2, hr_api.g_varchar2) <>

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) <>

Line 1432: nvl(hr_loc_shd.g_old_rec.global_attribute3, hr_api.g_varchar2) <>

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) <>

Line 1434: nvl(hr_loc_shd.g_old_rec.global_attribute4, hr_api.g_varchar2) <>

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) <>

Line 1436: nvl(hr_loc_shd.g_old_rec.global_attribute5, hr_api.g_varchar2) <>

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) <>

Line 1438: nvl(hr_loc_shd.g_old_rec.global_attribute6, hr_api.g_varchar2) <>

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) <>

Line 1440: nvl(hr_loc_shd.g_old_rec.global_attribute7, hr_api.g_varchar2) <>

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) <>

Line 1442: nvl(hr_loc_shd.g_old_rec.global_attribute8, hr_api.g_varchar2) <>

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) <>

Line 1444: nvl(hr_loc_shd.g_old_rec.global_attribute9, hr_api.g_varchar2) <>

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) <>

Line 1446: nvl(hr_loc_shd.g_old_rec.global_attribute10, hr_api.g_varchar2) <>

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) <>

Line 1448: nvl(hr_loc_shd.g_old_rec.global_attribute11, hr_api.g_varchar2) <>

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) <>

Line 1450: nvl(hr_loc_shd.g_old_rec.global_attribute12, hr_api.g_varchar2) <>

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) <>

Line 1452: nvl(hr_loc_shd.g_old_rec.global_attribute13, hr_api.g_varchar2) <>

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) <>

Line 1454: nvl(hr_loc_shd.g_old_rec.global_attribute14, hr_api.g_varchar2) <>

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) <>

Line 1456: nvl(hr_loc_shd.g_old_rec.global_attribute15, hr_api.g_varchar2) <>

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) <>

Line 1458: nvl(hr_loc_shd.g_old_rec.global_attribute16, hr_api.g_varchar2) <>

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) <>

Line 1460: nvl(hr_loc_shd.g_old_rec.global_attribute17, hr_api.g_varchar2) <>

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) <>

Line 1462: nvl(hr_loc_shd.g_old_rec.global_attribute18, hr_api.g_varchar2) <>

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) <>

Line 1464: nvl(hr_loc_shd.g_old_rec.global_attribute19, 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

Line 1466: nvl(hr_loc_shd.g_old_rec.global_attribute20, hr_api.g_varchar2) <>

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

Line 1531: ( p_rec IN OUT NOCOPY hr_loc_shd.g_rec_type,

1527: -- ----------------------------------------------------------------------------
1528: -- |---------------------------< insert_validate >----------------------------|
1529: -- ----------------------------------------------------------------------------
1530: PROCEDURE insert_validate
1531: ( p_rec IN OUT NOCOPY hr_loc_shd.g_rec_type,
1532: p_effective_date IN DATE,
1533: p_operating_unit_id IN NUMBER)
1534: IS
1535: --

Line 1659: ( p_rec IN OUT NOCOPY hr_loc_shd.g_rec_type,

1655: -- ----------------------------------------------------------------------------
1656: -- |---------------------------< update_validate >----------------------------|
1657: -- ----------------------------------------------------------------------------
1658: PROCEDURE update_validate
1659: ( p_rec IN OUT NOCOPY hr_loc_shd.g_rec_type,
1660: p_effective_date IN DATE,
1661: p_operating_unit_id IN NUMBER)
1662: IS
1663: --

Line 1784: (p_rec IN hr_loc_shd.g_rec_type

1780: -- ----------------------------------------------------------------------------
1781: -- |---------------------------< delete_validate >----------------------------|
1782: -- ----------------------------------------------------------------------------
1783: PROCEDURE delete_validate
1784: (p_rec IN hr_loc_shd.g_rec_type
1785: ) IS
1786:
1787: --
1788: l_proc VARCHAR2(72) := g_package||'delete_validate';