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.PAY_CA_CITY_UPD dependencies on HR_LOCATIONS_ALL

Line 241: hr_utility.trace('Starting bulk update on hr_locations_all ');

237: AND style = 'CA';
238:
239: COMMIT;
240:
241: hr_utility.trace('Starting bulk update on hr_locations_all ');
242:
243: FORALL j IN v_old_city.first..v_old_city.last
244: UPDATE hr_locations_all
245: SET town_or_city = substrb(v_new_city(j),1,30),

Line 244: UPDATE hr_locations_all

240:
241: hr_utility.trace('Starting bulk update on hr_locations_all ');
242:
243: FORALL j IN v_old_city.first..v_old_city.last
244: UPDATE hr_locations_all
245: SET town_or_city = substrb(v_new_city(j),1,30),
246: derived_locale = decode(derived_locale, NULL, NULL,
247: get_derived_locale(v_new_city(j),country))
248: WHERE region_1 = v_prov(j)

Line 270: hr_utility.trace('Completed update on per_addresses,hr_locations_all and pay_us_city_names');

266: END IF;
267:
268: END LOOP;
269:
270: hr_utility.trace('Completed update on per_addresses,hr_locations_all and pay_us_city_names');
271:
272: CLOSE city_mappings;
273:
274: EXCEPTION