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 579: l_org_access_flag VARCHAR2(1);

575: l_security_profile_org_list OrgID_tbl_type;
576: l_org_list OrgID_tbl_type;
577: l_security_index BINARY_INTEGER;
578: l_org_index BINARY_INTEGER;
579: l_org_access_flag VARCHAR2(1);
580: l_view_all_org_flag VARCHAR2(1);
581: l_errorcode NUMBER;
582: l_errortext VARCHAR2(200);
583:

Line 656: l_org_access_flag := 'N';

652: || ' Top Organization Id:' || to_char(l_top_organization_id)
653: );
654: END IF;
655:
656: l_org_access_flag := 'N';
657: IF ((l_profile_hierarchy_name is NOT NULL) AND
658: (l_view_all_org_flag = 'N')) THEN
659:
660: -- Obtain List of Organizations for the Security profile Org

Line 695: l_org_access_flag := 'Y';

691: l_org_index := l_org_list.FIRST;
692: WHILE (l_org_index <= l_org_list.LAST) LOOP
693: IF (l_security_profile_org_list(l_security_index) =
694: l_org_list(l_org_index) ) THEN
695: l_org_access_flag := 'Y';
696: EXIT;
697: END IF;
698: l_org_index := l_org_list.NEXT(l_org_index);
699: END LOOP;

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

703:
704: ELSIF((l_profile_hierarchy_name is NULL) AND
705: (l_view_all_org_flag = 'Y')) THEN
706: -- User has access to view all the organizations.
707: -- Set the org access flag to Y
708: l_org_access_flag := 'Y';
709: END IF;
710:
711: RETURN l_org_access_flag;

Line 708: l_org_access_flag := 'Y';

704: ELSIF((l_profile_hierarchy_name is NULL) AND
705: (l_view_all_org_flag = 'Y')) THEN
706: -- User has access to view all the organizations.
707: -- Set the org access flag to Y
708: l_org_access_flag := 'Y';
709: END IF;
710:
711: RETURN l_org_access_flag;
712:

Line 711: RETURN l_org_access_flag;

707: -- Set the org access flag to Y
708: l_org_access_flag := 'Y';
709: END IF;
710:
711: RETURN l_org_access_flag;
712:
713: IF G_DEBUG = 'Y' THEN
714: INV_ORGHIERARCHY_PVT.Log
715: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

Line 1786: CURSOR c_org_access(c_organization_id NUMBER) IS

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:
1786: CURSOR c_org_access(c_organization_id NUMBER) IS
1787: SELECT RESPONSIBILITY_ID
1788: FROM ORG_ACCESS
1789: WHERE ORGANIZATION_ID = c_organization_id;
1790:

Line 1788: FROM ORG_ACCESS

1784: AND NVL(DATE_TO,TRUNC(SYSDATE)) >= TRUNC(SYSDATE);
1785:
1786: CURSOR c_org_access(c_organization_id NUMBER) IS
1787: SELECT RESPONSIBILITY_ID
1788: FROM ORG_ACCESS
1789: WHERE ORGANIZATION_ID = c_organization_id;
1790:
1791: l_responsibility_id NUMBER;
1792: l_org_resp_access_flag VARCHAR2(1);

Line 1839: OPEN c_org_access(p_org_id);

1835: -- Check only if the organization is unexpired
1836: IF (l_org_valid_flag = 'Y') THEN
1837:
1838: -- Open the cursor
1839: OPEN c_org_access(p_org_id);
1840:
1841: -- Retrieve the first row to setup for the WHILE loop
1842: FETCH c_org_access INTO l_responsibility_id;
1843:

Line 1842: FETCH c_org_access INTO l_responsibility_id;

1838: -- Open the cursor
1839: OPEN c_org_access(p_org_id);
1840:
1841: -- Retrieve the first row to setup for the WHILE loop
1842: FETCH c_org_access INTO l_responsibility_id;
1843:
1844: -- rows not found set the flag to Y
1845: IF c_org_access%NOTFOUND THEN
1846: l_org_resp_access_flag := 'Y';

Line 1845: IF c_org_access%NOTFOUND THEN

1841: -- Retrieve the first row to setup for the WHILE loop
1842: FETCH c_org_access INTO l_responsibility_id;
1843:
1844: -- rows not found set the flag to Y
1845: IF c_org_access%NOTFOUND THEN
1846: l_org_resp_access_flag := 'Y';
1847: END IF;
1848:
1849: -- continue looping while there are more rows to fetch

Line 1850: WHILE c_org_access%FOUND LOOP

1846: l_org_resp_access_flag := 'Y';
1847: END IF;
1848:
1849: -- continue looping while there are more rows to fetch
1850: WHILE c_org_access%FOUND LOOP
1851: -- check for the matching current user responsibility
1852: IF(p_responsibility_id = l_responsibility_id) THEN
1853: l_org_resp_access_flag := 'Y';
1854: EXIT;

Line 1857: FETCH c_org_access INTO l_responsibility_id;

1853: l_org_resp_access_flag := 'Y';
1854: EXIT;
1855: END IF;
1856: -- retrieve next user responsbility
1857: FETCH c_org_access INTO l_responsibility_id;
1858: END LOOP;
1859:
1860: CLOSE c_org_access;
1861:

Line 1860: CLOSE c_org_access;

1856: -- retrieve next user responsbility
1857: FETCH c_org_access INTO l_responsibility_id;
1858: END LOOP;
1859:
1860: CLOSE c_org_access;
1861:
1862: END IF; -- for the valid organization
1863:
1864: IF G_DEBUG = 'Y' THEN

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

1929: OR org.date_to IS NULL
1930: )
1931:
1932: -- inv security access check
1933: AND ( NOT EXISTS( SELECT 1 FROM ORG_ACCESS acc
1934: WHERE acc.organization_id = c_org_id )
1935: OR EXISTS( SELECT 1 FROM ORG_ACCESS acc
1936: WHERE acc.organization_id = c_org_id
1937: AND acc.responsibility_id = c_responsibility_id

Line 1935: OR EXISTS( SELECT 1 FROM ORG_ACCESS acc

1931:
1932: -- inv security access check
1933: AND ( NOT EXISTS( SELECT 1 FROM ORG_ACCESS acc
1934: WHERE acc.organization_id = c_org_id )
1935: OR EXISTS( SELECT 1 FROM ORG_ACCESS acc
1936: WHERE acc.organization_id = c_org_id
1937: AND acc.responsibility_id = c_responsibility_id
1938: )
1939: );