APPS.HR_LOC_SHD dependencies on HR_LOCATIONS_ALL

Line 175: FROM hr_locations_all

171: ece_tp_location_code,
172: object_version_number,
173: business_group_id,
174: geometry
175: FROM hr_locations_all
176: WHERE location_id = p_location_id;
177: --
178: l_proc VARCHAR2(72) := g_package||'api_updating';
179: l_fct_ret BOOLEAN;

Line 221: hr_utility.set_message_token('TABLE_NAME', 'HR_LOCATIONS_ALL');

217: END IF;
218: CLOSE csr_select_row;
219: IF (p_object_version_number <> g_old_rec.object_version_number) THEN
220: hr_utility.set_message(800, 'HR_7155_OBJECT_INVALID');
221: hr_utility.set_message_token('TABLE_NAME', 'HR_LOCATIONS_ALL');
222: hr_utility.raise_error;
223: END IF;
224: hr_utility.set_location(l_proc, 15);
225: l_fct_ret := true;

Line 331: FROM hr_locations_all

327: ece_tp_location_code,
328: object_version_number,
329: business_group_id,
330: geometry
331: FROM hr_locations_all
332: WHERE location_id = p_location_id
333: FOR UPDATE nowait;
334: --
335: l_proc VARCHAR2(72) := g_package||'lck';

Line 394: hr_utility.set_message_token('TABLE_NAME', 'hr_locations_all');

390: -- The object is locked therefore we need to supply a meaningful
391: -- error message.
392: --
393: hr_utility.set_message(800, 'HR_7165_OBJECT_LOCKED');
394: hr_utility.set_message_token('TABLE_NAME', 'hr_locations_all');
395: hr_utility.raise_error;
396: END lck;
397: --
398: -- ----------------------------------------------------------------------------