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_ORI_BUS dependencies on HR_ORGANIZATION_INFORMATION

Line 27: -- hr_organization_information and PER_BUSINESS_GROUPS

23: --
24: -- Declare cursor
25: --
26: -- EDIT_HERE In the following cursor statement add join(s) between
27: -- hr_organization_information and PER_BUSINESS_GROUPS
28: -- so that the security_group_id for
29: -- the current business group context can be derived.
30: -- Remove this comment when the edit has been completed.
31: cursor csr_sec_grp is

Line 34: , hr_organization_information ori

30: -- Remove this comment when the edit has been completed.
31: cursor csr_sec_grp is
32: select pbg.security_group_id
33: from per_business_groups pbg
34: , hr_organization_information ori
35: -- , EDIT_HERE table_name(s) 333
36: where ori.org_information_id = p_org_information_id;
37: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;
38: --

Line 105: from hr_organization_information

101: l_proc varchar2(72) := g_package||'chk_cost_center_gap';
102: --
103: cursor c1 is
104: select max(fnd_date.canonical_to_date(org_information4)) max_end_date
105: from hr_organization_information
106: where organization_id = p_organization_id
107: and org_information_context = 'Organization Name Alias'
108: and org_information_id <> nvl(p_org_information_id,-1)
109: and fnd_date.canonical_to_date(org_information4) < p_start_date;

Line 113: from hr_organization_information

109: and fnd_date.canonical_to_date(org_information4) < p_start_date;
110: --
111: cursor c2 is
112: select min(fnd_date.canonical_to_date(org_information3)) min_start_date
113: from hr_organization_information
114: where organization_id = p_organization_id
115: and org_information_context = 'Organization Name Alias'
116: and org_information_id <> nvl(p_org_information_id,-1)
117: and fnd_date.canonical_to_date(org_information3)

Line 508: hr_organization_information org2,

