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_SECURITY dependencies on ORG_ACCESS

Line 1480: IF NOT hr_security_internal.org_access_known THEN

1476: -- or if organization permissions are unknown for
1477: -- some other reason, use caching on demand to evaluate
1478: -- permissions on the fly.
1479: --
1480: IF NOT hr_security_internal.org_access_known THEN
1481: --
1482: -- Passing a value to p_what_to_evaluate avoids evaluating
1483: -- permissions for non-org security criteria.
1484: --

Line 1813: -- Checks to see if there are any records in org_access for

1809: l_pv_org_id number;
1810: l_org_id number;
1811:
1812: --
1813: -- Checks to see if there are any records in org_access for
1814: -- the current responsibility. fnd_global.resp_appl_id is used
1815: -- to improve index performance.
1816: --
1817: CURSOR c_chk_resp_in_org_access IS

Line 1817: CURSOR c_chk_resp_in_org_access IS

1813: -- Checks to see if there are any records in org_access for
1814: -- the current responsibility. fnd_global.resp_appl_id is used
1815: -- to improve index performance.
1816: --
1817: CURSOR c_chk_resp_in_org_access IS
1818: SELECT null
1819: FROM org_access oa
1820: WHERE oa.resp_application_id = g_resp_appl_id
1821: AND oa.responsibility_id = g_resp_id;

Line 1819: FROM org_access oa

1815: -- to improve index performance.
1816: --
1817: CURSOR c_chk_resp_in_org_access IS
1818: SELECT null
1819: FROM org_access oa
1820: WHERE oa.resp_application_id = g_resp_appl_id
1821: AND oa.responsibility_id = g_resp_id;
1822:
1823: --

Line 1824: -- Returns a single record in org_access that matches the

1820: WHERE oa.resp_application_id = g_resp_appl_id
1821: AND oa.responsibility_id = g_resp_id;
1822:
1823: --
1824: -- Returns a single record in org_access that matches the
1825: -- current responsibility and p_org_id (if one exists).
1826: -- fnd_global.resp_appl_id is used to improve index performance.
1827: --
1828: CURSOR c_get_org_access_org IS

Line 1828: CURSOR c_get_org_access_org IS

1824: -- Returns a single record in org_access that matches the
1825: -- current responsibility and p_org_id (if one exists).
1826: -- fnd_global.resp_appl_id is used to improve index performance.
1827: --
1828: CURSOR c_get_org_access_org IS
1829: SELECT oa.organization_id
1830: FROM org_access oa
1831: WHERE oa.resp_application_id = g_resp_appl_id
1832: AND oa.responsibility_id = g_resp_id

Line 1830: FROM org_access oa

1826: -- fnd_global.resp_appl_id is used to improve index performance.
1827: --
1828: CURSOR c_get_org_access_org IS
1829: SELECT oa.organization_id
1830: FROM org_access oa
1831: WHERE oa.resp_application_id = g_resp_appl_id
1832: AND oa.responsibility_id = g_resp_id
1833: AND oa.organization_id = p_org_id;
1834:

Line 1928: -- Get the org_access rows and see if any orgs match. If there are

1924: RETURN 'TRUE';
1925: END IF;
1926:
1927: --
1928: -- Get the org_access rows and see if any orgs match. If there are
1929: -- no matches against p_org_id, FALSE is returned. If no rows
1930: -- exist for the current responsibility, p_org_id is checked against
1931: -- the inventory orgs for the operating unit via hr_organization_units.
1932: --

Line 1933: OPEN c_chk_resp_in_org_access;

1929: -- no matches against p_org_id, FALSE is returned. If no rows
1930: -- exist for the current responsibility, p_org_id is checked against
1931: -- the inventory orgs for the operating unit via hr_organization_units.
1932: --
1933: OPEN c_chk_resp_in_org_access;
1934: FETCH c_chk_resp_in_org_access into l_org_id;
1935:
1936: IF c_chk_resp_in_org_access%FOUND THEN
1937: --

Line 1934: FETCH c_chk_resp_in_org_access into l_org_id;

1930: -- exist for the current responsibility, p_org_id is checked against
1931: -- the inventory orgs for the operating unit via hr_organization_units.
1932: --
1933: OPEN c_chk_resp_in_org_access;
1934: FETCH c_chk_resp_in_org_access into l_org_id;
1935:
1936: IF c_chk_resp_in_org_access%FOUND THEN
1937: --
1938: -- There are matching records, so see if any orgs in org_access

