APPS.INV_ORGHIERARCHY_PVT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 187: hr_all_organization_units org,

183: UNION
184: ( SELECT l_sec_origin_org_id FROM DUAL WHERE l_include_origin_flag = 'Y')
185: )
186: ),
187: hr_all_organization_units org,
188: hr_organization_information hoi,
189: mtl_parameters mp
190: WHERE
191: org.organization_id = hoi.organization_id

Line 229: , hr_all_organization_units org

225: arc.organization_id_parent = p_origin_org_id
226: AND arc.org_structure_version_id = l_hierarchy_version_id
227: )
228:
229: , hr_all_organization_units org
230: , hr_organization_information hoi
231: , mtl_parameters mp
232:
233:

Line 304: , hr_all_organization_units org

300:
301: )
302:
303:
304: , hr_all_organization_units org
305: , hr_organization_information hoi
306: , mtl_parameters mp
307:
308:

Line 569: l_org_hier_profile_id hr_all_organization_units.organization_id%TYPE;

565: (p_org_hierarchy_name IN VARCHAR2)
566: RETURN VARCHAR2 IS
567: l_profile_hierarchy_name VARCHAR2(30);
568: l_profile_id NUMBER;
569: l_org_hier_profile_id hr_all_organization_units.organization_id%TYPE;
570: l_org_count NUMBER := 0;
571: l_include_top_org_flag VARCHAR2(1);
572: l_top_organization_id hr_all_organization_units.organization_id%TYPE;
573: l_org_hier_level_id NUMBER := NULL; -- to facilitate overloading

Line 572: l_top_organization_id hr_all_organization_units.organization_id%TYPE;

568: l_profile_id NUMBER;
569: l_org_hier_profile_id hr_all_organization_units.organization_id%TYPE;
570: l_org_count NUMBER := 0;
571: l_include_top_org_flag VARCHAR2(1);
572: l_top_organization_id hr_all_organization_units.organization_id%TYPE;
573: l_org_hier_level_id NUMBER := NULL; -- to facilitate overloading
574:
575: l_security_profile_org_list OrgID_tbl_type;
576: l_org_list OrgID_tbl_type;

Line 756: l_org_hier_profile_id hr_all_organization_units.organization_id%TYPE;

752: p_org_hier_level_id IN NUMBER)
753: RETURN VARCHAR2 IS
754: l_profile_hierarchy_name VARCHAR2(30);
755: l_profile_id NUMBER;
756: l_org_hier_profile_id hr_all_organization_units.organization_id%TYPE;
757: l_org_count NUMBER := 0;
758: l_include_top_org_flag VARCHAR2(1);
759: l_top_organization_id hr_all_organization_units.organization_id%TYPE;
760: l_org_hier_level_id NUMBER := NULL; -- to facilitate overloading

Line 759: l_top_organization_id hr_all_organization_units.organization_id%TYPE;

755: l_profile_id NUMBER;
756: l_org_hier_profile_id hr_all_organization_units.organization_id%TYPE;
757: l_org_count NUMBER := 0;
758: l_include_top_org_flag VARCHAR2(1);
759: l_top_organization_id hr_all_organization_units.organization_id%TYPE;
760: l_org_hier_level_id NUMBER := NULL; -- to facilitate overloading
761:
762:
763: l_security_profile_org_list OrgID_tbl_type;

Line 978: l_orgcode hr_all_organization_units.organization_id%TYPE;

974: IS
975:
976: l_structure_version_id NUMBER;
977: list_id NUMBER := 0;
978: l_orgcode hr_all_organization_units.organization_id%TYPE;
979: l_org_hierarchy_parent_id hr_all_organization_units.organization_id%TYPE;
980: l_business_group_id hr_all_organization_units.organization_id%TYPE;
981: l_level NUMBER;
982: l_errorcode NUMBER;

Line 979: l_org_hierarchy_parent_id hr_all_organization_units.organization_id%TYPE;

975:
976: l_structure_version_id NUMBER;
977: list_id NUMBER := 0;
978: l_orgcode hr_all_organization_units.organization_id%TYPE;
979: l_org_hierarchy_parent_id hr_all_organization_units.organization_id%TYPE;
980: l_business_group_id hr_all_organization_units.organization_id%TYPE;
981: l_level NUMBER;
982: l_errorcode NUMBER;
983: l_errortext VARCHAR2(200);

Line 980: l_business_group_id hr_all_organization_units.organization_id%TYPE;

976: l_structure_version_id NUMBER;
977: list_id NUMBER := 0;
978: l_orgcode hr_all_organization_units.organization_id%TYPE;
979: l_org_hierarchy_parent_id hr_all_organization_units.organization_id%TYPE;
980: l_business_group_id hr_all_organization_units.organization_id%TYPE;
981: l_level NUMBER;
982: l_errorcode NUMBER;
983: l_errortext VARCHAR2(200);
984:

Line 1485: l_master_orgid hr_all_organization_units.organization_id%TYPE;

1481: p_property_type IN VARCHAR2 )
1482: RETURN VARCHAR2 IS
1483: l_structure_version_id NUMBER;
1484: list_id NUMBER := 0;
1485: l_master_orgid hr_all_organization_units.organization_id%TYPE;
1486: l_old_master_orgid hr_all_organization_units.organization_id%TYPE;
1487: l_period_set_name VARCHAR2(15);
1488: l_old_period_set_name VARCHAR2(15);
1489: l_chart_accounts_id NUMBER(15);

Line 1486: l_old_master_orgid hr_all_organization_units.organization_id%TYPE;

1482: RETURN VARCHAR2 IS
1483: l_structure_version_id NUMBER;
1484: list_id NUMBER := 0;
1485: l_master_orgid hr_all_organization_units.organization_id%TYPE;
1486: l_old_master_orgid hr_all_organization_units.organization_id%TYPE;
1487: l_period_set_name VARCHAR2(15);
1488: l_old_period_set_name VARCHAR2(15);
1489: l_chart_accounts_id NUMBER(15);
1490: l_old_chart_accounts_id NUMBER(15);

Line 1781: FROM HR_ALL_ORGANIZATION_UNITS

1777:
1778: -- cursor to check for the unexpired organization
1779: CURSOR c_unxpire_organization(c_org_id NUMBER, c_business_group_id NUMBER) IS
1780: SELECT 'Y'
1781: FROM HR_ALL_ORGANIZATION_UNITS
1782: WHERE ORGANIZATION_ID = c_org_id
1783: AND BUSINESS_GROUP_ID = c_business_group_id
1784: AND NVL(DATE_TO,TRUNC(SYSDATE)) >= TRUNC(SYSDATE);
1785:

Line 1923: FROM HR_ALL_ORGANIZATION_UNITS org

1919:
1920:
1921: CURSOR c_origin_resp_access(c_org_id NUMBER, c_responsibility_id NUMBER ) IS
1922: SELECT 'Y'
1923: FROM HR_ALL_ORGANIZATION_UNITS org
1924: WHERE
1925:
1926: -- expiration check
1927: org.organization_id = c_org_id

Line 2108: l_organization_id hr_all_organization_units.organization_id%TYPE;

2104: ( p_orgid_tbl_list IN orgID_tbl_type)
2105: IS
2106:
2107: l_org_index BINARY_INTEGER;
2108: l_organization_id hr_all_organization_units.organization_id%TYPE;
2109:
2110: BEGIN
2111: IF G_DEBUG = 'Y' THEN
2112: INV_ORGHIERARCHY_PVT.Log