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_LOCATION_INTERNAL dependencies on HR_LOCATIONS

Line 110: l_location_id hr_locations_all.location_id%TYPE;

106: --
107: -- Declare cursors and local variables
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: --

Line 111: l_object_version_number hr_locations_all.object_version_number%TYPE;

107: -- Declare cursors and local variables
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

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 139: -- Insert non-translatable rows into HR_LOCATIONS_ALL first

135: hr_api.validate_language_code(p_language_code => l_language_code);
136: --
137: hr_utility.set_location(l_proc, 20);
138: --
139: -- Insert non-translatable rows into HR_LOCATIONS_ALL first
140: hr_loc_ins.ins
141: ( p_effective_date => p_effective_date
142: ,p_location_id => l_location_id
143: ,p_object_version_number => l_object_version_number

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 373: l_object_version_number hr_locations.object_version_number%TYPE;

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

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 405: -- Insert non-translatable rows in HR_LOCATIONS_ALL Table

401: -- Process Logic
402: --
403: l_object_version_number := p_object_version_number;
404: --
405: -- Insert non-translatable rows in HR_LOCATIONS_ALL Table
406: --
407: hr_loc_upd.upd
408: ( p_effective_date => p_effective_date
409: ,p_location_id => p_location_id

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,