APPS.HR_LOT_SHD dependencies on HR_LOCATIONS_ALL

Line 50: from hr_locations_all_tl

46: language,
47: source_lang,
48: location_code,
49: description
50: from hr_locations_all_tl
51: where location_id = p_location_id
52: and language = p_language;
53: --
54: l_proc varchar2(72) := g_package||'api_updating';

Line 122: from hr_locations_all_tl

118: language,
119: source_lang,
120: location_code,
121: description
122: from hr_locations_all_tl
123: where location_id = p_location_id
124: and language = p_language
125: for update nowait;
126: --

Line 174: hr_utility.set_message_token('TABLE_NAME', 'hr_locations_all_tl');

170: -- The object is locked therefore we need to supply a meaningful
171: -- error message.
172: --
173: hr_utility.set_message(800, 'HR_7165_OBJECT_LOCKED');
174: hr_utility.set_message_token('TABLE_NAME', 'hr_locations_all_tl');
175: hr_utility.raise_error;
176: End lck;
177: --
178: -- ----------------------------------------------------------------------------

Line 185: delete from hr_locations_all_tl t

181: Procedure add_language Is
182: --
183: l_proc varchar2(72) := g_package||'add_language';
184: begin
185: delete from hr_locations_all_tl t
186: where not exists
187: ( select null
188: from hr_locations_all b
189: where b.location_id = t.location_id

Line 188: from hr_locations_all b

184: begin
185: delete from hr_locations_all_tl t
186: where not exists
187: ( select null
188: from hr_locations_all b
189: where b.location_id = t.location_id
190: );
191:
192: update hr_locations_all_tl t

Line 192: update hr_locations_all_tl t

188: from hr_locations_all b
189: where b.location_id = t.location_id
190: );
191:
192: update hr_locations_all_tl t
193: set ( location_code,
194: description ) =
195: ( select b.location_code,
196: b.description

Line 197: from hr_locations_all_tl b

193: set ( location_code,
194: description ) =
195: ( select b.location_code,
196: b.description
197: from hr_locations_all_tl b
198: where b.location_id = t.location_id
199: and b.language = t.source_lang )
200: where ( t.location_id,
201: t.language

Line 205: from hr_locations_all_tl subb, hr_locations_all_tl subt

201: t.language
202: ) in
203: ( select subt.location_id,
204: subt.language
205: from hr_locations_all_tl subb, hr_locations_all_tl subt
206: where subb.location_id = subt.location_id
207: and subb.language = subt.source_lang
208: and ( subb.location_code <> subt.location_code
209: or subb.description <> subt.description

Line 215: insert into hr_locations_all_tl

211: or (subb.description is not null and subt.description is null)
212: )
213: );
214:
215: insert into hr_locations_all_tl
216: (
217: location_id,
218: location_code,
219: description,

Line 238: from hr_locations_all_tl b, fnd_languages l

234: b.created_by,
235: b.creation_date,
236: l.language_code,
237: b.source_lang
238: from hr_locations_all_tl b, fnd_languages l
239: where l.installed_flag in ('I', 'B')
240: and b.language = userenv('LANG')
241: and not exists
242: (select null

Line 243: from hr_locations_all_tl t

239: where l.installed_flag in ('I', 'B')
240: and b.language = userenv('LANG')
241: and not exists
242: (select null
243: from hr_locations_all_tl t
244: where t.location_id = b.location_id
245: and t.language = l.language_code);
246: -- Begin Bug: 2148847, Removed set_location to fix VALUE ERROR, this unknown
247: -- error is coming while running PERNLINS.sql script.

Line 299: from hr_locations_all

295: -- Cursor to obtain underlying business group id.
296: --
297: cursor csr_bg_id is
298: select business_group_id
299: from hr_locations_all
300: where location_id = p_location_id;
301: --
302: l_proc varchar2(72) := g_package||'return_value_business_group_id';
303: --