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

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

Line 568: l_language_code hr_locations_all_tl.language%TYPE;

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

Line 647: from hr_locations_all loc

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

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

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

Line 1033: ,p_location_id IN hr_locations.location_id%TYPE

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

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

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

Line 1188: l_location_id hr_locations_all.location_id%TYPE;

1184: --
1185: -- Declare cursors and local variables
1186: --
1187: l_proc VARCHAR2(72) := g_package||'create_location_legal_adr';
1188: l_location_id hr_locations_all.location_id%TYPE;
1189: l_object_version_number hr_locations_all.object_version_number%TYPE;
1190: l_language_code hr_locations_all_tl.language%TYPE;
1191: l_inactive_date DATE;
1192: --

Line 1189: l_object_version_number hr_locations_all.object_version_number%TYPE;

1185: -- Declare cursors and local variables
1186: --
1187: l_proc VARCHAR2(72) := g_package||'create_location_legal_adr';
1188: l_location_id hr_locations_all.location_id%TYPE;
1189: l_object_version_number hr_locations_all.object_version_number%TYPE;
1190: l_language_code hr_locations_all_tl.language%TYPE;
1191: l_inactive_date DATE;
1192: --
1193: BEGIN

Line 1190: l_language_code hr_locations_all_tl.language%TYPE;

1186: --
1187: l_proc VARCHAR2(72) := g_package||'create_location_legal_adr';
1188: l_location_id hr_locations_all.location_id%TYPE;
1189: l_object_version_number hr_locations_all.object_version_number%TYPE;
1190: l_language_code hr_locations_all_tl.language%TYPE;
1191: l_inactive_date DATE;
1192: --
1193: BEGIN
1194: --

Line 1464: l_object_version_number hr_locations.object_version_number%TYPE;

1460: --
1461: -- Declare cursors and local variables
1462: --
1463: l_proc VARCHAR2(72) := g_package||'update_location_legal_adr';
1464: l_object_version_number hr_locations.object_version_number%TYPE;
1465: l_temp_ovn number(9) := p_object_version_number;
1466: --
1467: BEGIN
1468: --

Line 1691: l_object_version_number hr_locations_all.object_version_number%TYPE;

1687: --
1688: -- Declare cursors and local variables
1689: --
1690: l_proc VARCHAR2(72) := g_package||'disable_location_legal_adr';
1691: l_object_version_number hr_locations_all.object_version_number%TYPE;
1692: l_temp_ovn number := p_object_version_number;
1693: --
1694: BEGIN
1695: --

Line 1733: -- UPDATE ROW IN HR_LOCATIONS_ALL table

1729: -- End of API User Hook for the before hook of disable_location_legal_adr
1730: --
1731: END;
1732: --
1733: -- UPDATE ROW IN HR_LOCATIONS_ALL table
1734: --
1735: hr_location_internal.update_generic_location
1736: ( p_effective_date => p_effective_date
1737: ,p_location_id => p_location_id

Line 1821: l_object_version_number hr_locations_all.object_version_number%TYPE;

1817: --
1818: -- Declare cursors and local variables
1819: --
1820: l_proc VARCHAR2(72) := g_package||'enable_location_legal_adr';
1821: l_object_version_number hr_locations_all.object_version_number%TYPE;
1822: l_temp_ovn number := p_object_version_number;
1823: --
1824: BEGIN
1825: --

Line 1863: -- UPDATE ROW IN HR_LOCATIONS_ALL table

1859: -- End of API User Hook for the before hook of enable_location_legal_adr
1860: --
1861: END;
1862: --
1863: -- UPDATE ROW IN HR_LOCATIONS_ALL table
1864: --
1865: hr_location_internal.update_generic_location
1866: ( p_effective_date => p_effective_date
1867: ,p_location_id => p_location_id