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 1937: IF NOT hr_security_internal.org_access_known THEN

1933: -- or if organization permissions are unknown for
1934: -- some other reason, use caching on demand to evaluate
1935: -- permissions on the fly.
1936: --
1937: IF NOT hr_security_internal.org_access_known THEN
1938: --
1939: -- Passing a value to p_what_to_evaluate avoids evaluating
1940: -- permissions for non-org security criteria.
1941: --

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

2298: l_pv_org_id number;
2299: l_org_id number;
2300:
2301: --
2302: -- Checks to see if there are any records in org_access for
2303: -- the current responsibility. fnd_global.resp_appl_id is used
2304: -- to improve index performance.
2305: --
2306: CURSOR c_chk_resp_in_org_access IS

Line 2306: CURSOR c_chk_resp_in_org_access IS

2302: -- Checks to see if there are any records in org_access for
2303: -- the current responsibility. fnd_global.resp_appl_id is used
2304: -- to improve index performance.
2305: --
2306: CURSOR c_chk_resp_in_org_access IS
2307: SELECT null
2308: FROM org_access oa
2309: WHERE oa.resp_application_id = g_resp_appl_id
2310: AND oa.responsibility_id = g_resp_id;

Line 2308: FROM org_access oa

2304: -- to improve index performance.
2305: --
2306: CURSOR c_chk_resp_in_org_access IS
2307: SELECT null
2308: FROM org_access oa
2309: WHERE oa.resp_application_id = g_resp_appl_id
2310: AND oa.responsibility_id = g_resp_id;
2311:
2312: --

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

2309: WHERE oa.resp_application_id = g_resp_appl_id
2310: AND oa.responsibility_id = g_resp_id;
2311:
2312: --
2313: -- Returns a single record in org_access that matches the
2314: -- current responsibility and p_org_id (if one exists).
2315: -- fnd_global.resp_appl_id is used to improve index performance.
2316: --
2317: CURSOR c_get_org_access_org IS

Line 2317: CURSOR c_get_org_access_org IS

2313: -- Returns a single record in org_access that matches the
2314: -- current responsibility and p_org_id (if one exists).
2315: -- fnd_global.resp_appl_id is used to improve index performance.
2316: --
2317: CURSOR c_get_org_access_org IS
2318: SELECT oa.organization_id
2319: FROM org_access oa
2320: WHERE oa.resp_application_id = g_resp_appl_id
2321: AND oa.responsibility_id = g_resp_id

Line 2319: FROM org_access oa

2315: -- fnd_global.resp_appl_id is used to improve index performance.
2316: --
2317: CURSOR c_get_org_access_org IS
2318: SELECT oa.organization_id
2319: FROM org_access oa
2320: WHERE oa.resp_application_id = g_resp_appl_id
2321: AND oa.responsibility_id = g_resp_id
2322: AND oa.organization_id = p_org_id;
2323:

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

2413: RETURN 'TRUE';
2414: END IF;
2415:
2416: --
2417: -- Get the org_access rows and see if any orgs match. If there are
2418: -- no matches against p_org_id, FALSE is returned. If no rows
2419: -- exist for the current responsibility, p_org_id is checked against
2420: -- the inventory orgs for the operating unit via hr_organization_units.
2421: --

Line 2422: OPEN c_chk_resp_in_org_access;

2418: -- no matches against p_org_id, FALSE is returned. If no rows
2419: -- exist for the current responsibility, p_org_id is checked against
2420: -- the inventory orgs for the operating unit via hr_organization_units.
2421: --
2422: OPEN c_chk_resp_in_org_access;
2423: FETCH c_chk_resp_in_org_access into l_org_id;
2424:
2425: IF c_chk_resp_in_org_access%FOUND THEN
2426: --

Line 2423: FETCH c_chk_resp_in_org_access into l_org_id;

2419: -- exist for the current responsibility, p_org_id is checked against
2420: -- the inventory orgs for the operating unit via hr_organization_units.
2421: --
2422: OPEN c_chk_resp_in_org_access;
2423: FETCH c_chk_resp_in_org_access into l_org_id;
2424:
2425: IF c_chk_resp_in_org_access%FOUND THEN
2426: --
2427: -- There are matching records, so see if any orgs in org_access

Line 2425: IF c_chk_resp_in_org_access%FOUND THEN

