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