APPS.HR_LOCATION_INTERNAL dependencies on HR_LOCATIONS_ALL_TL

Line 112: l_language_code hr_locations_all_tl.language%TYPE;

108: --
109: l_proc VARCHAR2(72) := g_package||'create_generic_location';
110: l_location_id hr_locations_all.location_id%TYPE;
111: l_object_version_number hr_locations_all.object_version_number%TYPE;
112: l_language_code hr_locations_all_tl.language%TYPE;
113: l_inactive_date DATE;
114: --
115: BEGIN
116: --

Line 227: -- Now insert translatable rows in HR_LOCATIONS_ALL_TL table

223: ,p_ece_tp_location_code => p_ece_tp_location_code
224: ,p_business_group_id => p_business_group_id
225: );
226: --
227: -- Now insert translatable rows in HR_LOCATIONS_ALL_TL table
228: hr_lot_ins.ins_tl
229: ( p_language_code => l_language_code,
230: p_location_id => l_location_id,
231: p_location_code => p_location_code,

Line 374: l_language_code hr_locations_all_tl.language%TYPE;

370: -- Declare cursors and local variables
371: --
372: l_proc VARCHAR2(72) := g_package||'update_generic_location';
373: l_object_version_number hr_locations.object_version_number%TYPE;
374: l_language_code hr_locations_all_tl.language%TYPE;
375: l_inactive_date DATE;
376: l_temp_ovn number := p_object_version_number;
377: --
378: BEGIN

Line 493: -- Now insert translatable rows in HR_LOCATIONS_ALL_TL table

489: ,p_global_attribute20 => p_global_attribute20
490: ,p_legal_address_flag => p_legal_address_flag
491: );
492: --
493: -- Now insert translatable rows in HR_LOCATIONS_ALL_TL table
494: hr_lot_upd.upd_tl
495: ( p_language_code => l_language_code,
496: p_location_id => p_location_id,
497: p_location_code => p_location_code,