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 668: IF ( p_tax_name <> nvl (hr_loc_shd.g_old_rec.tax_name, hr_api.g_varchar2) )

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

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

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

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

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

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

1106: --
1107: -- {End Of Comments}
1108: -- ---------------------------------------------------------------------------
1109: --
1110: PROCEDURE chk_non_updateable_args(p_rec IN hr_loc_shd.g_rec_type) IS
1111: --
1112: l_proc VARCHAR2(72) := g_package||'chk_non_updateable_args';
1113: l_error EXCEPTION;
1114: l_argument VARCHAR2(30);

Line 1122: IF NOT hr_loc_shd.api_updating

1118: --
1119: -- Only proceed with validation if a row exists for
1120: -- the current record in the HR Schema
1121: --
1122: IF NOT hr_loc_shd.api_updating
1123: (p_location_id => p_rec.location_id,
1124: p_object_version_number => p_rec.object_version_number)
1125: THEN
1126: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');

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

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

Line 1178: (p_rec IN hr_loc_shd.g_rec_type) IS

1174: -- Internal Row Handler Use Only.
1175: --
1176: -- ---------------------------------------------------------------------------
1177: PROCEDURE chk_df
1178: (p_rec IN hr_loc_shd.g_rec_type) IS
1179: --
1180: l_proc VARCHAR2(72) := g_package||'chk_df';
1181: --
1182: BEGIN

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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)

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

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:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1493: -- ----------------------------------------------------------------------------
1494: -- |---------------------------< insert_validate >----------------------------|
1495: -- ----------------------------------------------------------------------------
1496: PROCEDURE insert_validate
1497: ( p_rec IN OUT NOCOPY hr_loc_shd.g_rec_type,
1498: p_effective_date IN DATE,
1499: p_operating_unit_id IN NUMBER)
1500: IS
1501: --

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

1621: -- ----------------------------------------------------------------------------
1622: -- |---------------------------< update_validate >----------------------------|
1623: -- ----------------------------------------------------------------------------
1624: PROCEDURE update_validate
1625: ( p_rec IN OUT NOCOPY hr_loc_shd.g_rec_type,
1626: p_effective_date IN DATE,
1627: p_operating_unit_id IN NUMBER)
1628: IS
1629: --

Line 1750: (p_rec IN hr_loc_shd.g_rec_type

1746: -- ----------------------------------------------------------------------------
1747: -- |---------------------------< delete_validate >----------------------------|
1748: -- ----------------------------------------------------------------------------
1749: PROCEDURE delete_validate
1750: (p_rec IN hr_loc_shd.g_rec_type
1751: ) IS
1752:
1753: --
1754: l_proc VARCHAR2(72) := g_package||'delete_validate';