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.GMD_SECURITY_POLICY dependencies on FND_GLOBAL

Line 29: v_resp_id = fnd_global.resp_id

25: -- Context m_fs_context, variable pc_ind with value 'Yes'
26: -- allows Planning and Costing enginees to have access to all formulas.
27: --
28: IF SYS_CONTEXT('m_fs_context','pc_ind') = 'Yes' or
29: v_resp_id = fnd_global.resp_id
30: THEN
31: f_predicate := '1=1';
32:
33: ELSE

Line 40: ' OR sp.user_id = fnd_global.user_id '||

36: ' EXISTS ( SELECT 1 '||
37: ' FROM gmd_security_profiles sp '||
38: ' WHERE sp.assign_method_ind = ''A'' '||
39: ' AND ( ( sp.user_id = fnd_profile.value(''GMD_DEFAULT_USER'') '||
40: ' OR sp.user_id = fnd_global.user_id '||
41: ' ) '||
42: ' OR ( EXISTS ( SELECT rg.responsibility_id '||
43: ' FROM FND_USER_RESP_GROUPS rg '||
44: ' WHERE rg.user_id = fnd_global.user_id '||

Line 44: ' WHERE rg.user_id = fnd_global.user_id '||

40: ' OR sp.user_id = fnd_global.user_id '||
41: ' ) '||
42: ' OR ( EXISTS ( SELECT rg.responsibility_id '||
43: ' FROM FND_USER_RESP_GROUPS rg '||
44: ' WHERE rg.user_id = fnd_global.user_id '||
45: ' AND sp.responsibility_id = rg.responsibility_id '||
46: ' AND SYSDATE BETWEEN rg.start_date AND NVL(rg.end_date, SYSDATE) '||
47: ' ) '||
48: ' ) '||

Line 58: ' AND a1.resp_application_id = fnd_global.resp_appl_id '||

54: ' ) '||
55: ' OR sp.other_organization_id = a1.organization_id '||
56: ' ) '||
57: ' AND NVL(a1.disable_date, SYSDATE+1) >= SYSDATE '||
58: ' AND a1.resp_application_id = fnd_global.resp_appl_id '||
59: ' AND a1.responsibility_id = fnd_global.resp_id '||
60: ' ) '||
61: ' OR '||
62: ' NOT EXISTS ( SELECT NULL '||

Line 59: ' AND a1.responsibility_id = fnd_global.resp_id '||

55: ' OR sp.other_organization_id = a1.organization_id '||
56: ' ) '||
57: ' AND NVL(a1.disable_date, SYSDATE+1) >= SYSDATE '||
58: ' AND a1.resp_application_id = fnd_global.resp_appl_id '||
59: ' AND a1.responsibility_id = fnd_global.resp_id '||
60: ' ) '||
61: ' OR '||
62: ' NOT EXISTS ( SELECT NULL '||
63: ' FROM org_access a2 '||

Line 77: ' OR fs.user_id = fnd_global.user_id '||

73: ' ) '||
74: ' OR EXISTS ( SELECT 1 '||
75: ' FROM gmd_formula_security fs '||
76: ' WHERE ( ( fs.user_id = fnd_profile.value(''GMD_DEFAULT_USER'') '||
77: ' OR fs.user_id = fnd_global.user_id '||
78: ' ) '||
79: ' OR ( EXISTS ( SELECT rg.responsibility_id '||
80: ' FROM FND_USER_RESP_GROUPS rg '||
81: ' WHERE rg.user_id = fnd_global.user_id '||

Line 81: ' WHERE rg.user_id = fnd_global.user_id '||

77: ' OR fs.user_id = fnd_global.user_id '||
78: ' ) '||
79: ' OR ( EXISTS ( SELECT rg.responsibility_id '||
80: ' FROM FND_USER_RESP_GROUPS rg '||
81: ' WHERE rg.user_id = fnd_global.user_id '||
82: ' AND fs.responsibility_id = rg.responsibility_id '||
83: ' AND SYSDATE BETWEEN rg.start_date '||
84: ' AND NVL(rg.end_date, SYSDATE) '||
85: ' ) '||

Line 96: ' AND ou.resp_application_id = fnd_global.resp_appl_id '||

92: ' ) '||
93: ' OR fs.other_organization_id = ou.organization_id '||
94: ' ) '||
95: ' AND NVL(ou.disable_date, SYSDATE+1) >= SYSDATE '||
96: ' AND ou.resp_application_id = fnd_global.resp_appl_id '||
97: ' AND ou.responsibility_id = fnd_global.resp_id '||
98: ' ) '||
99: ' OR '||
100: ' NOT EXISTS ( SELECT NULL '||

Line 97: ' AND ou.responsibility_id = fnd_global.resp_id '||

93: ' OR fs.other_organization_id = ou.organization_id '||
94: ' ) '||
95: ' AND NVL(ou.disable_date, SYSDATE+1) >= SYSDATE '||
96: ' AND ou.resp_application_id = fnd_global.resp_appl_id '||
97: ' AND ou.responsibility_id = fnd_global.resp_id '||
98: ' ) '||
99: ' OR '||
100: ' NOT EXISTS ( SELECT NULL '||
101: ' FROM org_access ou1 '||

Line 137: ' WHERE rg.user_id = fnd_global.user_id '||

133: ' FROM gmd_security_profiles sp '||
134: ' WHERE sp.access_type_ind = ''U'' '||
135: ' AND ( responsibility_id IN ( SELECT rg.responsibility_id '||
136: ' FROM FND_USER_RESP_GROUPS rg '||
137: ' WHERE rg.user_id = fnd_global.user_id '||
138: ' AND SYSDATE BETWEEN rg.start_date '||
139: ' AND NVL(rg.end_date, SYSDATE) '||
140: ' ) '||
141: ' OR ( sp.user_id = fnd_profile.value_specific(''GMD_DEFAULT_USER'') '||

Line 142: ' OR sp.user_id = fnd_global.user_id '||

138: ' AND SYSDATE BETWEEN rg.start_date '||
139: ' AND NVL(rg.end_date, SYSDATE) '||
140: ' ) '||
141: ' OR ( sp.user_id = fnd_profile.value_specific(''GMD_DEFAULT_USER'') '||
142: ' OR sp.user_id = fnd_global.user_id '||
143: ' ) '||
144: ' ) '||
145: ' AND organization_id = '||obj_name||'.owner_organization_id '||
146: ' AND (other_organization_id IS NULL '||

Line 151: ' AND a3.resp_application_id = fnd_global.resp_appl_id '||

147: ' OR EXISTS ( SELECT NULL '||
148: ' FROM org_access a3 '||
149: ' WHERE a3.organization_id = sp.other_organization_id '||
150: ' AND NVL(a3.disable_date, SYSDATE+1) >= SYSDATE '||
151: ' AND a3.resp_application_id = fnd_global.resp_appl_id '||
152: ' AND a3.responsibility_id = fnd_global.resp_id '||
153: ' ) '||
154: ' OR NOT EXISTS ( SELECT NULL '||
155: ' FROM org_access a4 '||

Line 152: ' AND a3.responsibility_id = fnd_global.resp_id '||

148: ' FROM org_access a3 '||
149: ' WHERE a3.organization_id = sp.other_organization_id '||
150: ' AND NVL(a3.disable_date, SYSDATE+1) >= SYSDATE '||
151: ' AND a3.resp_application_id = fnd_global.resp_appl_id '||
152: ' AND a3.responsibility_id = fnd_global.resp_id '||
153: ' ) '||
154: ' OR NOT EXISTS ( SELECT NULL '||
155: ' FROM org_access a4 '||
156: ' WHERE a4.organization_id = sp.other_organization_id '||

Line 181: ' WHERE rg.user_id = fnd_global.user_id '||

177: ' FROM gmd_security_profiles sp '||
178: ' WHERE sp.access_type_ind = ''U'' '||
179: ' AND ( responsibility_id IN ( SELECT rg.responsibility_id '||
180: ' FROM FND_USER_RESP_GROUPS rg '||
181: ' WHERE rg.user_id = fnd_global.user_id '||
182: ' AND SYSDATE BETWEEN rg.start_date '||
183: ' AND NVL(rg.end_date, SYSDATE) '||
184: ' ) '||
185: ' OR ( sp.user_id = fnd_profile.value_specific(''GMD_DEFAULT_USER'') '||

Line 186: ' OR sp.user_id = fnd_global.user_id '||

182: ' AND SYSDATE BETWEEN rg.start_date '||
183: ' AND NVL(rg.end_date, SYSDATE) '||
184: ' ) '||
185: ' OR ( sp.user_id = fnd_profile.value_specific(''GMD_DEFAULT_USER'') '||
186: ' OR sp.user_id = fnd_global.user_id '||
187: ' ) '||
188: ' ) '||
189: ' AND organization_id = '||obj_name||'.organization_id '||
190: ' AND (other_organization_id IS NULL '||

Line 195: ' AND a3.resp_application_id = fnd_global.resp_appl_id '||

191: ' OR EXISTS ( SELECT NULL '||
192: ' FROM org_access a3 '||
193: ' WHERE a3.organization_id = sp.other_organization_id '||
194: ' AND NVL(a3.disable_date, SYSDATE+1) >= SYSDATE '||
195: ' AND a3.resp_application_id = fnd_global.resp_appl_id '||
196: ' AND a3.responsibility_id = fnd_global.resp_id '||
197: ' ) '||
198: ' OR NOT EXISTS ( SELECT NULL '||
199: ' FROM org_access a4 '||

Line 196: ' AND a3.responsibility_id = fnd_global.resp_id '||

192: ' FROM org_access a3 '||
193: ' WHERE a3.organization_id = sp.other_organization_id '||
194: ' AND NVL(a3.disable_date, SYSDATE+1) >= SYSDATE '||
195: ' AND a3.resp_application_id = fnd_global.resp_appl_id '||
196: ' AND a3.responsibility_id = fnd_global.resp_id '||
197: ' ) '||
198: ' OR NOT EXISTS ( SELECT NULL '||
199: ' FROM org_access a4 '||
200: ' WHERE a4.organization_id = sp.other_organization_id '||

Line 225: ' WHERE rg.user_id = fnd_global.user_id '||

221: ' WHERE sp.assign_method_ind = ''A'' '||
222: ' AND sp.access_type_ind = ''U'' '||
223: ' AND (responsibility_id IN ( SELECT rg.responsibility_id '||
224: ' FROM FND_USER_RESP_GROUPS rg '||
225: ' WHERE rg.user_id = fnd_global.user_id '||
226: ' AND SYSDATE BETWEEN rg.start_date AND NVL(rg.end_date, SYSDATE) '||
227: ' ) '||
228: ' OR ( sp.user_id = fnd_profile.value_specific(''GMD_DEFAULT_USER'') '||
229: ' OR sp.user_id = fnd_global.user_id '||

Line 229: ' OR sp.user_id = fnd_global.user_id '||

225: ' WHERE rg.user_id = fnd_global.user_id '||
226: ' AND SYSDATE BETWEEN rg.start_date AND NVL(rg.end_date, SYSDATE) '||
227: ' ) '||
228: ' OR ( sp.user_id = fnd_profile.value_specific(''GMD_DEFAULT_USER'') '||
229: ' OR sp.user_id = fnd_global.user_id '||
230: ' ) '||
231: ' ) '||
232: ' AND ( EXISTS ( SELECT NULL '||
233: ' FROM org_access a1 '||

Line 240: ' AND a1.resp_application_id = fnd_global.resp_appl_id '||

236: ' ) '||
237: ' OR sp.other_organization_id = a1.organization_id '||
238: ' ) '||
239: ' AND NVL(a1.disable_date, SYSDATE+1) >= SYSDATE '||
240: ' AND a1.resp_application_id = fnd_global.resp_appl_id '||
241: ' AND a1.responsibility_id = fnd_global.resp_id '||
242: ' ) '||
243: ' OR '||
244: ' NOT EXISTS ( SELECT NULL '||

Line 241: ' AND a1.responsibility_id = fnd_global.resp_id '||

237: ' OR sp.other_organization_id = a1.organization_id '||
238: ' ) '||
239: ' AND NVL(a1.disable_date, SYSDATE+1) >= SYSDATE '||
240: ' AND a1.resp_application_id = fnd_global.resp_appl_id '||
241: ' AND a1.responsibility_id = fnd_global.resp_id '||
242: ' ) '||
243: ' OR '||
244: ' NOT EXISTS ( SELECT NULL '||
245: ' FROM org_access a2 '||

Line 262: ' OR fs.user_id = fnd_global.user_id '||

258: ' ( SELECT 1 '||
259: ' FROM gmd_formula_security fs '||
260: ' WHERE fs.access_type_ind = ''U'' '||
261: ' AND ( ( fs.user_id = fnd_profile.value(''GMD_DEFAULT_USER'') '||
262: ' OR fs.user_id = fnd_global.user_id '||
263: ' ) '||
264: ' OR ( EXISTS ( SELECT rg.responsibility_id '||
265: ' FROM FND_USER_RESP_GROUPS rg '||
266: ' WHERE rg.user_id = fnd_global.user_id '||

Line 266: ' WHERE rg.user_id = fnd_global.user_id '||

262: ' OR fs.user_id = fnd_global.user_id '||
263: ' ) '||
264: ' OR ( EXISTS ( SELECT rg.responsibility_id '||
265: ' FROM FND_USER_RESP_GROUPS rg '||
266: ' WHERE rg.user_id = fnd_global.user_id '||
267: ' AND fs.responsibility_id = rg.responsibility_id '||
268: ' AND SYSDATE BETWEEN rg.start_date AND NVL(rg.end_date, SYSDATE) '||
269: ' ) '||
270: ' ) '||

Line 280: ' AND ou.resp_application_id = fnd_global.resp_appl_id '||

276: ' ) '||
277: ' OR fs.other_organization_id = ou.organization_id '||
278: ' ) '||
279: ' AND NVL(ou.disable_date, SYSDATE+1) >= SYSDATE '||
280: ' AND ou.resp_application_id = fnd_global.resp_appl_id '||
281: ' AND ou.responsibility_id = fnd_global.resp_id '||
282: ' ) '||
283: ' OR '||
284: ' NOT EXISTS ( SELECT NULL '||

Line 281: ' AND ou.responsibility_id = fnd_global.resp_id '||

277: ' OR fs.other_organization_id = ou.organization_id '||
278: ' ) '||
279: ' AND NVL(ou.disable_date, SYSDATE+1) >= SYSDATE '||
280: ' AND ou.resp_application_id = fnd_global.resp_appl_id '||
281: ' AND ou.responsibility_id = fnd_global.resp_id '||
282: ' ) '||
283: ' OR '||
284: ' NOT EXISTS ( SELECT NULL '||
285: ' FROM org_access ou1 '||