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_ORGANIZATION_INFORMATION

Line 2253: (p_org_classif_code IN hr_organization_information.org_information1%TYPE,

2249: --
2250: -- {End Of Comments}
2251: --
2252: PROCEDURE chk_cls_mand
2253: (p_org_classif_code IN hr_organization_information.org_information1%TYPE,
2254: p_parent_call IN VARCHAR2,
2255: p_organization_id IN NUMBER)
2256: IS
2257: --

Line 2340: l_org_information_id hr_organization_information.org_information_id%TYPE;

2336: --
2337:
2338: --
2339: l_proc VARCHAR2(72) := g_package||'create_org_classification';
2340: l_org_information_id hr_organization_information.org_information_id%TYPE;
2341: l_object_version_number hr_organization_information.object_version_number%TYPE;
2342: --
2343: BEGIN
2344: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 2341: l_object_version_number hr_organization_information.object_version_number%TYPE;

2337:
2338: --
2339: l_proc VARCHAR2(72) := g_package||'create_org_classification';
2340: l_org_information_id hr_organization_information.org_information_id%TYPE;
2341: l_object_version_number hr_organization_information.object_version_number%TYPE;
2342: --
2343: BEGIN
2344: hr_utility.set_location('Entering:'|| l_proc, 10);
2345: --

Line 2486: (p_org_information_id IN hr_organization_information.org_information_id%TYPE)

2482: --
2483: -- {End Of Comments}
2484: --
2485: PROCEDURE chk_cls_row
2486: (p_org_information_id IN hr_organization_information.org_information_id%TYPE)
2487: IS
2488: l_proc VARCHAR2(72) := g_package||'chk_cls_row';
2489: l_context VARCHAR2(40);
2490: --

Line 2501: FROM hr_organization_information

2497: --
2498: BEGIN
2499: SELECT org_information_context
2500: INTO l_context
2501: FROM hr_organization_information
2502: WHERE org_information_id = p_org_information_id;
2503: EXCEPTION
2504: WHEN NO_DATA_FOUND THEN null;
2505: END;

Line 2536: l_object_version_number hr_organization_information.object_version_number%TYPE;

2532: --
2533: -- Declare cursors and local variables
2534: --
2535: l_proc VARCHAR2(72) := g_package||'enable_org_classification';
2536: l_object_version_number hr_organization_information.object_version_number%TYPE;
2537: l_temp_ovn number := p_object_version_number;
2538: --
2539: BEGIN
2540: --

Line 2559: -- Update row in HR_ORGANIZATION_INFORMATION Table

2555: --
2556: l_object_version_number := p_object_version_number;
2557: --
2558: --
2559: -- Update row in HR_ORGANIZATION_INFORMATION Table
2560: --
2561: hr_ori_upd.upd
2562: ( p_effective_date => p_effective_date
2563: ,p_org_information_id => p_org_information_id

Line 2630: l_object_version_number hr_organization_information.object_version_number%TYPE;

2626: --
2627: -- Declare cursors and local variables
2628: --
2629: l_proc VARCHAR2(72) := g_package||'disable_org_classification';
2630: l_object_version_number hr_organization_information.object_version_number%TYPE;
2631: l_temp_ovn number := p_object_version_number;
2632: --
2633: BEGIN
2634: --

Line 2653: -- Update row in HR_ORGANIZATION_INFORMATION Table

2649: --
2650: l_object_version_number := p_object_version_number;
2651: --
2652: --
2653: -- Update row in HR_ORGANIZATION_INFORMATION Table
2654: --
2655: hr_ori_upd.upd
2656: ( p_effective_date => p_effective_date
2657: ,p_org_information_id => p_org_information_id

Line 2766: l_org_information_id hr_organization_information.org_information_id%TYPE;

2762: --
2763: -- Declare cursors and local variables
2764: --
2765: l_proc VARCHAR2(72) := g_package||'create_org_information';
2766: l_org_information_id hr_organization_information.org_information_id%TYPE;
2767: l_object_version_number hr_organization_information.object_version_number%TYPE;
2768: l_session_id number;
2769: l_effective_date date;
2770: --

Line 2767: l_object_version_number hr_organization_information.object_version_number%TYPE;

2763: -- Declare cursors and local variables
2764: --
2765: l_proc VARCHAR2(72) := g_package||'create_org_information';
2766: l_org_information_id hr_organization_information.org_information_id%TYPE;
2767: l_object_version_number hr_organization_information.object_version_number%TYPE;
2768: l_session_id number;
2769: l_effective_date date;
2770: --
2771: BEGIN

Line 3070: l_org_information_id hr_organization_information.org_information_id%TYPE;

3066: --
3067: -- Declare cursors and local variables
3068: --
3069: l_proc varchar2(72) := g_package||'create_org_manager';
3070: l_org_information_id hr_organization_information.org_information_id%TYPE;
3071: l_object_version_number hr_organization_information.object_version_number%TYPE;
3072: l_warning boolean;
3073: --
3074: cursor c1 is

Line 3071: l_object_version_number hr_organization_information.object_version_number%TYPE;

3067: -- Declare cursors and local variables
3068: --
3069: l_proc varchar2(72) := g_package||'create_org_manager';
3070: l_org_information_id hr_organization_information.org_information_id%TYPE;
3071: l_object_version_number hr_organization_information.object_version_number%TYPE;
3072: l_warning boolean;
3073: --
3074: cursor c1 is
3075: select business_group_id

Line 3422: l_object_version_number hr_organization_information.object_version_number%TYPE := p_object_version_number;

3418: --
3419: -- Declare cursors and local variables
3420: --
3421: l_proc VARCHAR2(72) := g_package||'update_org_information';
3422: l_object_version_number hr_organization_information.object_version_number%TYPE := p_object_version_number;
3423: l_temp_ovn number := p_object_version_number;
3424: l_session_id number; --Fix for bug9064403
3425: l_effective_date date; --Fix for bug9064403
3426:

Line 3431: select 1 from hr_organization_information hoi

3427: --
3428:
3429: cursor csr_check_ou
3430: is
3431: select 1 from hr_organization_information hoi
3432: where hoi.org_information_id = p_org_information_id
3433: and hoi.org_information_context = p_org_info_type_code;
3434: BEGIN
3435: --

Line 3531: -- Update row in HR_ORGANIZATION_INFORMATION Table

3527: end;
3528: --
3529: hr_utility.set_location(l_proc, 40);
3530: --
3531: -- Update row in HR_ORGANIZATION_INFORMATION Table
3532: --
3533: hr_ori_upd.upd(
3534: p_effective_date => p_effective_date,
3535: p_org_information_id => p_org_information_id,

Line 3747: l_object_version_number hr_organization_information.object_version_number%TYPE := p_object_version_number;

3743: --
3744: -- Declare cursors and local variables
3745: --
3746: l_proc VARCHAR2(72) := g_package||'update_org_manager';
3747: l_object_version_number hr_organization_information.object_version_number%TYPE := p_object_version_number;
3748: l_warning boolean;
3749: l_temp_ovn number := p_object_version_number;
3750: --
3751: cursor c1 is

Line 3842: -- Update row in HR_ORGANIZATION_INFORMATION Table

3838: end;
3839: --
3840: hr_utility.set_location(l_proc, 40);
3841: --
3842: -- Update row in HR_ORGANIZATION_INFORMATION Table
3843: --
3844: hr_ori_upd.upd
3845: (p_effective_date => p_effective_date
3846: ,p_org_information_id => p_org_information_id

Line 4033: l_object_version_number hr_organization_information.object_version_number%TYPE;

4029: --
4030: -- Declare cursors and local variables
4031: --
4032: l_proc varchar2(72) := g_package||'delete_org_manager';
4033: l_object_version_number hr_organization_information.object_version_number%TYPE;
4034: l_temp_ovn number := p_object_version_number;
4035: --
4036: begin
4037: --

Line 4148: l_org_information_id hr_organization_information.org_information_id%TYPE;

4144: --
4145: -- Declare cursors and local variables
4146: --
4147: l_proc VARCHAR2(72) := g_package||'create_org_class_internal';
4148: l_org_information_id hr_organization_information.org_information_id%TYPE;
4149: l_object_version_number hr_organization_information.object_version_number%TYPE;
4150: --
4151: BEGIN
4152: --

Line 4149: l_object_version_number hr_organization_information.object_version_number%TYPE;

4145: -- Declare cursors and local variables
4146: --
4147: l_proc VARCHAR2(72) := g_package||'create_org_class_internal';
4148: l_org_information_id hr_organization_information.org_information_id%TYPE;
4149: l_object_version_number hr_organization_information.object_version_number%TYPE;
4150: --
4151: BEGIN
4152: --
4153: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 4305: l_org_information_id hr_organization_information.org_information_id%TYPE;

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

Line 4462: from hr_organization_information HOI

4458: l_operating_unit_id number;
4459:
4460: cursor ou_person is
4461: select nvl(org_information1,fnd_profile.value('ORG_ID'))
4462: from hr_organization_information HOI
4463: , per_all_assignments_f PAAF
4464: where HOI.organization_id = PAAF.organization_id
4465: and PAAF.person_id = p_person_id
4466: and p_effective_date between

Line 4473: from hr_organization_information HOI

4469: and HOI.org_information_context='Exp Organization Defaults';
4470: --
4471: cursor ou_assignment is
4472: select nvl(org_information1,fnd_profile.value('ORG_ID'))
4473: from hr_organization_information HOI
4474: , per_all_assignments_f PAAF
4475: where HOI.organization_id = PAAF.organization_id
4476: and PAAF.assignment_id = p_assignment_id
4477: and p_effective_date between

Line 4483: from hr_organization_information HOI

4479: and HOI.org_information_context='Exp Organization Defaults';
4480: --
4481: cursor ou_organization is
4482: select nvl(org_information1,fnd_profile.value('ORG_ID'))
4483: from hr_organization_information HOI
4484: where HOI.organization_id = p_organization_id
4485: and HOI.org_information_context='Exp Organization Defaults';
4486: --
4487:

Line 4619: l_org_information_id hr_organization_information.org_information_id%TYPE;

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

Line 4792: l_legal_entity_id hr_organization_information.ORG_INFORMATION2%type;

4788: --
4789: -- Declare cursors and local variables
4790: --
4791: l_proc varchar2(72) := g_package||'update_operating_unit';
4792: l_legal_entity_id hr_organization_information.ORG_INFORMATION2%type;
4793: l_set_of_books_id hr_organization_information.ORG_INFORMATION3%type;
4794: l_object_version_number hr_organization_information.object_version_number%type;
4795: l_update_prim_ledger_warning boolean;
4796: l_org_information_id hr_organization_information.org_information_id%TYPE;

Line 4793: l_set_of_books_id hr_organization_information.ORG_INFORMATION3%type;

4789: -- Declare cursors and local variables
4790: --
4791: l_proc varchar2(72) := g_package||'update_operating_unit';
4792: l_legal_entity_id hr_organization_information.ORG_INFORMATION2%type;
4793: l_set_of_books_id hr_organization_information.ORG_INFORMATION3%type;
4794: l_object_version_number hr_organization_information.object_version_number%type;
4795: l_update_prim_ledger_warning boolean;
4796: l_org_information_id hr_organization_information.org_information_id%TYPE;
4797: l_new_org_information_id hr_organization_information.org_information_id%TYPE;

Line 4794: l_object_version_number hr_organization_information.object_version_number%type;

4790: --
4791: l_proc varchar2(72) := g_package||'update_operating_unit';
4792: l_legal_entity_id hr_organization_information.ORG_INFORMATION2%type;
4793: l_set_of_books_id hr_organization_information.ORG_INFORMATION3%type;
4794: l_object_version_number hr_organization_information.object_version_number%type;
4795: l_update_prim_ledger_warning boolean;
4796: l_org_information_id hr_organization_information.org_information_id%TYPE;
4797: l_new_org_information_id hr_organization_information.org_information_id%TYPE;
4798: l_new_ovn hr_organization_information.object_version_number%type;

Line 4796: l_org_information_id hr_organization_information.org_information_id%TYPE;

4792: l_legal_entity_id hr_organization_information.ORG_INFORMATION2%type;
4793: l_set_of_books_id hr_organization_information.ORG_INFORMATION3%type;
4794: l_object_version_number hr_organization_information.object_version_number%type;
4795: l_update_prim_ledger_warning boolean;
4796: l_org_information_id hr_organization_information.org_information_id%TYPE;
4797: l_new_org_information_id hr_organization_information.org_information_id%TYPE;
4798: l_new_ovn hr_organization_information.object_version_number%type;
4799: l_organization_id hr_all_organization_units.organization_id%TYPE;
4800: l_duplicate_org_warning boolean;

Line 4797: l_new_org_information_id hr_organization_information.org_information_id%TYPE;

4793: l_set_of_books_id hr_organization_information.ORG_INFORMATION3%type;
4794: l_object_version_number hr_organization_information.object_version_number%type;
4795: l_update_prim_ledger_warning boolean;
4796: l_org_information_id hr_organization_information.org_information_id%TYPE;
4797: l_new_org_information_id hr_organization_information.org_information_id%TYPE;
4798: l_new_ovn hr_organization_information.object_version_number%type;
4799: l_organization_id hr_all_organization_units.organization_id%TYPE;
4800: l_duplicate_org_warning boolean;
4801:

Line 4798: l_new_ovn hr_organization_information.object_version_number%type;

4794: l_object_version_number hr_organization_information.object_version_number%type;
4795: l_update_prim_ledger_warning boolean;
4796: l_org_information_id hr_organization_information.org_information_id%TYPE;
4797: l_new_org_information_id hr_organization_information.org_information_id%TYPE;
4798: l_new_ovn hr_organization_information.object_version_number%type;
4799: l_organization_id hr_all_organization_units.organization_id%TYPE;
4800: l_duplicate_org_warning boolean;
4801:
4802:

Line 4806: from hr_organization_information

4802:
4803: cursor csr_check_update (p_organization_id number)
4804: is
4805: select ORG_INFORMATION_ID,ORG_INFORMATION2,ORG_INFORMATION3,OBJECT_VERSION_NUMBER
4806: from hr_organization_information
4807: where ORG_INFORMATION_CONTEXT = 'Operating Unit Information'
4808: and organization_id = p_organization_id;
4809:
4810: BEGIN

Line 4960: l_org_information_id hr_organization_information.org_information_id%TYPE;

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

Line 5163: l_org_information_id hr_organization_information.org_information_id%TYPE;

5159: --
5160: l_proc VARCHAR2(72) := g_package||'create_bgr_classif';
5161: l_organization_id hr_all_organization_units.organization_id%TYPE;
5162: l_object_version_number hr_all_organization_units.object_version_number%TYPE;
5163: l_org_information_id hr_organization_information.org_information_id%TYPE;
5164: --
5165: BEGIN
5166: --
5167: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 5286: ( p_organization_id IN hr_organization_information.organization_id%TYPE)

5282: --
5283: -- {End Of Comments}
5284: --
5285: PROCEDURE chk_organization_id
5286: ( p_organization_id IN hr_organization_information.organization_id%TYPE)
5287: IS
5288: l_proc VARCHAR2(72) := g_package||'chk_organization_id';
5289: l_exists VARCHAR2(1) := 'N';
5290: --

Line 5340: l_org_information_id hr_organization_information.org_information_id%TYPE;

5336: --
5337: l_proc VARCHAR2(72) := g_package||'create_legal_entity_classif';
5338: l_organization_id hr_all_organization_units.organization_id%TYPE;
5339: l_object_version_number hr_all_organization_units.object_version_number%TYPE;
5340: l_org_information_id hr_organization_information.org_information_id%TYPE;
5341: --
5342: BEGIN
5343: --
5344: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 5431: l_org_information_id hr_organization_information.org_information_id%TYPE;

5427: --
5428: l_proc VARCHAR2(72) := g_package||'create_oper_unit_classif';
5429: l_organization_id hr_all_organization_units.organization_id%TYPE;
5430: l_object_version_number hr_all_organization_units.object_version_number%TYPE;
5431: l_org_information_id hr_organization_information.org_information_id%TYPE;
5432: --
5433: BEGIN
5434: --
5435: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 5814: l_org_information_id hr_organization_information.org_information_id%TYPE;

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