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_ORU_BUS dependencies on HR_ALL_ORGANIZATION_UNITS

Line 29: , hr_all_organization_units oru

25: --
26: cursor csr_sec_grp is
27: select pbg.security_group_id
28: from per_business_groups pbg
29: , hr_all_organization_units oru
30: where oru.organization_id = p_organization_id
31: and pbg.business_group_id = oru.business_group_id;
32: --
33: -- Declare local variables

Line 89: HR_ALL_ORGANIZATION_UNITS ORU

85: --
86: cursor csr_leg_code is
87: select ORI.ORG_INFORMATION9
88: from HR_ORGANIZATION_INFORMATION ORI,
89: HR_ALL_ORGANIZATION_UNITS ORU
90: where ORI.ORGANIZATION_ID=ORU.BUSINESS_GROUP_ID
91: and ORU.ORGANIZATION_ID=p_organization_id
92: and ORI.ORG_INFORMATION_CONTEXT='Business Group Information'; -- changes for bug14506616
93: --

Line 440: -- (p_date_from IN hr_all_organization_units.date_from%TYPE,

436: --
437: -- {End Of Comments}
438: --
439: --PROCEDURE chk_date_from
440: -- (p_date_from IN hr_all_organization_units.date_from%TYPE,
441: -- p_effective_date IN DATE,
442: -- p_business_group_id IN hr_all_organization_units.business_group_id%TYPE)
443: --IS
444: --

Line 442: -- p_business_group_id IN hr_all_organization_units.business_group_id%TYPE)

438: --
439: --PROCEDURE chk_date_from
440: -- (p_date_from IN hr_all_organization_units.date_from%TYPE,
441: -- p_effective_date IN DATE,
442: -- p_business_group_id IN hr_all_organization_units.business_group_id%TYPE)
443: --IS
444: --
445: -- l_proc VARCHAR2(72) := g_package||'chk_date_from';
446: --

Line 451: -- FROM hr_all_organization_units

447: -- l_bgr_date_from DATE;
448: --
449: -- CURSOR csr_bgr_date_from IS
450: -- SELECT date_from
451: -- FROM hr_all_organization_units
452: -- WHERE organization_id = p_business_group_id
453: -- AND business_group_id = p_business_group_id;
454: --
455: --BEGIN

Line 500: ( p_name IN hr_all_organization_units.name%TYPE,

496: --
497: -- {End Of Comments}
498: --
499: PROCEDURE chk_name
500: ( p_name IN hr_all_organization_units.name%TYPE,
501: p_effective_date IN DATE default NULL,
502: p_business_group_id IN number,
503: p_organization_id IN number default null,
504: p_duplicate_org_warning OUT NOCOPY BOOLEAN

Line 515: from hr_all_organization_units o

511: l_duplicate_bg boolean;
512: l_bg number;
513: CURSOR C1 is
514: select o.organization_id, o.business_group_id
515: from hr_all_organization_units o
516: where (o.name = p_name OR o.organization_id = p_organization_id);
517:
518: BEGIN
519: --

Line 616: ( p_soft_coding_keyflex_id IN hr_all_organization_units.soft_coding_keyflex_id%TYPE)

612: --
613: -- {End Of Comments}
614: --
615: PROCEDURE chk_soft_coding_kf
616: ( p_soft_coding_keyflex_id IN hr_all_organization_units.soft_coding_keyflex_id%TYPE)
617: IS
618: l_proc VARCHAR2(72) := g_package||'chk_soft_coding_kf';
619: l_exists VARCHAR2(1) := 'N';
620: --

Line 688: p_cost_allocation_keyflex_id IN hr_all_organization_units.cost_allocation_keyflex_id%TYPE)

684: --
685: PROCEDURE chk_cost_alloc_kf
686: (p_organization_id IN NUMBER,
687: p_business_group_id IN NUMBER,
688: p_cost_allocation_keyflex_id IN hr_all_organization_units.cost_allocation_keyflex_id%TYPE)
689: IS
690: --
691: l_count NUMBER;
692: l_proc VARCHAR2(72) := g_package||'chk_cost_alloc_kf';

Line 800: ( p_location_id IN hr_all_organization_units.location_id%TYPE)

796: --
797: -- {End Of Comments}
798: --
799: PROCEDURE chk_location_id
800: ( p_location_id IN hr_all_organization_units.location_id%TYPE)
801: IS
802: l_proc VARCHAR2(72) := g_package||'chk_location_id';
803: l_exists VARCHAR2(1) := 'N';
804: --

Line 870: ( p_type IN hr_all_organization_units.type%TYPE,

866: --
867: -- {End Of Comments}
868: --
869: PROCEDURE chk_type
870: ( p_type IN hr_all_organization_units.type%TYPE,
871: p_effective_date IN DATE)
872: IS
873: l_proc VARCHAR2(72) := g_package||'chk_type';
874: l_exists VARCHAR2(1) := 'N';

Line 946: ( p_internal_external_flag IN hr_all_organization_units.internal_external_flag%TYPE,

942: --
943: -- {End Of Comments}
944: --
945: PROCEDURE chk_int_ext_flag
946: ( p_internal_external_flag IN hr_all_organization_units.internal_external_flag%TYPE,
947: p_effective_date IN DATE)
948: IS
949: l_proc VARCHAR2(72) := g_package||'chk_int_ext_flag';
950: l_exists VARCHAR2(1) := 'N';

Line 1031: ( p_organization_id IN hr_all_organization_units.organization_id%TYPE)

1027: --
1028: -- {End Of Comments}
1029: --
1030: PROCEDURE chk_org_delete
1031: ( p_organization_id IN hr_all_organization_units.organization_id%TYPE)
1032: IS
1033: l_proc VARCHAR2(72) := g_package||'chk_cls_exists';
1034: l_exists VARCHAR2(1) := 'N';
1035: --

Line 1255: l_bg_id hr_all_organization_units.business_group_id%Type;

1251: ) is
1252: --
1253: l_proc varchar2(72) := g_package||'delete_validate';
1254: -- Start of fix for bug 2881808
1255: l_bg_id hr_all_organization_units.business_group_id%Type;
1256: l_installed boolean;
1257: l_pa_installed varchar2(1);
1258: l_inv_installed varchar2(1);
1259: l_eng_installed varchar2(1);

Line 1271: from hr_all_organization_units

1267: -- Get the Business Group id.
1268: --
1269: select business_group_id
1270: into l_bg_id
1271: from hr_all_organization_units
1272: where organization_id = p_rec.organization_id;
1273: --
1274: hr_utility.set_location(l_proc, 10);
1275: --