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_organization_units org
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 896: (p_org_information1 IN hr_organization_information.org_information1%TYPE,

892: --
893: -- {End Of Comments}
894: --
895: PROCEDURE chk_name
896: (p_org_information1 IN hr_organization_information.org_information1%TYPE,
897: p_org_information_context IN hr_organization_information.org_information_context%TYPE,
898: p_organization_id IN number, --default null, -- R115.21
899: p_org_information2 IN hr_organization_information.org_information2%TYPE
900: )

Line 897: p_org_information_context IN hr_organization_information.org_information_context%TYPE,

893: -- {End Of Comments}
894: --
895: PROCEDURE chk_name
896: (p_org_information1 IN hr_organization_information.org_information1%TYPE,
897: p_org_information_context IN hr_organization_information.org_information_context%TYPE,
898: p_organization_id IN number, --default null, -- R115.21
899: p_org_information2 IN hr_organization_information.org_information2%TYPE
900: )
901: IS

Line 899: p_org_information2 IN hr_organization_information.org_information2%TYPE

895: PROCEDURE chk_name
896: (p_org_information1 IN hr_organization_information.org_information1%TYPE,
897: p_org_information_context IN hr_organization_information.org_information_context%TYPE,
898: p_organization_id IN number, --default null, -- R115.21
899: p_org_information2 IN hr_organization_information.org_information2%TYPE
900: )
901: IS
902: l_proc VARCHAR2(72) := g_package||'chk_name';
903: l_name hr_all_organization_units.name%TYPE;

Line 925: from hr_organization_information i, hr_all_organization_units u

921: and p_org_information2 = 'Y' then
922:
923: select count(*)
924: into l_exists
925: from hr_organization_information i, hr_all_organization_units u
926: where i.organization_id <> p_organization_id
927: and i.organization_id = u.organization_id
928: and i.org_information1='HR_BG'
929: and i.org_information_context='CLASS'

Line 1192: ,p_descflex_name => 'HR_ORGANIZATION_INFORMATION'

1188: -- b) During insert.
1189: --
1190: hr_dflex_utility.ins_or_upd_descflex_attribs
1191: (p_appl_short_name => 'PER'
1192: ,p_descflex_name => 'HR_ORGANIZATION_INFORMATION'
1193: ,p_attribute_category =>p_rec.attribute_category
1194: ,p_attribute1_name => 'ATTRIBUTE1'
1195: ,p_attribute1_value => p_rec.attribute1
1196: ,p_attribute2_name => 'ATTRIBUTE2'

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

1339: --
1340: -- {End Of Comments}
1341: --
1342: PROCEDURE chk_organization_id
1343: ( p_organization_id IN hr_organization_information.organization_id%TYPE,
1344: p_effective_date IN DATE)
1345: IS
1346: l_proc VARCHAR2(72) := g_package||'chk_organization_id';
1347: l_exists VARCHAR2(1) := 'N';

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

1410: --
1411: -- {End Of Comments}
1412: --
1413: PROCEDURE chk_cls_valid
1414: ( p_org_information_context IN hr_organization_information.org_information_context%TYPE,
1415: p_org_information1 IN hr_organization_information.org_information1%TYPE,
1416: p_effective_date IN DATE)
1417: IS
1418: l_proc VARCHAR2(72) := g_package||'chk_cls_valid';

Line 1415: p_org_information1 IN hr_organization_information.org_information1%TYPE,

1411: -- {End Of Comments}
1412: --
1413: PROCEDURE chk_cls_valid
1414: ( p_org_information_context IN hr_organization_information.org_information_context%TYPE,
1415: p_org_information1 IN hr_organization_information.org_information1%TYPE,
1416: p_effective_date IN DATE)
1417: IS
1418: l_proc VARCHAR2(72) := g_package||'chk_cls_valid';
1419: l_exists VARCHAR2(1) := 'N';

Line 1468: -- HR_ORGANIZATION_INFORMATION table for ORGANIZATION_ID.

1464: -- ----------------------------------------------------------------------------
1465: --
1466: -- Description:
1467: -- Validates that classification of organization unit is not present in
1468: -- HR_ORGANIZATION_INFORMATION table for ORGANIZATION_ID.
1469: --
1470: -- Pre-conditions:
1471: -- None.
1472: --

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

1491: --
1492: -- {End Of Comments}
1493: --
1494: PROCEDURE chk_cls_unique
1495: ( p_organization_id IN hr_organization_information.organization_id%TYPE,
1496: p_org_information1 IN hr_organization_information.org_information1%TYPE)
1497: IS
1498: l_proc VARCHAR2(72) := g_package||'chk_cls_unique';
1499: l_exists VARCHAR2(1) := 'N';

Line 1496: p_org_information1 IN hr_organization_information.org_information1%TYPE)

1492: -- {End Of Comments}
1493: --
1494: PROCEDURE chk_cls_unique
1495: ( p_organization_id IN hr_organization_information.organization_id%TYPE,
1496: p_org_information1 IN hr_organization_information.org_information1%TYPE)
1497: IS
1498: l_proc VARCHAR2(72) := g_package||'chk_cls_unique';
1499: l_exists VARCHAR2(1) := 'N';
1500: --

Line 1514: FROM hr_organization_information

1510: INTO l_exists
1511: FROM sys.dual
1512: WHERE EXISTS
1513: (SELECT null
1514: FROM hr_organization_information
1515: WHERE organization_id = p_organization_id
1516: AND org_information_context = 'CLASS'
1517: AND org_information1 = p_org_information1);
1518: EXCEPTION

Line 1542: -- HR_ORGANIZATION_INFORMATION table for ORGANIZATION_ID.

