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_ORGANIZATION_API dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 178: -- HR_ALL_ORGANIZATION_UNITS_TL table.

174: -- business group.
175: --
176: -- Organizations are stored on the HR_ALL_ORGANIZATION_UNITS table.
177: -- The translated columns are stored on the
178: -- HR_ALL_ORGANIZATION_UNITS_TL table.
179: --
180: -- Prerequisites:
181: -- None
182: --

Line 298: l_language_code hr_all_organization_units_tl.language%type;

294: --
295: l_proc varchar2(72) := g_package||'create_organization_internal';
296: l_organization_id hr_all_organization_units.organization_id%type;
297: l_object_version_number hr_all_organization_units.object_version_number%type;
298: l_language_code hr_all_organization_units_tl.language%type;
299: l_security_profile_id per_security_profiles.security_profile_id%type;
300: l_view_all_orgs per_security_profiles.view_all_organizations_flag%type;
301: --
302: BEGIN

Line 367: -- Now insert translatable rows in HR_ALL_ORGANIZATION_UNITS_TL table

363: ,p_organization_id => l_organization_id
364: ,p_object_version_number => l_object_version_number
365: ,p_duplicate_org_warning => p_duplicate_org_warning);
366: --
367: -- Now insert translatable rows in HR_ALL_ORGANIZATION_UNITS_TL table
368: --
369: hr_ort_ins.ins_tl
370: ( p_language_code => l_language_code,
371: p_organization_id => l_organization_id,

Line 1499: l_language_code hr_all_organization_units_tl.language%TYPE;

1495: -- Declare cursors and local variables
1496: --
1497: l_proc VARCHAR2(72) := g_package||'update_organization';
1498: l_object_version_number hr_all_organization_units.object_version_number%TYPE;
1499: l_language_code hr_all_organization_units_tl.language%TYPE;
1500: l_date_from DATE;
1501: l_date_to DATE;
1502: l_duplicate_org_warning boolean;
1503: l_temp_ovn number := p_object_version_number;

Line 4304: l_language_code hr_all_organization_units_tl.language%TYPE;

4300: --
4301: l_proc VARCHAR2(72) := g_package||'create_business_group';
4302: l_organization_id hr_all_organization_units.organization_id%TYPE;
4303: l_object_version_number hr_all_organization_units.object_version_number%TYPE;
4304: l_language_code hr_all_organization_units_tl.language%TYPE;
4305: l_org_information_id hr_organization_information.org_information_id%TYPE;
4306: l_date_from DATE;
4307: l_ovn_bg hr_all_organization_units.object_version_number%TYPE;
4308: --

Line 4618: l_language_code hr_all_organization_units_tl.language%TYPE;

4614: --
4615: l_proc VARCHAR2(72) := g_package||'create_operating_unit';
4616: l_organization_id hr_all_organization_units.organization_id%TYPE;
4617: l_object_version_number hr_all_organization_units.object_version_number%TYPE;
4618: l_language_code hr_all_organization_units_tl.language%TYPE;
4619: l_org_information_id hr_organization_information.org_information_id%TYPE;
4620: l_date_from DATE;
4621: --
4622: BEGIN

Line 4959: l_language_code hr_all_organization_units_tl.language%TYPE;

4955: --
4956: l_proc VARCHAR2(72) := g_package||'create_legal_entity';
4957: l_organization_id hr_all_organization_units.organization_id%TYPE;
4958: l_object_version_number hr_all_organization_units.object_version_number%TYPE;
4959: l_language_code hr_all_organization_units_tl.language%TYPE;
4960: l_org_information_id hr_organization_information.org_information_id%TYPE;
4961: l_date_from DATE;
4962: --
4963: BEGIN

Line 5524: l_language_code hr_all_organization_units_tl.language%TYPE;

5520: -- Declare cursors and local variables
5521: --
5522: l_proc VARCHAR2(72) := g_package||'trans_org_name';
5523: l_organization_id hr_all_organization_units.organization_id%TYPE;
5524: l_language_code hr_all_organization_units_tl.language%TYPE;
5525: --
5526: BEGIN
5527: --
5528: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 5813: l_language_code hr_all_organization_units_tl.language%TYPE;

5809: --
5810: l_proc VARCHAR2(72) := g_package||'create_not_usable_ou_internal';
5811: l_organization_id hr_all_organization_units.organization_id%TYPE;
5812: l_object_version_number hr_all_organization_units.object_version_number%TYPE;
5813: l_language_code hr_all_organization_units_tl.language%TYPE;
5814: l_org_information_id hr_organization_information.org_information_id%TYPE;
5815: l_date_from DATE;
5816: --
5817: BEGIN