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

Line 176: -- Organizations are stored on the HR_ALL_ORGANIZATION_UNITS table.

172: --
173: -- This procedure creates a new organization within a scope of existing
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:

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 296: l_organization_id hr_all_organization_units.organization_id%type;

292: from per_security_profiles
293: where security_profile_id = p_security_profile_id;
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;

Line 297: l_object_version_number hr_all_organization_units.object_version_number%type;

293: where security_profile_id = p_security_profile_id;
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: --

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 317: -- Insert non-translatable rows into HR_ALL_ORGANIZATION_UNITS first

313: hr_utility.set_location(l_proc, 20);
314: --
315: -- Process Logic
316: --
317: -- Insert non-translatable rows into HR_ALL_ORGANIZATION_UNITS first
318: hr_oru_ins.ins
319: ( p_effective_date => p_effective_date
320: ,p_business_group_id => p_business_group_id
321: ,p_date_from => p_date_from

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 461: l_cost_alloc_key_id hr_all_organization_units.cost_allocation_keyflex_id%Type;

457: -- Declare local variables
458: --
459: l_flex_num fnd_id_flex_segments.id_flex_num%Type;
460: l_cost_name pay_cost_allocation_keyflex.concatenated_segments%Type;
461: l_cost_alloc_key_id hr_all_organization_units.cost_allocation_keyflex_id%Type;
462: l_date_from date;
463: l_effective_date date;
464: --
465: l_proc varchar2(72) := g_package||'CREATE_HR_ORGANIZATION';

Line 1498: l_object_version_number hr_all_organization_units.object_version_number%TYPE;

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

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 1511: l_cost_alloc_key_id hr_all_organization_units.cost_allocation_keyflex_id%Type

1507: --
1508: l_cost_null_ind number(1) := 0;
1509: l_api_updating boolean;
1510: l_flex_num fnd_id_flex_segments.id_flex_num%Type;
1511: l_cost_alloc_key_id hr_all_organization_units.cost_allocation_keyflex_id%Type
1512: := p_cost_allocation_keyflex_id;
1513: l_cost_name pay_cost_allocation_keyflex.concatenated_segments%Type;
1514: l_old_cost_name pay_cost_allocation_keyflex.concatenated_segments%Type;
1515: l_business_group_id per_all_assignments_f.business_group_id%Type;

Line 1900: -- Update non-translatable rows in HR_ALL_ORGANIZATION_UNITS Table

1896: end if;
1897: --
1898:
1899: --
1900: -- Update non-translatable rows in HR_ALL_ORGANIZATION_UNITS Table
1901: --
1902: hr_oru_upd.upd
1903: ( p_effective_date => p_effective_date
1904: ,p_name => p_name

Line 2106: ,p_organization_id IN hr_all_organization_units.organization_id%TYPE

2102: -- ----------------------------------------------------------------------------
2103: --
2104: PROCEDURE delete_organization
2105: ( p_validate IN BOOLEAN
2106: ,p_organization_id IN hr_all_organization_units.organization_id%TYPE
2107: ,p_object_version_number IN hr_all_organization_units.object_version_number%TYPE )
2108:
2109: IS
2110: --

Line 2107: ,p_object_version_number IN hr_all_organization_units.object_version_number%TYPE )

2103: --
2104: PROCEDURE delete_organization
2105: ( p_validate IN BOOLEAN
2106: ,p_organization_id IN hr_all_organization_units.organization_id%TYPE
2107: ,p_object_version_number IN hr_all_organization_units.object_version_number%TYPE )
2108:
2109: IS
2110: --
2111: --

Line 2261: hr_all_organization_units hou

2257: --
2258: cursor csr_get_leg_code is
2259: select legislation_code
2260: from per_business_groups pbg,
2261: hr_all_organization_units hou
2262: where hou.organization_id = p_organization_id
2263: and pbg.business_group_id = hou.business_group_id;
2264:
2265: l_proc VARCHAR2(72) := g_package||'chk_cls_mand';

Line 3076: from hr_all_organization_units

3072: l_warning boolean;
3073: --
3074: cursor c1 is
3075: select business_group_id
3076: from hr_all_organization_units
3077: where organization_id = p_organization_id;
3078: --
3079: l_business_group_id number;
3080: --

Line 3737: from hr_all_organization_units

3733: l_temp_ovn number := p_object_version_number;
3734: --
3735: cursor c1 is
3736: select business_group_id
3737: from hr_all_organization_units
3738: where organization_id = p_organization_id;
3739: --
3740: l_business_group_id number;
3741: --

Line 4248: l_organization_id hr_all_organization_units.organization_id%TYPE;

4244: --
4245: -- Declare cursors and local variables
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;

Line 4249: l_object_version_number hr_all_organization_units.object_version_number%TYPE;

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

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 4253: l_ovn_bg hr_all_organization_units.object_version_number%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: --
4255: BEGIN
4256: --
4257: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 4339: update hr_all_organization_units

4335: ,p_object_version_number => l_object_version_number);
4336: --
4337: hr_utility.set_location(l_proc, 60);
4338: --
4339: update hr_all_organization_units
4340: set business_group_id = l_organization_id
4341: where organization_id = l_organization_id;
4342: --
4343: hr_utility.set_location(l_proc, 70);

Line 4562: l_organization_id hr_all_organization_units.organization_id%TYPE;

4558: --
4559: -- Declare cursors and local variables
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;

