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

Line 109: l_location_id hr_locations_all.location_id%TYPE;

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

Line 110: l_object_version_number hr_locations_all.object_version_number%TYPE;

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

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

235: --
236: END;
237: -- Process Logic
238: --
239: -- Insert non-translatable rows into HR_LOCATIONS_ALL first
240:
241: hr_utility.set_location(l_proc, 25);
242:
243: hr_location_internal.create_generic_location

Line 568: l_object_version_number hr_locations.object_version_number%TYPE;

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

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 649: from hr_locations_all loc

645: ,l_region_2
646: ,l_region_3
647: ,l_style
648: ,l_town_or_city
649: from hr_locations_all loc
650: where loc.location_id = p_location_id;
651: -- fix 3219077 end
652:
653: hr_utility.set_location(l_proc, 25);

Line 796: -- Insert non-translatable rows in HR_LOCATIONS_ALL Table

792: -- End of API User Hook for the before hook of update_location
793: --
794: END;
795: --
796: -- Insert non-translatable rows in HR_LOCATIONS_ALL Table
797: --
798: hr_location_internal.update_generic_location
799: ( p_effective_date => p_effective_date
800: ,p_language_code => l_language_code -- Added for bug 3368450.

Line 1036: ,p_location_id IN hr_locations.location_id%TYPE

1032: -- ----------------------------------------------------------------------------
1033: --
1034: PROCEDURE delete_location
1035: ( p_validate IN BOOLEAN DEFAULT false
1036: ,p_location_id IN hr_locations.location_id%TYPE
1037: ,p_object_version_number IN hr_locations.object_version_number%TYPE )
1038:
1039: IS
1040: --

Line 1037: ,p_object_version_number IN hr_locations.object_version_number%TYPE )

1033: --
1034: PROCEDURE delete_location
1035: ( p_validate IN BOOLEAN DEFAULT false
1036: ,p_location_id IN hr_locations.location_id%TYPE
1037: ,p_object_version_number IN hr_locations.object_version_number%TYPE )
1038:
1039: IS
1040: --
1041: --

Line 1204: l_location_id hr_locations_all.location_id%TYPE;

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

Line 1205: l_object_version_number hr_locations_all.object_version_number%TYPE;

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

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

Line 1532: l_object_version_number hr_locations.object_version_number%TYPE;

1528: --
1529: -- Declare cursors and local variables
1530: --
1531: l_proc VARCHAR2(72) := g_package||'update_location_legal_adr';
1532: l_object_version_number hr_locations.object_version_number%TYPE;
1533: l_temp_ovn number(9) := p_object_version_number;
1534: --
1535: BEGIN
1536: --

Line 1798: l_object_version_number hr_locations_all.object_version_number%TYPE;

1794: --
1795: -- Declare cursors and local variables
1796: --
1797: l_proc VARCHAR2(72) := g_package||'disable_location_legal_adr';
1798: l_object_version_number hr_locations_all.object_version_number%TYPE;
1799: l_temp_ovn number := p_object_version_number;
1800: --
1801: BEGIN
1802: --

Line 1840: -- UPDATE ROW IN HR_LOCATIONS_ALL table

1836: -- End of API User Hook for the before hook of disable_location_legal_adr
1837: --
1838: END;
1839: --
1840: -- UPDATE ROW IN HR_LOCATIONS_ALL table
1841: --
1842: hr_location_internal.update_generic_location
1843: ( p_effective_date => p_effective_date
1844: ,p_location_id => p_location_id

Line 1928: l_object_version_number hr_locations_all.object_version_number%TYPE;

1924: --
1925: -- Declare cursors and local variables
1926: --
1927: l_proc VARCHAR2(72) := g_package||'enable_location_legal_adr';
1928: l_object_version_number hr_locations_all.object_version_number%TYPE;
1929: l_temp_ovn number := p_object_version_number;
1930: --
1931: BEGIN
1932: --

Line 1970: -- UPDATE ROW IN HR_LOCATIONS_ALL table

1966: -- End of API User Hook for the before hook of enable_location_legal_adr
1967: --
1968: END;
1969: --
1970: -- UPDATE ROW IN HR_LOCATIONS_ALL table
1971: --
1972: hr_location_internal.update_generic_location
1973: ( p_effective_date => p_effective_date
1974: ,p_location_id => p_location_id