504: from dual
505: where exists
506: (select null
507: from hr_organization_units org,
508: hr_organization_information org2,
509: hr_org_info_types_by_class oitbc
510: where org.organization_id = p_organization_id
511: and org.organization_id = org2.organization_id
512: and org2.org_information_context = 'CLASS'

Line 669: from hr_organization_information

665: l_end_date date;
666: --
667: cursor c1 is
668: select null
669: from hr_organization_information
670: where organization_id = p_organization_id
671: and org_information_context = 'Organization Name Alias'
672: and (l_start_date
673: between fnd_date.canonical_to_date(org_information3)

Line 815: -- hr_organization_information and PER_BUSINESS_GROUPS

811: --
812: -- Declare cursor
813: --
814: -- EDIT_HERE In the following cursor statement add join(s) between
815: -- hr_organization_information and PER_BUSINESS_GROUPS
816: -- so that the legislation_code for
817: -- the current business group context can be derived.
818: -- Remove this comment when the edit has been completed.
819: -- JOIN COMPLETED

Line 823: , hr_organization_information ori

819: -- JOIN COMPLETED
820: /*cursor csr_leg_code is
821: select pbg.legislation_code
822: from per_business_groups pbg
823: , hr_organization_information ori
824: , hr_all_organization_units org -- Modified for bug # 6794638 to pick from base table
825: where ori.org_information_id = p_org_information_id
826: and org.organization_id = ori.organization_id
827: and pbg.business_group_id = org.business_group_id; -- AT 27/9/01 */

Line 832: hr_organization_information ori1,

828:
829: cursor csr_leg_code is
830: select ori2.ORG_INFORMATION9 from
831: hr_all_organization_units org,
832: hr_organization_information ori1,
833: hr_organization_information ori2
834: where ori1.ORG_INFORMATION_ID=p_org_information_id
835: and org.ORGANIZATION_ID=ori1.ORGANIZATION_ID
836: and ori2.ORGANIZATION_ID=org.business_group_id

Line 833: hr_organization_information ori2

829: cursor csr_leg_code is
830: select ori2.ORG_INFORMATION9 from
831: hr_all_organization_units org,
832: hr_organization_information ori1,
833: hr_organization_information ori2
834: where ori1.ORG_INFORMATION_ID=p_org_information_id
835: and org.ORGANIZATION_ID=ori1.ORGANIZATION_ID
836: and ori2.ORGANIZATION_ID=org.business_group_id
837: and ori2.ORG_INFORMATION_CONTEXT='Business Group Information'; -- bug14506616

Line 906: (p_org_information1 IN hr_organization_information.org_information1%TYPE,

902: --
903: -- {End Of Comments}
904: --
905: PROCEDURE chk_name
906: (p_org_information1 IN hr_organization_information.org_information1%TYPE,
907: p_org_information_context IN hr_organization_information.org_information_context%TYPE,
908: p_organization_id IN number, --default null, -- R115.21
909: p_org_information2 IN hr_organization_information.org_information2%TYPE
910: )

Line 907: p_org_information_context IN hr_organization_information.org_information_context%TYPE,

903: -- {End Of Comments}
904: --
905: PROCEDURE chk_name
906: (p_org_information1 IN hr_organization_information.org_information1%TYPE,
907: p_org_information_context IN hr_organization_information.org_information_context%TYPE,
908: p_organization_id IN number, --default null, -- R115.21
909: p_org_information2 IN hr_organization_information.org_information2%TYPE
910: )
911: IS

Line 909: p_org_information2 IN hr_organization_information.org_information2%TYPE

905: PROCEDURE chk_name
906: (p_org_information1 IN hr_organization_information.org_information1%TYPE,
907: p_org_information_context IN hr_organization_information.org_information_context%TYPE,
908: p_organization_id IN number, --default null, -- R115.21
909: p_org_information2 IN hr_organization_information.org_information2%TYPE
910: )
911: IS
912: l_proc VARCHAR2(72) := g_package||'chk_name';
913: l_name hr_all_organization_units.name%TYPE;

Line 935: from hr_organization_information i, hr_all_organization_units u

931: and p_org_information2 = 'Y' then
932:
933: select count(*)
934: into l_exists
935: from hr_organization_information i, hr_all_organization_units u
936: where i.organization_id <> p_organization_id
937: and i.organization_id = u.organization_id
938: and i.org_information1='HR_BG'
939: and i.org_information_context='CLASS'

Line 1202: ,p_descflex_name => 'HR_ORGANIZATION_INFORMATION'

1198: -- b) During insert.
1199: --
1200: hr_dflex_utility.ins_or_upd_descflex_attribs
1201: (p_appl_short_name => 'PER'
1202: ,p_descflex_name => 'HR_ORGANIZATION_INFORMATION'
1203: ,p_attribute_category =>p_rec.attribute_category
1204: ,p_attribute1_name => 'ATTRIBUTE1'
1205: ,p_attribute1_value => p_rec.attribute1
1206: ,p_attribute2_name => 'ATTRIBUTE2'

Line 1353: ( p_organization_id IN hr_organization_information.organization_id%TYPE,

1349: --
1350: -- {End Of Comments}
1351: --
1352: PROCEDURE chk_organization_id
1353: ( p_organization_id IN hr_organization_information.organization_id%TYPE,
1354: p_effective_date IN DATE)
1355: IS
1356: l_proc VARCHAR2(72) := g_package||'chk_organization_id';
1357: l_exists VARCHAR2(1) := 'N';

Line 1424: ( p_org_information_context IN hr_organization_information.org_information_context%TYPE,

1420: --
1421: -- {End Of Comments}
1422: --
1423: PROCEDURE chk_cls_valid
1424: ( p_org_information_context IN hr_organization_information.org_information_context%TYPE,
1425: p_org_information1 IN hr_organization_information.org_information1%TYPE,
1426: p_effective_date IN DATE)
1427: IS
1428: l_proc VARCHAR2(72) := g_package||'chk_cls_valid';

Line 1425: p_org_information1 IN hr_organization_information.org_information1%TYPE,

1421: -- {End Of Comments}
1422: --
1423: PROCEDURE chk_cls_valid
1424: ( p_org_information_context IN hr_organization_information.org_information_context%TYPE,
1425: p_org_information1 IN hr_organization_information.org_information1%TYPE,
1426: p_effective_date IN DATE)
1427: IS
1428: l_proc VARCHAR2(72) := g_package||'chk_cls_valid';
1429: l_exists VARCHAR2(1) := 'N';

Line 1478: -- HR_ORGANIZATION_INFORMATION table for ORGANIZATION_ID.

1474: -- ----------------------------------------------------------------------------
1475: --
1476: -- Description:
1477: -- Validates that classification of organization unit is not present in
1478: -- HR_ORGANIZATION_INFORMATION table for ORGANIZATION_ID.
1479: --
1480: -- Pre-conditions:
1481: -- None.
1482: --

Line 1505: ( p_organization_id IN hr_organization_information.organization_id%TYPE,

1501: --
1502: -- {End Of Comments}
1503: --
1504: PROCEDURE chk_cls_unique
1505: ( p_organization_id IN hr_organization_information.organization_id%TYPE,
1506: p_org_information1 IN hr_organization_information.org_information1%TYPE)
1507: IS
1508: l_proc VARCHAR2(72) := g_package||'chk_cls_unique';
1509: l_exists VARCHAR2(1) := 'N';

Line 1506: p_org_information1 IN hr_organization_information.org_information1%TYPE)

1502: -- {End Of Comments}
1503: --
1504: PROCEDURE chk_cls_unique
1505: ( p_organization_id IN hr_organization_information.organization_id%TYPE,
1506: p_org_information1 IN hr_organization_information.org_information1%TYPE)
1507: IS
1508: l_proc VARCHAR2(72) := g_package||'chk_cls_unique';
1509: l_exists VARCHAR2(1) := 'N';
1510: --

Line 1524: FROM hr_organization_information

1520: INTO l_exists
1521: FROM sys.dual
1522: WHERE EXISTS
1523: (SELECT null
1524: FROM hr_organization_information
1525: WHERE organization_id = p_organization_id
1526: AND org_information_context = 'CLASS'
1527: AND org_information1 = p_org_information1);
1528: EXCEPTION

Line 1552: -- HR_ORGANIZATION_INFORMATION table for ORGANIZATION_ID.

1548: --
1549: -- Description:
1550: -- Validates that info type is present in the list of info types
1551: -- for all current enabled classifications in
1552: -- HR_ORGANIZATION_INFORMATION table for ORGANIZATION_ID.
1553: --
1554: -- Pre-conditions:
1555: -- None.
1556: --

Line 1579: ( p_organization_id IN hr_organization_information.organization_id%TYPE,

1575: --
1576: -- {End Of Comments}
1577: --
1578: PROCEDURE chk_info_type_valid
1579: ( p_organization_id IN hr_organization_information.organization_id%TYPE,
1580: p_org_information_context IN hr_organization_information.org_information_context%TYPE)
1581: IS
1582: l_proc VARCHAR2(72) := g_package||'chk_info_type_valid';
1583: l_exists VARCHAR2(1) := 'N';

Line 1580: p_org_information_context IN hr_organization_information.org_information_context%TYPE)

1576: -- {End Of Comments}
1577: --
1578: PROCEDURE chk_info_type_valid
1579: ( p_organization_id IN hr_organization_information.organization_id%TYPE,
1580: p_org_information_context IN hr_organization_information.org_information_context%TYPE)
1581: IS
1582: l_proc VARCHAR2(72) := g_package||'chk_info_type_valid';
1583: l_exists VARCHAR2(1) := 'N';
1584: --

Line 1606: ,hr_organization_information hoi

1602: AND (hoit.navigation_method = 'GS' OR hoit.navigation_method = 'GM' OR hoit.navigation_method = 'LOC')
1603: AND EXISTS
1604: (SELECT null
1605: FROM hr_org_info_types_by_class hitbc
1606: ,hr_organization_information hoi
1607: WHERE hitbc.org_information_type = hoit.org_information_type
1608: AND hitbc.org_classification = hoi.org_information1
1609: AND hoi.org_information2 = 'Y'
1610: AND hoi.org_information_context = 'CLASS'

Line 1645: -- HR_ORGANIZATION_INFORMATION table for ORGANIZATION_ID.

1641: -- ----------------------------------------------------------------------------
1642: --
1643: -- Description:
1644: -- Validates that info type is present in the
1645: -- HR_ORGANIZATION_INFORMATION table for ORGANIZATION_ID.
1646: --
1647: -- Pre-conditions:
1648: -- None.
1649: --

Line 1672: ( p_organization_id IN hr_organization_information.organization_id%TYPE,

1668: --
1669: -- {End Of Comments}
1670: --
1671: PROCEDURE chk_info_type_unique
1672: ( p_organization_id IN hr_organization_information.organization_id%TYPE,
1673: p_org_information_context IN hr_organization_information.org_information_context%TYPE)
1674: IS
1675: l_proc VARCHAR2(72) := g_package||'chk_info_type_unique';
1676: l_exists VARCHAR2(1) := 'N';

Line 1673: p_org_information_context IN hr_organization_information.org_information_context%TYPE)

1669: -- {End Of Comments}
1670: --
1671: PROCEDURE chk_info_type_unique
1672: ( p_organization_id IN hr_organization_information.organization_id%TYPE,
1673: p_org_information_context IN hr_organization_information.org_information_context%TYPE)
1674: IS
1675: l_proc VARCHAR2(72) := g_package||'chk_info_type_unique';
1676: l_exists VARCHAR2(1) := 'N';
1677: --

Line 1691: FROM hr_organization_information hoi

1687: INTO l_exists
1688: FROM sys.dual
1689: WHERE EXISTS
1690: (SELECT null
1691: FROM hr_organization_information hoi
1692: ,hr_org_information_types hoit
1693: WHERE hoi.org_information_context = p_org_information_context
1694: AND hoi.organization_id = p_organization_id
1695: AND hoit.org_information_type = p_org_information_context

Line 1715: p_organization_id IN hr_organization_information.organization_id%TYPE

1711: END chk_info_type_unique;
1712: --
1713: -- Bug 3456540 Start
1714: procedure chk_location(
1715: p_organization_id IN hr_organization_information.organization_id%TYPE
1716: ) is
1717: --
1718: cursor csr_location is
1719: select location_id

Line 1772: (X_Org_Information_ID in hr_organization_information.organization_id%TYPE,

1768: --
1769: -- {End Of Comments}
1770: --
1771: Procedure check_state_tax_rules
1772: (X_Org_Information_ID in hr_organization_information.organization_id%TYPE,
1773: X_org_information1 in hr_organization_information.org_information1%TYPE,
1774: X_org_information8 in hr_organization_information.org_information8%TYPE )
1775: as
1776: --

Line 1773: X_org_information1 in hr_organization_information.org_information1%TYPE,

1769: -- {End Of Comments}
1770: --
1771: Procedure check_state_tax_rules
1772: (X_Org_Information_ID in hr_organization_information.organization_id%TYPE,
1773: X_org_information1 in hr_organization_information.org_information1%TYPE,
1774: X_org_information8 in hr_organization_information.org_information8%TYPE )
1775: as
1776: --
1777: -- declare local variables

Line 1774: X_org_information8 in hr_organization_information.org_information8%TYPE )

1770: --
1771: Procedure check_state_tax_rules
1772: (X_Org_Information_ID in hr_organization_information.organization_id%TYPE,
1773: X_org_information1 in hr_organization_information.org_information1%TYPE,
1774: X_org_information8 in hr_organization_information.org_information8%TYPE )
1775: as
1776: --
1777: -- declare local variables
1778: --

Line 1793: hr_organization_information

1789: select
1790: org_information1,
1791: org_information8
1792: from
1793: hr_organization_information
1794: where
1795: org_information_id = X_org_information_id;
1796: --
1797:

Line 2067: -- Descriptive Flexfield is context dependent HR_ORGANIZATION_INFORMATION

2063: else
2064: hr_ori_bus.chk_ddf(p_rec);
2065: end if;
2066: --
2067: -- Descriptive Flexfield is context dependent HR_ORGANIZATION_INFORMATION
2068: --
2069: --fix for bug 6376908.
2070: --Added the if condition before calling the procedure chk_df.
2071: --