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 ORG_ACCESS

Line 146: NOT EXISTS( SELECT 1 FROM ORG_ACCESS acc

142: SELECT organization_id_child
143: FROM per_org_structure_elements arc
144: WHERE
145: (
146: NOT EXISTS( SELECT 1 FROM ORG_ACCESS acc
147: WHERE acc.organization_id = organization_id_child
148: )
149: OR EXISTS( SELECT 1 FROM ORG_ACCESS acc
150: WHERE acc.organization_id = organization_id_child

Line 149: OR EXISTS( SELECT 1 FROM ORG_ACCESS acc

145: (
146: NOT EXISTS( SELECT 1 FROM ORG_ACCESS acc
147: WHERE acc.organization_id = organization_id_child
148: )
149: OR EXISTS( SELECT 1 FROM ORG_ACCESS acc
150: WHERE acc.organization_id = organization_id_child
151: AND acc.responsibility_id = l_responsibility_id
152: )
153: )

Line 168: NOT EXISTS( SELECT 1 FROM ORG_ACCESS acc

164: SELECT organization_id_child
165: FROM per_org_structure_elements arc
166: WHERE
167: (
168: NOT EXISTS( SELECT 1 FROM ORG_ACCESS acc
169: WHERE acc.organization_id = organization_id_child
170: )
171: OR EXISTS( SELECT 1 FROM ORG_ACCESS acc
172: WHERE acc.organization_id = organization_id_child

Line 171: OR EXISTS( SELECT 1 FROM ORG_ACCESS acc

167: (
168: NOT EXISTS( SELECT 1 FROM ORG_ACCESS acc
169: WHERE acc.organization_id = organization_id_child
170: )
171: OR EXISTS( SELECT 1 FROM ORG_ACCESS acc
172: WHERE acc.organization_id = organization_id_child
173: AND acc.responsibility_id = l_responsibility_id
174: )
175: )

Line 249: AND ( NOT EXISTS( SELECT 1 FROM ORG_ACCESS acc

245: OR org.date_to IS NULL
246: )
247:
248: -- inv security access check
249: AND ( NOT EXISTS( SELECT 1 FROM ORG_ACCESS acc
250: WHERE acc.organization_id = organization_id_child )
251: OR EXISTS( SELECT 1 FROM ORG_ACCESS acc
252: WHERE acc.organization_id = organization_id_child
253: AND acc.responsibility_id = l_responsibility_id

Line 251: OR EXISTS( SELECT 1 FROM ORG_ACCESS acc

247:
248: -- inv security access check
249: AND ( NOT EXISTS( SELECT 1 FROM ORG_ACCESS acc
250: WHERE acc.organization_id = organization_id_child )
251: OR EXISTS( SELECT 1 FROM ORG_ACCESS acc
252: WHERE acc.organization_id = organization_id_child
253: AND acc.responsibility_id = l_responsibility_id
254: )
255: )

Line 324: AND ( NOT EXISTS( SELECT 1 FROM ORG_ACCESS acc

320: OR org.date_to IS NULL
321: )
322:
323: -- inv security access check
324: AND ( NOT EXISTS( SELECT 1 FROM ORG_ACCESS acc
325: WHERE acc.organization_id = organization_id_child )
326: OR EXISTS( SELECT 1 FROM ORG_ACCESS acc
327: WHERE acc.organization_id = organization_id_child
328: AND acc.responsibility_id = l_responsibility_id

Line 326: OR EXISTS( SELECT 1 FROM ORG_ACCESS acc

322:
323: -- inv security access check
324: AND ( NOT EXISTS( SELECT 1 FROM ORG_ACCESS acc
325: WHERE acc.organization_id = organization_id_child )
326: OR EXISTS( SELECT 1 FROM ORG_ACCESS acc
327: WHERE acc.organization_id = organization_id_child
328: AND acc.responsibility_id = l_responsibility_id
329: )
330: )

Line 635: l_org_access_flag VARCHAR2(1);

631: l_security_profile_org_list OrgID_tbl_type;
632: l_org_list OrgID_tbl_type;
633: l_security_index BINARY_INTEGER;
634: l_org_index BINARY_INTEGER;
635: l_org_access_flag VARCHAR2(1);
636: l_view_all_org_flag VARCHAR2(1);
637: l_errorcode NUMBER;
638: l_errortext VARCHAR2(200);
639:

Line 765: l_org_access_flag := 'N';

761: , 'Top Organization Id: '|| to_char(l_top_organization_id)
762: );
763: END IF;
764:
765: l_org_access_flag := 'N';
766:
767: IF ((l_profile_hierarchy_name is NOT NULL) AND
768: (l_view_all_org_flag = 'N')) THEN
769:

Line 839: l_org_access_flag := 'Y';

835: END IF;
836:
837: IF (l_security_profile_org_list(l_security_index) =
838: l_org_list(l_org_index) ) THEN
839: l_org_access_flag := 'Y';
840: EXIT;
841: END IF;
842: l_org_index := l_org_list.NEXT(l_org_index);
843: END LOOP;

Line 851: -- Set the org access flag to Y

847:
848: ELSIF((l_profile_hierarchy_name is NULL) AND
849: (l_view_all_org_flag = 'Y')) THEN
850: -- User has access to view all the organizations.
851: -- Set the org access flag to Y
852: l_org_access_flag := 'Y';
853:
854: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
855: THEN

Line 852: l_org_access_flag := 'Y';

848: ELSIF((l_profile_hierarchy_name is NULL) AND
849: (l_view_all_org_flag = 'Y')) THEN
850: -- User has access to view all the organizations.
851: -- Set the org access flag to Y
852: l_org_access_flag := 'Y';
853:
854: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
855: THEN
856: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

Line 858: , 'User has access to view all the organizations. Setting l_org_access_flag to Y'

854: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
855: THEN
856: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
857: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Access'
858: , 'User has access to view all the organizations. Setting l_org_access_flag to Y'
859: );
860: END IF;
861: END IF;
862:

Line 867: , 'End of INV_ORGHIERARCHY_PVT.Org_Hierarchy_Access returning l_org_access_flag :' ||l_org_access_flag

863: IF G_DEBUG = 'Y' AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
864: THEN
865: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
866: , 'INV_ORGHIERARCHY_PVT.Org_Hierarchy_Access'
867: , 'End of INV_ORGHIERARCHY_PVT.Org_Hierarchy_Access returning l_org_access_flag :' ||l_org_access_flag
868: );
869: END IF;
870:
871: RETURN l_org_access_flag;

Line 871: RETURN l_org_access_flag;

867: , 'End of INV_ORGHIERARCHY_PVT.Org_Hierarchy_Access returning l_org_access_flag :' ||l_org_access_flag
868: );
869: END IF;
870:
871: RETURN l_org_access_flag;
872:
873: IF G_DEBUG = 'Y' THEN
874: INV_ORGHIERARCHY_PVT.Log
875: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

Line 2164: CURSOR c_org_access(c_organization_id NUMBER) IS

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
2165: SELECT RESPONSIBILITY_ID
2166: FROM ORG_ACCESS
2167: WHERE ORGANIZATION_ID = c_organization_id;
2168:

Line 2166: FROM ORG_ACCESS

2162: AND NVL(DATE_TO,TRUNC(SYSDATE)) >= TRUNC(SYSDATE);
2163:
2164: CURSOR c_org_access(c_organization_id NUMBER) IS
2165: SELECT RESPONSIBILITY_ID
2166: FROM ORG_ACCESS
2167: WHERE ORGANIZATION_ID = c_organization_id;
2168:
2169: l_responsibility_id NUMBER;
2170: l_org_resp_access_flag VARCHAR2(1);

Line 2277: OPEN c_org_access(p_org_id);

2273: -- Check only if the organization is unexpired
2274: IF (l_org_valid_flag = 'Y') THEN
2275:
2276: -- Open the cursor
2277: OPEN c_org_access(p_org_id);
2278:
2279: -- Retrieve the first row to setup for the WHILE loop
2280: FETCH c_org_access INTO l_responsibility_id;
2281:

Line 2280: FETCH c_org_access INTO l_responsibility_id;

2276: -- Open the cursor
2277: OPEN c_org_access(p_org_id);
2278:
2279: -- Retrieve the first row to setup for the WHILE loop
2280: FETCH c_org_access INTO l_responsibility_id;
2281:
2282: -- rows not found set the flag to Y
2283: IF c_org_access%NOTFOUND THEN
2284: l_org_resp_access_flag := 'Y';

Line 2283: IF c_org_access%NOTFOUND THEN

2279: -- Retrieve the first row to setup for the WHILE loop
2280: FETCH c_org_access INTO l_responsibility_id;
2281:
2282: -- rows not found set the flag to Y
2283: IF c_org_access%NOTFOUND THEN
2284: l_org_resp_access_flag := 'Y';
2285: END IF;
2286:
2287: -- continue looping while there are more rows to fetch

Line 2288: WHILE c_org_access%FOUND LOOP

2284: l_org_resp_access_flag := 'Y';
2285: END IF;
2286:
2287: -- continue looping while there are more rows to fetch
2288: WHILE c_org_access%FOUND LOOP
2289: -- check for the matching current user responsibility
2290: IF(p_responsibility_id = l_responsibility_id) THEN
2291: l_org_resp_access_flag := 'Y';
2292: EXIT;

Line 2295: FETCH c_org_access INTO l_responsibility_id;

2291: l_org_resp_access_flag := 'Y';
2292: EXIT;
2293: END IF;
2294: -- retrieve next user responsbility
2295: FETCH c_org_access INTO l_responsibility_id;
2296: END LOOP;
2297:
2298: CLOSE c_org_access;
2299:

Line 2298: CLOSE c_org_access;

2294: -- retrieve next user responsbility
2295: FETCH c_org_access INTO l_responsibility_id;
2296: END LOOP;
2297:
2298: CLOSE c_org_access;
2299:
2300: END IF; -- for the valid organization
2301:
2302: IF G_DEBUG = 'Y' THEN

Line 2387: AND ( NOT EXISTS( SELECT 1 FROM ORG_ACCESS acc

2383: OR org.date_to IS NULL
2384: )
2385:
2386: -- inv security access check
2387: AND ( NOT EXISTS( SELECT 1 FROM ORG_ACCESS acc
2388: WHERE acc.organization_id = c_org_id )
2389: OR EXISTS( SELECT 1 FROM ORG_ACCESS acc
2390: WHERE acc.organization_id = c_org_id
2391: AND acc.responsibility_id = c_responsibility_id

Line 2389: OR EXISTS( SELECT 1 FROM ORG_ACCESS acc

2385:
2386: -- inv security access check
2387: AND ( NOT EXISTS( SELECT 1 FROM ORG_ACCESS acc
2388: WHERE acc.organization_id = c_org_id )
2389: OR EXISTS( SELECT 1 FROM ORG_ACCESS acc
2390: WHERE acc.organization_id = c_org_id
2391: AND acc.responsibility_id = c_responsibility_id
2392: )
2393: );