Line 4563: l_object_version_number hr_all_organization_units.object_version_number%TYPE;

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

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 4745: l_organization_id hr_all_organization_units.organization_id%TYPE;

4741: l_update_prim_ledger_warning boolean;
4742: l_org_information_id hr_organization_information.org_information_id%TYPE;
4743: l_new_org_information_id hr_organization_information.org_information_id%TYPE;
4744: l_new_ovn hr_organization_information.object_version_number%type;
4745: l_organization_id hr_all_organization_units.organization_id%TYPE;
4746: l_duplicate_org_warning boolean;
4747:
4748:
4749: cursor csr_check_update (p_organization_id number)

Line 4903: l_organization_id hr_all_organization_units.organization_id%TYPE;

4899: --
4900: -- Declare cursors and local variables
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;

Line 4904: l_object_version_number hr_all_organization_units.object_version_number%TYPE;

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

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 5055: ( p_bgr_id IN hr_all_organization_units.business_group_id%TYPE)

5051: --
5052: -- {End Of Comments}
5053: --
5054: PROCEDURE chk_bgr_id
5055: ( p_bgr_id IN hr_all_organization_units.business_group_id%TYPE)
5056: IS
5057: l_proc VARCHAR2(72) := g_package||'chk_bgr_id';
5058: l_exists VARCHAR2(1) := 'N';
5059: --

Line 5107: l_organization_id hr_all_organization_units.organization_id%TYPE;

5103: --
5104: -- Declare cursors and local variables
5105: --
5106: l_proc VARCHAR2(72) := g_package||'create_bgr_classif';
5107: l_organization_id hr_all_organization_units.organization_id%TYPE;
5108: l_object_version_number hr_all_organization_units.object_version_number%TYPE;
5109: l_org_information_id hr_organization_information.org_information_id%TYPE;
5110: --
5111: BEGIN

Line 5108: l_object_version_number hr_all_organization_units.object_version_number%TYPE;

5104: -- Declare cursors and local variables
5105: --
5106: l_proc VARCHAR2(72) := g_package||'create_bgr_classif';
5107: l_organization_id hr_all_organization_units.organization_id%TYPE;
5108: l_object_version_number hr_all_organization_units.object_version_number%TYPE;
5109: l_org_information_id hr_organization_information.org_information_id%TYPE;
5110: --
5111: BEGIN
5112: --

Line 5206: -- HR_ALL_ORGANIZATION_UNITS table and valid.

5202: -- ----------------------------------------------------------------------------
5203: --
5204: -- Description:
5205: -- Validates that organization_id of organization unit is present in
5206: -- HR_ALL_ORGANIZATION_UNITS table and valid.
5207: --
5208: -- Pre-conditions:
5209: -- None.
5210: --

Line 5250: FROM hr_all_organization_units

5246: INTO l_exists
5247: FROM sys.dual
5248: WHERE EXISTS
5249: (SELECT null
5250: FROM hr_all_organization_units
5251: WHERE organization_id = p_organization_id);
5252: EXCEPTION
5253: WHEN NO_DATA_FOUND THEN NULL;
5254: END;

Line 5284: l_organization_id hr_all_organization_units.organization_id%TYPE;

5280: --
5281: -- Declare cursors and local variables
5282: --
5283: l_proc VARCHAR2(72) := g_package||'create_legal_entity_classif';
5284: l_organization_id hr_all_organization_units.organization_id%TYPE;
5285: l_object_version_number hr_all_organization_units.object_version_number%TYPE;
5286: l_org_information_id hr_organization_information.org_information_id%TYPE;
5287: --
5288: BEGIN

Line 5285: l_object_version_number hr_all_organization_units.object_version_number%TYPE;

5281: -- Declare cursors and local variables
5282: --
5283: l_proc VARCHAR2(72) := g_package||'create_legal_entity_classif';
5284: l_organization_id hr_all_organization_units.organization_id%TYPE;
5285: l_object_version_number hr_all_organization_units.object_version_number%TYPE;
5286: l_org_information_id hr_organization_information.org_information_id%TYPE;
5287: --
5288: BEGIN
5289: --

Line 5375: l_organization_id hr_all_organization_units.organization_id%TYPE;

5371: --
5372: -- Declare cursors and local variables
5373: --
5374: l_proc VARCHAR2(72) := g_package||'create_oper_unit_classif';
5375: l_organization_id hr_all_organization_units.organization_id%TYPE;
5376: l_object_version_number hr_all_organization_units.object_version_number%TYPE;
5377: l_org_information_id hr_organization_information.org_information_id%TYPE;
5378: --
5379: BEGIN

Line 5376: l_object_version_number hr_all_organization_units.object_version_number%TYPE;

5372: -- Declare cursors and local variables
5373: --
5374: l_proc VARCHAR2(72) := g_package||'create_oper_unit_classif';
5375: l_organization_id hr_all_organization_units.organization_id%TYPE;
5376: l_object_version_number hr_all_organization_units.object_version_number%TYPE;
5377: l_org_information_id hr_organization_information.org_information_id%TYPE;
5378: --
5379: BEGIN
5380: --

Line 5469: l_organization_id hr_all_organization_units.organization_id%TYPE;

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

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 5757: l_organization_id hr_all_organization_units.organization_id%TYPE;

5753: --
5754: -- Declare cursors and local variables
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;

Line 5758: l_object_version_number hr_all_organization_units.object_version_number%TYPE;

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

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