DBA Data[Home] [Help]

APPS.HR_LOCATION_API dependencies on HR_LOCATIONS_ALL_TL

Line 111: l_language_code hr_locations_all_tl.language%TYPE;

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

Line 569: l_language_code hr_locations_all_tl.language%TYPE;

565: -- Declare cursors and local variables
566: --
567: l_proc VARCHAR2(72) := g_package||'update_location';
568: l_object_version_number hr_locations.object_version_number%TYPE;
569: l_language_code hr_locations_all_tl.language%TYPE;
570: l_inactive_date DATE;
571:
572: l_temp_ovn number := p_object_version_number;
573: --

Line 1206: l_language_code hr_locations_all_tl.language%TYPE;

1202: --
1203: l_proc VARCHAR2(72) := g_package||'create_location_legal_adr';
1204: l_location_id hr_locations_all.location_id%TYPE;
1205: l_object_version_number hr_locations_all.object_version_number%TYPE;
1206: l_language_code hr_locations_all_tl.language%TYPE;
1207: l_inactive_date DATE;
1208: --
1209: BEGIN
1210: --