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 165: from wf_user_roles

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

Line 736: from wf_user_roles wur,

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

Line 796: from wf_user_roles wur

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

Line 839: from wf_user_roles wur,

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

Line 2169: from wf_user_roles wur,

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

Line 2227: from wf_user_roles wur

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

Line 2265: from wf_user_roles wur,

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

Line 2444: 'in wf_user_roles. '||

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

Line 2718: ' from wf_user_roles wur '||

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

Line 2737: ' from wf_user_roles wur, '||

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

Line 3244: from wf_user_roles wur

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

Line 3288: from wf_user_roles wur,

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

Line 3347: from wf_user_roles wur,

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

Line 3396: from wf_user_roles wur,

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

Line 3449: from wf_user_roles wur

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

Line 3485: from wf_user_roles wur,

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

Line 3543: from wf_user_roles wur

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

Line 3582: from wf_user_roles wur,

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

Line 3633: from wf_user_roles wur

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

Line 3958: 'in wf_user_roles. '||

3954: fnd_message.set_token('ROUTINE',
3955: c_pkg_name || '.'|| l_api_name);
3956: fnd_message.set_token('REASON',
3957: 'The user_name passed or defaulted is not a valid user_name '||
3958: 'in wf_user_roles. '||
3959: 'Invalid user_name: '||l_user_name ||
3960: ' Passed p_user_name: '||p_user_name);
3961: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3962: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

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

4116: -- We had originally tried to check all these possibilities with
4117: -- a single statement, but it didn't perform adequately due to
4118: -- the ORs and sorting necessary, so this is the best solution.
4119: -- Perhaps if we get the WF folks to put GLOBAL (all) users into the
4120: -- a group in WF_USER_ROLES then we could go down to only 3 SQL
4121: -- or even one.
4122:
4123: --
4124: -- Do not check for GLOBAL grants when the user is GUEST

Line 5017: ' from wf_user_roles wur '||

5013: ' AND GNT.grantee_key = '|| l_user_name_bind||') '||
5014: ' OR ( GNT.grantee_type = ''GROUP'' '||
5015: ' AND GNT.grantee_key in ' ||
5016: ' (select role_name '||
5017: ' from wf_user_roles wur '||
5018: ' where wur.user_name in '||
5019: ' ( (select '||l_user_name_bind ||' from dual) '||
5020: ' union all '||
5021: ' (select incrns.name from wf_local_roles incrns, '||

Line 5038: ' from wf_user_roles wur, '||

5034:
5035: l_instance_predicate := l_instance_predicate ||
5036: ' (GNT.grantee_key in '||
5037: ' (select role_name '||
5038: ' from wf_user_roles wur, '||
5039: ' ( select '||l_user_name_bind ||' name from dual '||
5040: ' union all '||
5041: ' (select incrns.name from wf_local_roles incrns, '||
5042: ' fnd_user f '||