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.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 625: l_org_hier_profile_id hr_all_organization_units.organization_id%TYPE;

621: (p_org_hierarchy_name IN VARCHAR2)
622: RETURN VARCHAR2 IS
623: l_profile_hierarchy_name VARCHAR2(30);
624: l_profile_id NUMBER;
625: l_org_hier_profile_id hr_all_organization_units.organization_id%TYPE;
626: l_org_count NUMBER := 0;
627: l_include_top_org_flag VARCHAR2(1);
628: l_top_organization_id hr_all_organization_units.organization_id%TYPE;
629: l_org_hier_level_id NUMBER := NULL; -- to facilitate overloading

Line 628: l_top_organization_id hr_all_organization_units.organization_id%TYPE;

624: l_profile_id NUMBER;
625: l_org_hier_profile_id hr_all_organization_units.organization_id%TYPE;
626: l_org_count NUMBER := 0;
627: l_include_top_org_flag VARCHAR2(1);
628: l_top_organization_id hr_all_organization_units.organization_id%TYPE;
629: l_org_hier_level_id NUMBER := NULL; -- to facilitate overloading
630:
631: l_security_profile_org_list OrgID_tbl_type;
632: l_org_list OrgID_tbl_type;

Line 925: l_org_hier_profile_id hr_all_organization_units.organization_id%TYPE;

921: p_org_hier_level_id IN NUMBER)
922: RETURN VARCHAR2 IS
923: l_profile_hierarchy_name VARCHAR2(30);
924: l_profile_id NUMBER;
925: l_org_hier_profile_id hr_all_organization_units.organization_id%TYPE;
926: l_org_count NUMBER := 0;
927: l_include_top_org_flag VARCHAR2(1);
928: l_top_organization_id hr_all_organization_units.organization_id%TYPE;
929: l_org_hier_level_id NUMBER := NULL; -- to facilitate overloading

Line 928: l_top_organization_id hr_all_organization_units.organization_id%TYPE;

924: l_profile_id NUMBER;
925: l_org_hier_profile_id hr_all_organization_units.organization_id%TYPE;
926: l_org_count NUMBER := 0;
927: l_include_top_org_flag VARCHAR2(1);
928: l_top_organization_id hr_all_organization_units.organization_id%TYPE;
929: l_org_hier_level_id NUMBER := NULL; -- to facilitate overloading
930:
931:
932: l_security_profile_org_list OrgID_tbl_type;

Line 1261: l_orgcode hr_all_organization_units.organization_id%TYPE;

1257: IS
1258:
1259: l_structure_version_id NUMBER;
1260: list_id NUMBER := 0;
1261: l_orgcode hr_all_organization_units.organization_id%TYPE;
1262: l_org_hierarchy_parent_id hr_all_organization_units.organization_id%TYPE;
1263: l_business_group_id hr_all_organization_units.organization_id%TYPE;
1264: l_level NUMBER;
1265: l_errorcode NUMBER;

Line 1262: l_org_hierarchy_parent_id hr_all_organization_units.organization_id%TYPE;

1258:
1259: l_structure_version_id NUMBER;
1260: list_id NUMBER := 0;
1261: l_orgcode hr_all_organization_units.organization_id%TYPE;
1262: l_org_hierarchy_parent_id hr_all_organization_units.organization_id%TYPE;
1263: l_business_group_id hr_all_organization_units.organization_id%TYPE;
1264: l_level NUMBER;
1265: l_errorcode NUMBER;
1266: l_errortext VARCHAR2(200);

Line 1263: l_business_group_id hr_all_organization_units.organization_id%TYPE;

1259: l_structure_version_id NUMBER;
1260: list_id NUMBER := 0;
1261: l_orgcode hr_all_organization_units.organization_id%TYPE;
1262: l_org_hierarchy_parent_id hr_all_organization_units.organization_id%TYPE;
1263: l_business_group_id hr_all_organization_units.organization_id%TYPE;
1264: l_level NUMBER;
1265: l_errorcode NUMBER;
1266: l_errortext VARCHAR2(200);
1267:

Line 1862: l_master_orgid hr_all_organization_units.organization_id%TYPE;

1858: p_property_type IN VARCHAR2 )
1859: RETURN VARCHAR2 IS
1860: l_structure_version_id NUMBER;
1861: list_id NUMBER := 0;
1862: l_master_orgid hr_all_organization_units.organization_id%TYPE;
1863: l_old_master_orgid hr_all_organization_units.organization_id%TYPE;
1864: l_period_set_name VARCHAR2(15);
1865: l_old_period_set_name VARCHAR2(15);
1866: l_chart_accounts_id NUMBER(15);

Line 1863: l_old_master_orgid hr_all_organization_units.organization_id%TYPE;

1859: RETURN VARCHAR2 IS
1860: l_structure_version_id NUMBER;
1861: list_id NUMBER := 0;
1862: l_master_orgid hr_all_organization_units.organization_id%TYPE;
1863: l_old_master_orgid hr_all_organization_units.organization_id%TYPE;
1864: l_period_set_name VARCHAR2(15);
1865: l_old_period_set_name VARCHAR2(15);
1866: l_chart_accounts_id NUMBER(15);
1867: l_old_chart_accounts_id NUMBER(15);

Line 2152: FROM HR_ALL_ORGANIZATION_UNITS

2148:
2149: -- cursor to check for the unexpired organization
2150: CURSOR c_unxpire_organization(c_org_id NUMBER, c_business_group_id NUMBER) IS
2151: SELECT 'Y'
2152: FROM HR_ALL_ORGANIZATION_UNITS
2153: WHERE ORGANIZATION_ID = c_org_id
2154: AND BUSINESS_GROUP_ID = c_business_group_id
2155: AND NVL(DATE_TO,TRUNC(SYSDATE)) >= TRUNC(SYSDATE);
2156:

Line 2160: FROM HR_ALL_ORGANIZATION_UNITS

2156:
2157: -- Bug 9775787, cursor to check for the unexpired organization in global organization hierarchy
2158: CURSOR c_unxpire_organization_global(c_org_id NUMBER) IS
2159: SELECT 'Y'
2160: FROM HR_ALL_ORGANIZATION_UNITS
2161: WHERE ORGANIZATION_ID = c_org_id
2162: AND NVL(DATE_TO,TRUNC(SYSDATE)) >= TRUNC(SYSDATE);
2163:
2164: CURSOR c_org_access(c_organization_id NUMBER) IS

Line 2377: FROM HR_ALL_ORGANIZATION_UNITS org

2373:
2374:
2375: CURSOR c_origin_resp_access(c_org_id NUMBER, c_responsibility_id NUMBER ) IS
2376: SELECT 'Y'
2377: FROM HR_ALL_ORGANIZATION_UNITS org
2378: WHERE
2379:
2380: -- expiration check
2381: org.organization_id = c_org_id

Line 2614: l_organization_id hr_all_organization_units.organization_id%TYPE;

2610: ( p_orgid_tbl_list IN orgID_tbl_type)
2611: IS
2612:
2613: l_org_index BINARY_INTEGER;
2614: l_organization_id hr_all_organization_units.organization_id%TYPE;
2615:
2616: BEGIN
2617: IF G_DEBUG = 'Y' THEN
2618: INV_ORGHIERARCHY_PVT.Log