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: --
3425:
3426: cursor csr_check_ou

Line 3428: select 1 from hr_organization_information hoi

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

Line 3520: -- Update row in HR_ORGANIZATION_INFORMATION Table

3516: end;
3517: --
3518: hr_utility.set_location(l_proc, 40);
3519: --
3520: -- Update row in HR_ORGANIZATION_INFORMATION Table
3521: --
3522: hr_ori_upd.upd(
3523: p_effective_date => p_effective_date,
3524: p_org_information_id => p_org_information_id,

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

3727: --
3728: -- Declare cursors and local variables
3729: --
3730: l_proc VARCHAR2(72) := g_package||'update_org_manager';
3731: l_object_version_number hr_organization_information.object_version_number%TYPE := p_object_version_number;
3732: l_warning boolean;
3733: l_temp_ovn number := p_object_version_number;
3734: --
3735: cursor c1 is

Line 3826: -- Update row in HR_ORGANIZATION_INFORMATION Table

3822: end;
3823: --
3824: hr_utility.set_location(l_proc, 40);
3825: --
3826: -- Update row in HR_ORGANIZATION_INFORMATION Table
3827: --
3828: hr_ori_upd.upd
3829: (p_effective_date => p_effective_date
3830: ,p_org_information_id => p_org_information_id

Line 4017: l_object_version_number hr_organization_information.object_version_number%TYPE;

4013: --
4014: -- Declare cursors and local variables
4015: --
4016: l_proc varchar2(72) := g_package||'delete_org_manager';
4017: l_object_version_number hr_organization_information.object_version_number%TYPE;
4018: l_temp_ovn number := p_object_version_number;
4019: --
4020: begin
4021: --

Line 4132: l_org_information_id hr_organization_information.org_information_id%TYPE;

4128: --
4129: -- Declare cursors and local variables
4130: --
4131: l_proc VARCHAR2(72) := g_package||'create_org_class_internal';
4132: l_org_information_id hr_organization_information.org_information_id%TYPE;
4133: l_object_version_number hr_organization_information.object_version_number%TYPE;
4134: --
4135: BEGIN
4136: --

Line 4133: l_object_version_number hr_organization_information.object_version_number%TYPE;

4129: -- Declare cursors and local variables
4130: --
4131: l_proc VARCHAR2(72) := g_package||'create_org_class_internal';
4132: l_org_information_id hr_organization_information.org_information_id%TYPE;
4133: l_object_version_number hr_organization_information.object_version_number%TYPE;
4134: --
4135: BEGIN
4136: --
4137: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 4251: l_org_information_id hr_organization_information.org_information_id%TYPE;

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

Line 4408: from hr_organization_information HOI

4404: l_operating_unit_id number;
4405:
4406: cursor ou_person is
4407: select nvl(org_information1,fnd_profile.value('ORG_ID'))
4408: from hr_organization_information HOI
4409: , per_all_assignments_f PAAF
4410: where HOI.organization_id = PAAF.organization_id
4411: and PAAF.person_id = p_person_id
4412: and p_effective_date between

Line 4419: from hr_organization_information HOI

4415: and HOI.org_information_context='Exp Organization Defaults';
4416: --
4417: cursor ou_assignment is
4418: select nvl(org_information1,fnd_profile.value('ORG_ID'))
4419: from hr_organization_information HOI
4420: , per_all_assignments_f PAAF
4421: where HOI.organization_id = PAAF.organization_id
4422: and PAAF.assignment_id = p_assignment_id
4423: and p_effective_date between

Line 4429: from hr_organization_information HOI

4425: and HOI.org_information_context='Exp Organization Defaults';
4426: --
4427: cursor ou_organization is
4428: select nvl(org_information1,fnd_profile.value('ORG_ID'))
4429: from hr_organization_information HOI
4430: where HOI.organization_id = p_organization_id
4431: and HOI.org_information_context='Exp Organization Defaults';
4432: --
4433:

Line 4565: l_org_information_id hr_organization_information.org_information_id%TYPE;

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

Line 4738: l_legal_entity_id hr_organization_information.ORG_INFORMATION2%type;

4734: --
4735: -- Declare cursors and local variables
4736: --
4737: l_proc varchar2(72) := g_package||'update_operating_unit';
4738: l_legal_entity_id hr_organization_information.ORG_INFORMATION2%type;
4739: l_set_of_books_id hr_organization_information.ORG_INFORMATION3%type;
4740: l_object_version_number hr_organization_information.object_version_number%type;
4741: l_update_prim_ledger_warning boolean;
4742: l_org_information_id hr_organization_information.org_information_id%TYPE;

Line 4739: l_set_of_books_id hr_organization_information.ORG_INFORMATION3%type;

4735: -- Declare cursors and local variables
4736: --
4737: l_proc varchar2(72) := g_package||'update_operating_unit';
4738: l_legal_entity_id hr_organization_information.ORG_INFORMATION2%type;
4739: l_set_of_books_id hr_organization_information.ORG_INFORMATION3%type;
4740: l_object_version_number hr_organization_information.object_version_number%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;

Line 4740: l_object_version_number hr_organization_information.object_version_number%type;

4736: --
4737: l_proc varchar2(72) := g_package||'update_operating_unit';
4738: l_legal_entity_id hr_organization_information.ORG_INFORMATION2%type;
4739: l_set_of_books_id hr_organization_information.ORG_INFORMATION3%type;
4740: l_object_version_number hr_organization_information.object_version_number%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;

Line 4742: l_org_information_id hr_organization_information.org_information_id%TYPE;

4738: l_legal_entity_id hr_organization_information.ORG_INFORMATION2%type;
4739: l_set_of_books_id hr_organization_information.ORG_INFORMATION3%type;
4740: l_object_version_number hr_organization_information.object_version_number%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;

Line 4743: l_new_org_information_id hr_organization_information.org_information_id%TYPE;

4739: l_set_of_books_id hr_organization_information.ORG_INFORMATION3%type;
4740: l_object_version_number hr_organization_information.object_version_number%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:

Line 4744: l_new_ovn hr_organization_information.object_version_number%type;

4740: l_object_version_number hr_organization_information.object_version_number%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:

Line 4752: from hr_organization_information

4748:
4749: cursor csr_check_update (p_organization_id number)
4750: is
4751: select ORG_INFORMATION_ID,ORG_INFORMATION2,ORG_INFORMATION3,OBJECT_VERSION_NUMBER
4752: from hr_organization_information
4753: where ORG_INFORMATION_CONTEXT = 'Operating Unit Information'
4754: and organization_id = p_organization_id;
4755:
4756: BEGIN

Line 4906: l_org_information_id hr_organization_information.org_information_id%TYPE;

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

Line 5109: l_org_information_id hr_organization_information.org_information_id%TYPE;

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: --
5113: hr_utility.set_location('Entering:'|| l_proc, 10);

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

5228: --
5229: -- {End Of Comments}
5230: --
5231: PROCEDURE chk_organization_id
5232: ( p_organization_id IN hr_organization_information.organization_id%TYPE)
5233: IS
5234: l_proc VARCHAR2(72) := g_package||'chk_organization_id';
5235: l_exists VARCHAR2(1) := 'N';
5236: --

Line 5286: l_org_information_id hr_organization_information.org_information_id%TYPE;

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: --
5290: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 5377: l_org_information_id hr_organization_information.org_information_id%TYPE;

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: --
5381: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 5760: l_org_information_id hr_organization_information.org_information_id%TYPE;

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