1538: --
1539: -- Description:
1540: -- Validates that info type is present in the list of info types
1541: -- for all current enabled classifications in
1542: -- HR_ORGANIZATION_INFORMATION table for ORGANIZATION_ID.
1543: --
1544: -- Pre-conditions:
1545: -- None.
1546: --

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

1565: --
1566: -- {End Of Comments}
1567: --
1568: PROCEDURE chk_info_type_valid
1569: ( p_organization_id IN hr_organization_information.organization_id%TYPE,
1570: p_org_information_context IN hr_organization_information.org_information_context%TYPE)
1571: IS
1572: l_proc VARCHAR2(72) := g_package||'chk_info_type_valid';
1573: l_exists VARCHAR2(1) := 'N';

Line 1570: p_org_information_context IN hr_organization_information.org_information_context%TYPE)

1566: -- {End Of Comments}
1567: --
1568: PROCEDURE chk_info_type_valid
1569: ( p_organization_id IN hr_organization_information.organization_id%TYPE,
1570: p_org_information_context IN hr_organization_information.org_information_context%TYPE)
1571: IS
1572: l_proc VARCHAR2(72) := g_package||'chk_info_type_valid';
1573: l_exists VARCHAR2(1) := 'N';
1574: --

Line 1596: ,hr_organization_information hoi

1592: AND (hoit.navigation_method = 'GS' OR hoit.navigation_method = 'GM' OR hoit.navigation_method = 'LOC')
1593: AND EXISTS
1594: (SELECT null
1595: FROM hr_org_info_types_by_class hitbc
1596: ,hr_organization_information hoi
1597: WHERE hitbc.org_information_type = hoit.org_information_type
1598: AND hitbc.org_classification = hoi.org_information1
1599: AND hoi.org_information2 = 'Y'
1600: AND hoi.org_information_context = 'CLASS'

Line 1635: -- HR_ORGANIZATION_INFORMATION table for ORGANIZATION_ID.

1631: -- ----------------------------------------------------------------------------
1632: --
1633: -- Description:
1634: -- Validates that info type is present in the
1635: -- HR_ORGANIZATION_INFORMATION table for ORGANIZATION_ID.
1636: --
1637: -- Pre-conditions:
1638: -- None.
1639: --

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

1658: --
1659: -- {End Of Comments}
1660: --
1661: PROCEDURE chk_info_type_unique
1662: ( p_organization_id IN hr_organization_information.organization_id%TYPE,
1663: p_org_information_context IN hr_organization_information.org_information_context%TYPE)
1664: IS
1665: l_proc VARCHAR2(72) := g_package||'chk_info_type_unique';
1666: l_exists VARCHAR2(1) := 'N';

Line 1663: p_org_information_context IN hr_organization_information.org_information_context%TYPE)

1659: -- {End Of Comments}
1660: --
1661: PROCEDURE chk_info_type_unique
1662: ( p_organization_id IN hr_organization_information.organization_id%TYPE,
1663: p_org_information_context IN hr_organization_information.org_information_context%TYPE)
1664: IS
1665: l_proc VARCHAR2(72) := g_package||'chk_info_type_unique';
1666: l_exists VARCHAR2(1) := 'N';
1667: --

Line 1681: FROM hr_organization_information hoi

1677: INTO l_exists
1678: FROM sys.dual
1679: WHERE EXISTS
1680: (SELECT null
1681: FROM hr_organization_information hoi
1682: ,hr_org_information_types hoit
1683: WHERE hoi.org_information_context = p_org_information_context
1684: AND hoi.organization_id = p_organization_id
1685: AND hoit.org_information_type = p_org_information_context

Line 1705: p_organization_id IN hr_organization_information.organization_id%TYPE

1701: END chk_info_type_unique;
1702: --
1703: -- Bug 3456540 Start
1704: procedure chk_location(
1705: p_organization_id IN hr_organization_information.organization_id%TYPE
1706: ) is
1707: --
1708: cursor csr_location is
1709: select location_id

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

1758: --
1759: -- {End Of Comments}
1760: --
1761: Procedure check_state_tax_rules
1762: (X_Org_Information_ID in hr_organization_information.organization_id%TYPE,
1763: X_org_information1 in hr_organization_information.org_information1%TYPE,
1764: X_org_information8 in hr_organization_information.org_information8%TYPE )
1765: as
1766: --

Line 1763: X_org_information1 in hr_organization_information.org_information1%TYPE,

1759: -- {End Of Comments}
1760: --
1761: Procedure check_state_tax_rules
1762: (X_Org_Information_ID in hr_organization_information.organization_id%TYPE,
1763: X_org_information1 in hr_organization_information.org_information1%TYPE,
1764: X_org_information8 in hr_organization_information.org_information8%TYPE )
1765: as
1766: --
1767: -- declare local variables

Line 1764: X_org_information8 in hr_organization_information.org_information8%TYPE )

1760: --
1761: Procedure check_state_tax_rules
1762: (X_Org_Information_ID in hr_organization_information.organization_id%TYPE,
1763: X_org_information1 in hr_organization_information.org_information1%TYPE,
1764: X_org_information8 in hr_organization_information.org_information8%TYPE )
1765: as
1766: --
1767: -- declare local variables
1768: --

Line 1783: hr_organization_information

1779: select
1780: org_information1,
1781: org_information8
1782: from
1783: hr_organization_information
1784: where
1785: org_information_id = X_org_information_id;
1786: --
1787:

Line 2057: -- Descriptive Flexfield is context dependent HR_ORGANIZATION_INFORMATION

2053: else
2054: hr_ori_bus.chk_ddf(p_rec);
2055: end if;
2056: --
2057: -- Descriptive Flexfield is context dependent HR_ORGANIZATION_INFORMATION
2058: --
2059: --fix for bug 6376908.
2060: --Added the if condition before calling the procedure chk_df.
2061: --