2421: --
2422: OPEN c_chk_resp_in_org_access;
2423: FETCH c_chk_resp_in_org_access into l_org_id;
2424:
2425: IF c_chk_resp_in_org_access%FOUND THEN
2426: --
2427: -- There are matching records, so see if any orgs in org_access
2428: -- match p_org_id.
2429: --

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

2423: FETCH c_chk_resp_in_org_access into l_org_id;
2424:
2425: IF c_chk_resp_in_org_access%FOUND THEN
2426: --
2427: -- There are matching records, so see if any orgs in org_access
2428: -- match p_org_id.
2429: --
2430: OPEN c_get_org_access_org;
2431: FETCH c_get_org_access_org INTO l_org_id;

Line 2430: OPEN c_get_org_access_org;

2426: --
2427: -- There are matching records, so see if any orgs in org_access
2428: -- match p_org_id.
2429: --
2430: OPEN c_get_org_access_org;
2431: FETCH c_get_org_access_org INTO l_org_id;
2432:
2433: IF c_get_org_access_org%FOUND THEN
2434: CLOSE c_chk_resp_in_org_access;

Line 2431: FETCH c_get_org_access_org INTO l_org_id;

2427: -- There are matching records, so see if any orgs in org_access
2428: -- match p_org_id.
2429: --
2430: OPEN c_get_org_access_org;
2431: FETCH c_get_org_access_org INTO l_org_id;
2432:
2433: IF c_get_org_access_org%FOUND THEN
2434: CLOSE c_chk_resp_in_org_access;
2435: CLOSE c_get_org_access_org;

Line 2433: IF c_get_org_access_org%FOUND THEN

2429: --
2430: OPEN c_get_org_access_org;
2431: FETCH c_get_org_access_org INTO l_org_id;
2432:
2433: IF c_get_org_access_org%FOUND THEN
2434: CLOSE c_chk_resp_in_org_access;
2435: CLOSE c_get_org_access_org;
2436: RETURN 'TRUE';
2437: ELSE

Line 2434: CLOSE c_chk_resp_in_org_access;

2430: OPEN c_get_org_access_org;
2431: FETCH c_get_org_access_org INTO l_org_id;
2432:
2433: IF c_get_org_access_org%FOUND THEN
2434: CLOSE c_chk_resp_in_org_access;
2435: CLOSE c_get_org_access_org;
2436: RETURN 'TRUE';
2437: ELSE
2438: CLOSE c_chk_resp_in_org_access;

Line 2435: CLOSE c_get_org_access_org;

2431: FETCH c_get_org_access_org INTO l_org_id;
2432:
2433: IF c_get_org_access_org%FOUND THEN
2434: CLOSE c_chk_resp_in_org_access;
2435: CLOSE c_get_org_access_org;
2436: RETURN 'TRUE';
2437: ELSE
2438: CLOSE c_chk_resp_in_org_access;
2439: CLOSE c_get_org_access_org;

Line 2438: CLOSE c_chk_resp_in_org_access;

2434: CLOSE c_chk_resp_in_org_access;
2435: CLOSE c_get_org_access_org;
2436: RETURN 'TRUE';
2437: ELSE
2438: CLOSE c_chk_resp_in_org_access;
2439: CLOSE c_get_org_access_org;
2440: RETURN 'FALSE';
2441: END IF;
2442:

Line 2439: CLOSE c_get_org_access_org;

2435: CLOSE c_get_org_access_org;
2436: RETURN 'TRUE';
2437: ELSE
2438: CLOSE c_chk_resp_in_org_access;
2439: CLOSE c_get_org_access_org;
2440: RETURN 'FALSE';
2441: END IF;
2442:
2443: ELSE

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

2441: END IF;
2442:
2443: ELSE
2444: --
2445: -- There are no records in org_access that match the responsibility
2446: -- so get the inventory orgs for the operating unit.
2447: --
2448: CLOSE c_chk_resp_in_org_access;
2449:

Line 2448: CLOSE c_chk_resp_in_org_access;

2444: --
2445: -- There are no records in org_access that match the responsibility
2446: -- so get the inventory orgs for the operating unit.
2447: --
2448: CLOSE c_chk_resp_in_org_access;
2449:
2450: OPEN c_get_inventory_org (l_pv_org_id);
2451: FETCH c_get_inventory_org into l_org_id;
2452: