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 4250: l_language_code hr_all_organization_units_tl.language%TYPE;

4246: --
4247: l_proc VARCHAR2(72) := g_package||'create_business_group';
4248: l_organization_id hr_all_organization_units.organization_id%TYPE;
4249: l_object_version_number hr_all_organization_units.object_version_number%TYPE;
4250: l_language_code hr_all_organization_units_tl.language%TYPE;
4251: l_org_information_id hr_organization_information.org_information_id%TYPE;
4252: l_date_from DATE;
4253: l_ovn_bg hr_all_organization_units.object_version_number%TYPE;
4254: --

Line 4564: l_language_code hr_all_organization_units_tl.language%TYPE;

4560: --
4561: l_proc VARCHAR2(72) := g_package||'create_operating_unit';
4562: l_organization_id hr_all_organization_units.organization_id%TYPE;
4563: l_object_version_number hr_all_organization_units.object_version_number%TYPE;
4564: l_language_code hr_all_organization_units_tl.language%TYPE;
4565: l_org_information_id hr_organization_information.org_information_id%TYPE;
4566: l_date_from DATE;
4567: --
4568: BEGIN

Line 4905: l_language_code hr_all_organization_units_tl.language%TYPE;

4901: --
4902: l_proc VARCHAR2(72) := g_package||'create_legal_entity';
4903: l_organization_id hr_all_organization_units.organization_id%TYPE;
4904: l_object_version_number hr_all_organization_units.object_version_number%TYPE;
4905: l_language_code hr_all_organization_units_tl.language%TYPE;
4906: l_org_information_id hr_organization_information.org_information_id%TYPE;
4907: l_date_from DATE;
4908: --
4909: BEGIN

Line 5470: l_language_code hr_all_organization_units_tl.language%TYPE;

5466: -- Declare cursors and local variables
5467: --
5468: l_proc VARCHAR2(72) := g_package||'trans_org_name';
5469: l_organization_id hr_all_organization_units.organization_id%TYPE;
5470: l_language_code hr_all_organization_units_tl.language%TYPE;
5471: --
5472: BEGIN
5473: --
5474: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 5759: l_language_code hr_all_organization_units_tl.language%TYPE;

5755: --
5756: l_proc VARCHAR2(72) := g_package||'create_not_usable_ou_internal';
5757: l_organization_id hr_all_organization_units.organization_id%TYPE;
5758: l_object_version_number hr_all_organization_units.object_version_number%TYPE;
5759: l_language_code hr_all_organization_units_tl.language%TYPE;
5760: l_org_information_id hr_organization_information.org_information_id%TYPE;
5761: l_date_from DATE;
5762: --
5763: BEGIN