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 pbg.legislation_code
88: from per_business_groups pbg
89: , hr_all_organization_units oru
90: where oru.organization_id = p_organization_id
91: and pbg.business_group_id = oru.business_group_id;
92: --
93: -- Declare local variables

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

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

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

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

Line 450: -- FROM hr_all_organization_units

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

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

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

Line 514: from hr_all_organization_units o

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

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

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

Line 687: p_cost_allocation_keyflex_id IN hr_all_organization_units.cost_allocation_keyflex_id%TYPE)

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

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

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

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

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

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

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

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

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

Line 1254: l_bg_id hr_all_organization_units.business_group_id%Type;

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

Line 1270: from hr_all_organization_units

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