Line 1936: IF c_chk_resp_in_org_access%FOUND THEN

1932: --
1933: OPEN c_chk_resp_in_org_access;
1934: FETCH c_chk_resp_in_org_access into l_org_id;
1935:
1936: IF c_chk_resp_in_org_access%FOUND THEN
1937: --
1938: -- There are matching records, so see if any orgs in org_access
1939: -- match p_org_id.
1940: --

Line 1938: -- There are matching records, so see if any orgs in org_access

1934: FETCH c_chk_resp_in_org_access into l_org_id;
1935:
1936: IF c_chk_resp_in_org_access%FOUND THEN
1937: --
1938: -- There are matching records, so see if any orgs in org_access
1939: -- match p_org_id.
1940: --
1941: OPEN c_get_org_access_org;
1942: FETCH c_get_org_access_org INTO l_org_id;

Line 1941: OPEN c_get_org_access_org;

1937: --
1938: -- There are matching records, so see if any orgs in org_access
1939: -- match p_org_id.
1940: --
1941: OPEN c_get_org_access_org;
1942: FETCH c_get_org_access_org INTO l_org_id;
1943:
1944: IF c_get_org_access_org%FOUND THEN
1945: CLOSE c_chk_resp_in_org_access;

Line 1942: FETCH c_get_org_access_org INTO l_org_id;

1938: -- There are matching records, so see if any orgs in org_access
1939: -- match p_org_id.
1940: --
1941: OPEN c_get_org_access_org;
1942: FETCH c_get_org_access_org INTO l_org_id;
1943:
1944: IF c_get_org_access_org%FOUND THEN
1945: CLOSE c_chk_resp_in_org_access;
1946: CLOSE c_get_org_access_org;

Line 1944: IF c_get_org_access_org%FOUND THEN

1940: --
1941: OPEN c_get_org_access_org;
1942: FETCH c_get_org_access_org INTO l_org_id;
1943:
1944: IF c_get_org_access_org%FOUND THEN
1945: CLOSE c_chk_resp_in_org_access;
1946: CLOSE c_get_org_access_org;
1947: RETURN 'TRUE';
1948: ELSE

Line 1945: CLOSE c_chk_resp_in_org_access;

1941: OPEN c_get_org_access_org;
1942: FETCH c_get_org_access_org INTO l_org_id;
1943:
1944: IF c_get_org_access_org%FOUND THEN
1945: CLOSE c_chk_resp_in_org_access;
1946: CLOSE c_get_org_access_org;
1947: RETURN 'TRUE';
1948: ELSE
1949: CLOSE c_chk_resp_in_org_access;

Line 1946: CLOSE c_get_org_access_org;

1942: FETCH c_get_org_access_org INTO l_org_id;
1943:
1944: IF c_get_org_access_org%FOUND THEN
1945: CLOSE c_chk_resp_in_org_access;
1946: CLOSE c_get_org_access_org;
1947: RETURN 'TRUE';
1948: ELSE
1949: CLOSE c_chk_resp_in_org_access;
1950: CLOSE c_get_org_access_org;

Line 1949: CLOSE c_chk_resp_in_org_access;

1945: CLOSE c_chk_resp_in_org_access;
1946: CLOSE c_get_org_access_org;
1947: RETURN 'TRUE';
1948: ELSE
1949: CLOSE c_chk_resp_in_org_access;
1950: CLOSE c_get_org_access_org;
1951: RETURN 'FALSE';
1952: END IF;
1953:

Line 1950: CLOSE c_get_org_access_org;

1946: CLOSE c_get_org_access_org;
1947: RETURN 'TRUE';
1948: ELSE
1949: CLOSE c_chk_resp_in_org_access;
1950: CLOSE c_get_org_access_org;
1951: RETURN 'FALSE';
1952: END IF;
1953:
1954: ELSE

Line 1956: -- There are no records in org_access that match the responsibility

1952: END IF;
1953:
1954: ELSE
1955: --
1956: -- There are no records in org_access that match the responsibility
1957: -- so get the inventory orgs for the operating unit.
1958: --
1959: CLOSE c_chk_resp_in_org_access;
1960:

Line 1959: CLOSE c_chk_resp_in_org_access;

1955: --
1956: -- There are no records in org_access that match the responsibility
1957: -- so get the inventory orgs for the operating unit.
1958: --
1959: CLOSE c_chk_resp_in_org_access;
1960:
1961: OPEN c_get_inventory_org (l_pv_org_id);
1962: FETCH c_get_inventory_org into l_org_id;
1963: