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.FND_DATA_SECURITY dependencies on WF_USER_ROLES

Line 166: from wf_user_roles

162: null;
163: else
164: select 1
165: into l_dummy
166: from wf_user_roles
167: where user_name = p_user_name
168: and rownum = 1;
169: end if;
170:

Line 737: from wf_user_roles wur,

733: FROM
734: ( select /*+ NO_MERGE */ 'GLOBAL' role_name from dual
735: union all
736: select role_name
737: from wf_user_roles wur,
738: (
739: select cp_user_name name from dual
740: union all
741: select incr1.name name

Line 797: from wf_user_roles wur

793: and g.grantee_key = cp_user_name)
794: OR (g.grantee_type = 'GROUP'
795: and (g.grantee_key in
796: (select role_name
797: from wf_user_roles wur
798: where wur.user_name in
799: ( (select cp_user_name from dual)
800: union all
801: (select incrns.name from wf_local_roles incrns, fnd_user f

Line 840: from wf_user_roles wur,

836: IS
837: SELECT /*+ leading(u2) use_nl(g) index(g,FND_GRANTS_N9) */ 'X'
838: FROM
839: ( select /*+ NO_MERGE */ role_name
840: from wf_user_roles wur,
841: (
842: select cp_user_name name from dual
843: union all
844: select incr1.name name

Line 2170: from wf_user_roles wur,

2166: FROM
2167: ( select /*+ NO_MERGE */ 'GLOBAL' role_name from dual
2168: union all
2169: select role_name
2170: from wf_user_roles wur,
2171: (
2172: select cp_user_name name from dual
2173: union all
2174: select incr1.name name

Line 2228: from wf_user_roles wur

2224: AND g.grantee_key = cp_user_name)
2225: OR ( g.grantee_type = 'GROUP'
2226: AND (g.grantee_key in
2227: (select role_name
2228: from wf_user_roles wur
2229: where wur.user_name in
2230: ( (select cp_user_name from dual)
2231: union all
2232: (select incrns.name from wf_local_roles incrns, fnd_user f

Line 2266: from wf_user_roles wur,

2262: UNIQUE
2263: instance_sets.predicate, instance_sets.instance_set_id
2264: FROM
2265: ( select /*+ NO_MERGE */ role_name
2266: from wf_user_roles wur,
2267: (
2268: select cp_user_name name from dual
2269: union all
2270: select incr1.name name

Line 2445: 'in wf_user_roles. '||

2441: fnd_message.set_token('ROUTINE',
2442: c_pkg_name || '.'|| l_api_name);
2443: fnd_message.set_token('REASON',
2444: 'The user_name passed or defaulted is not a valid user_name '||
2445: 'in wf_user_roles. '||
2446: 'Invalid user_name: '||l_user_name ||
2447: ' Passed p_user_name: '||p_user_name);
2448: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
2449: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

Line 2719: ' from wf_user_roles wur '||

2715: ' OR (GNT.grantee_type = ''GROUP'' '||
2716: ' AND GNT.grantee_key in ';
2717: l_aggregate_predicate := l_aggregate_predicate ||
2718: ' (select role_name '||
2719: ' from wf_user_roles wur '||
2720: ' where wur.user_name in '||
2721: ' ( (select '||
2722: ' '''||replace(l_user_name,'''','''''')||''' '||
2723: ' from dual) '||

Line 2738: ' from wf_user_roles wur, '||

2734: l_aggregate_predicate ||
2735: ' GNT.object_id = ' || l_object_id ||
2736: ' AND (GNT.grantee_key in '||
2737: ' (select role_name '||
2738: ' from wf_user_roles wur, '||
2739: ' ( select '||
2740: ' '''||replace(l_user_name,'''','''''')||''' '||
2741: ' name from dual '||
2742: ' union all '||

Line 3246: from wf_user_roles wur

3242: AND g.grantee_key = cp_user_name)
3243: OR (g.grantee_type = 'GROUP'
3244: AND (g.grantee_key in
3245: (select role_name
3246: from wf_user_roles wur
3247: where wur.user_name in
3248: ( (select cp_user_name from dual)
3249: union all
3250: (select incrns.name from wf_local_roles incrns, fnd_user f

Line 3290: from wf_user_roles wur,

3286: (
3287: SELECT /*+ leading(u2) use_nl(g) index(g,FND_GRANTS_N9) */ 'X'
3288: FROM
3289: ( select /*+ NO_MERGE */ role_name
3290: from wf_user_roles wur,
3291: (
3292: select cp_user_name name from dual
3293: union all
3294: select incr1.name name

Line 3349: from wf_user_roles wur,

3345: FROM
3346: ( select /*+ NO_MERGE */ 'GLOBAL' role_name from dual
3347: union all
3348: select role_name
3349: from wf_user_roles wur,
3350: (
3351: select cp_user_name name from dual
3352: union all
3353: select incr1.name name

Line 3398: from wf_user_roles wur,

3394: FROM
3395: ( select /*+ NO_MERGE */ 'GLOBAL' role_name from dual
3396: union all
3397: select role_name
3398: from wf_user_roles wur,
3399: (
3400: select cp_user_name name from dual
3401: union all
3402: select incr1.name name

Line 3451: from wf_user_roles wur

3447: AND g.grantee_key = cp_user_name)
3448: OR (g.grantee_type = 'GROUP'
3449: AND (g.grantee_key in
3450: (select role_name
3451: from wf_user_roles wur
3452: where wur.user_name in
3453: ( (select cp_user_name from dual)
3454: union all
3455: (select incrns.name from wf_local_roles incrns, fnd_user f

Line 3487: from wf_user_roles wur,

3483: instance_sets.predicate, instance_sets.instance_set_id,
3484: g.grant_guid
3485: FROM
3486: ( select /*+ NO_MERGE */ role_name
3487: from wf_user_roles wur,
3488: (
3489: select cp_user_name name from dual
3490: union all
3491: select incr1.name name

Line 3545: from wf_user_roles wur

3541: AND g.grantee_key = cp_user_name)
3542: OR ( g.grantee_type = 'GROUP'
3543: AND (g.grantee_key in
3544: (select role_name
3545: from wf_user_roles wur
3546: where wur.user_name in
3547: ( (select cp_user_name from dual)
3548: union all
3549: (select incrns.name from wf_local_roles incrns, fnd_user f

Line 3584: from wf_user_roles wur,

3580: instance_sets.predicate, instance_sets.instance_set_id,
3581: g.grant_guid
3582: FROM
3583: ( select /*+ NO_MERGE */ role_name
3584: from wf_user_roles wur,
3585: (
3586: select cp_user_name name from dual
3587: union all
3588: select incr1.name name

Line 3635: from wf_user_roles wur

3631: AND g.grantee_key = cp_user_name)
3632: OR (g.grantee_type = 'GROUP'
3633: AND (g.grantee_key in
3634: (select role_name
3635: from wf_user_roles wur
3636: where wur.user_name in
3637: ( (select cp_user_name from dual)
3638: union all
3639: (select incrns.name from wf_local_roles incrns, fnd_user f

Line 3931: from wf_user_roles wur,

3927: SELECT Max(LAST_UPDATE_DATE)
3928: INTO l_last_update_date
3929: from ( select /*+ NO_MERGE */ 'GLOBAL' role_name from dual union all
3930: select role_name
3931: from wf_user_roles wur,
3932: (
3933: select l_user_name name from dual
3934: union all
3935: select incr1.name name

Line 4053: 'in wf_user_roles. '||

4049: fnd_message.set_token('ROUTINE',
4050: c_pkg_name || '.'|| l_api_name);
4051: fnd_message.set_token('REASON',
4052: 'The user_name passed or defaulted is not a valid user_name '||
4053: 'in wf_user_roles. '||
4054: 'Invalid user_name: '||l_user_name ||
4055: ' Passed p_user_name: '||p_user_name);
4056: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
4057: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

Line 4160: -- a group in WF_USER_ROLES then we could go down to only 3 SQL

4156: -- We had originally tried to check all these possibilities with
4157: -- a single statement, but it didn't perform adequately due to
4158: -- the ORs and sorting necessary, so this is the best solution.
4159: -- Perhaps if we get the WF folks to put GLOBAL (all) users into the
4160: -- a group in WF_USER_ROLES then we could go down to only 3 SQL
4161: -- or even one.
4162:
4163: --
4164: -- Do not check for GLOBAL grants when the user is GUEST

Line 5057: ' from wf_user_roles wur '||

5053: ' AND GNT.grantee_key = '|| l_user_name_bind||') '||
5054: ' OR ( GNT.grantee_type = ''GROUP'' '||
5055: ' AND GNT.grantee_key in ' ||
5056: ' (select role_name '||
5057: ' from wf_user_roles wur '||
5058: ' where wur.user_name in '||
5059: ' ( (select '||l_user_name_bind ||' from dual) '||
5060: ' union all '||
5061: ' (select incrns.name from wf_local_roles incrns, '||

Line 5078: ' from wf_user_roles wur, '||

5074:
5075: l_instance_predicate := l_instance_predicate ||
5076: ' (GNT.grantee_key in '||
5077: ' (select role_name '||
5078: ' from wf_user_roles wur, '||
5079: ' ( select '||l_user_name_bind ||' name from dual '||
5080: ' union all '||
5081: ' (select incrns.name from wf_local_roles incrns, '||
5082: ' fnd_user f '||

Line 6214: from wf_user_roles wur,

6210: from (select /*+ no_merge */ distinct g.menu_id, g.ctx_secgrp_id, g.ctx_resp_id, g.ctx_resp_appl_id from
6211: ( select /*+ NO_MERGE */ 'GLOBAL' role_name from dual
6212: union all
6213: select role_name
6214: from wf_user_roles wur,
6215: (
6216: select L_USER_NAME name from dual
6217: union all
6218: select incr1.name name