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.

[Home] [Help]

APPS.AMW_VIOLATION_PVT dependencies on AMW_ROLE_CONSTRAINT_DENORM

Line 385: ||' from amw_role_constraint_denorm rcd '

381: END IF;
382:
383: l_func_existing_sql :=
384: ' select rcd.function_id '
385: ||' from amw_role_constraint_denorm rcd '
386: ||' ,'||G_AMW_USER_ROLES||' ur '
387: ||' ,'||G_AMW_user||' u '
388: ||' ,'||G_AMW_USER_ROLE_ASSIGNMENTS_V || ' uar '
389: ||' where rcd.constraint_rev_id = :1 '

Line 403: ||' from amw_role_constraint_denorm rcd '

399: ||' and ur.role_orig_system = ''FND_RESP'' ) ) '
400: || l_sub_revoked_role_names
401: ||' UNION ALL '
402: ||' select rcd.function_id '
403: ||' from amw_role_constraint_denorm rcd '
404: ||' ,'||G_AMW_GRANTS||' gra '
405: ||' where rcd.constraint_rev_id = :3 '
406: ||' and gra.instance_type = ''GLOBAL'' and gra.menu_id = rcd.menu_id '
407: ||' and gra.object_id = -1 and ( gra.grantee_type = ''GLOBAL'' '

Line 414: ||' from amw_role_constraint_denorm rcd '

410:
411:
412: l_func_set_existing_sql :=
413: ' select rcd.group_code '
414: ||' from amw_role_constraint_denorm rcd '
415: ||' ,'||G_AMW_USER_ROLES||' ur '
416: ||' ,'||G_AMW_user||' u '
417: ||' ,'||G_AMW_USER_ROLE_ASSIGNMENTS_V || ' uar '
418: ||' where rcd.constraint_rev_id = :1 '

Line 432: ||' from amw_role_constraint_denorm rcd '

428: ||' and ur.role_orig_system = ''FND_RESP'' ) ) '
429: || l_sub_revoked_role_names
430: ||' UNION ALL '
431: ||' select rcd.group_code '
432: ||' from amw_role_constraint_denorm rcd '
433: ||' ,'||G_AMW_GRANTS||' gra '
434: ||' where rcd.constraint_rev_id = :3 '
435: ||' and gra.instance_type = ''GLOBAL'' and gra.menu_id = rcd.menu_id '
436: ||' and gra.object_id = -1 and ( gra.grantee_type = ''GLOBAL'' '

Line 517: ||' from amw_role_constraint_denorm rcd '

513: 'select count(distinct function_id) from ( '
514: || l_func_existing_sql
515: ||' UNION ALL '
516: ||' select rcd.function_id '
517: ||' from amw_role_constraint_denorm rcd '
518: ||' where rcd.constraint_rev_id = :5 '
519: ||' and rcd.role_name in ( '||l_sub_role_names||' ) '
520: ||') ';
521:

Line 527: ||' from amw_role_constraint_denorm rcd '

523: 'select count(distinct group_code) from ( '
524: || l_func_set_existing_sql
525: ||' UNION ALL '
526: ||' select rcd.group_code '
527: ||' from amw_role_constraint_denorm rcd '
528: ||' where rcd.constraint_rev_id = :5 '
529: ||' and rcd.role_name in ( '||l_sub_role_names||' ) '
530: ||') ';
531:

Line 610: ||' from amw_role_constraint_denorm rcd '

606: --add 5:15:06 by dliao
607: --check the new roles
608: l_cst_new_violation_sql :=
609: ' select count(rcd.function_id) '
610: ||' from amw_role_constraint_denorm rcd '
611: ||' where rcd.constraint_rev_id = :1 '
612: ||' and rcd.role_name in ( '||l_sub_role_names||' ) ' ;
613:
614:

Line 648: ||' from amw_role_constraint_denorm rcd '

644: ||'select distinct function_id from ( '
645: || l_func_existing_sql
646: ||' UNION ALL '
647: ||' select rcd.function_id '
648: ||' from amw_role_constraint_denorm rcd '
649: ||' where rcd.constraint_rev_id = :5 '
650: ||' and rcd.role_name in ( '||l_sub_role_names||' ) '
651: ||') '
652: ||' MINUS '

Line 711: ||' from amw_role_constraint_denorm rcd '

707:
708:
709: l_cst_new_violation_sql :=
710: ' select count(rcd.function_id) '
711: ||' from amw_role_constraint_denorm rcd '
712: ||' where rcd.constraint_rev_id = :1 '
713: ||' and rcd.role_name in ( '||l_sub_role_names||' ) ' ;
714:
715:

Line 789: ||' from amw_role_constraint_denorm rcd '

785: --IF l_group_access_count >= 1 THEN
786:
787: l_cst_new_violation_sql :=
788: ' select count( distinct rcd.group_code) '
789: ||' from amw_role_constraint_denorm rcd '
790: ||' where rcd.constraint_rev_id = :1 '
791: ||' and rcd.role_name in ( '||l_sub_role_names||' ) ' ;
792:
793: -- The cursor checks if the current constraint violation is related

Line 1304: ||' from amw_role_constraint_denorm rcd '

1300:
1301: l_func_dynamic_sql VARCHAR2(2500) :=
1302: 'select count(distinct function_id) from ( '
1303: ||' select rcd.function_id '
1304: ||' from amw_role_constraint_denorm rcd '
1305: ||' ,'||G_AMW_USER_ROLES||' ur '
1306: ||' ,'||G_AMW_user||' u '
1307: ||' where rcd.constraint_rev_id = :1 '
1308: ||' and u.user_id = :2 '

Line 1314: ||' from amw_role_constraint_denorm rcd '

1310: ||' and ur.role_name = rcd.role_name '
1311: ||' and ur.role_orig_system = ''UMX'' '
1312: ||' UNION ALL '
1313: ||' select rcd.function_id '
1314: ||' from amw_role_constraint_denorm rcd '
1315: ||' ,'||G_AMW_USER_ROLES||' ur '
1316: ||' ,'||G_AMW_user||' u '
1317: ||' where rcd.constraint_rev_id = :3 '
1318: ||' and u.user_id = :4 '

Line 1324: ||' from amw_role_constraint_denorm rcd '

1320: ||' and ur.role_orig_system_id = rcd.responsibility_id '
1321: ||' and ur.role_orig_system = ''FND_RESP'' '
1322: ||' UNION ALL '
1323: ||' select rcd.function_id '
1324: ||' from amw_role_constraint_denorm rcd '
1325: ||' ,'||G_AMW_GRANTS||' gra '
1326: ||' ,'||G_AMW_USER||' u '
1327: ||' where rcd.constraint_rev_id = :5 '
1328: ||' and u.user_id = :6 '

Line 1336: ||' from amw_role_constraint_denorm rcd '

1332: ||' and gra.instance_type = ''GLOBAL'' '
1333: ||' and gra.object_id = -1 '
1334: ||' UNION ALL '
1335: ||' select rcd.function_id '
1336: ||' from amw_role_constraint_denorm rcd '
1337: ||' ,'||G_AMW_GRANTS||' gra '
1338: ||' where rcd.constraint_rev_id = :7 '
1339: ||' and gra.grantee_key = ''GLOBAL'' '
1340: ||' and gra.grantee_type = ''GLOBAL'' '

Line 1346: ||' from amw_role_constraint_denorm rcd '

1342: ||' and gra.instance_type = ''GLOBAL'' '
1343: ||' and gra.object_id = -1 '
1344: ||' UNION ALL '
1345: ||' select rcd.function_id '
1346: ||' from amw_role_constraint_denorm rcd '
1347: ||' where rcd.constraint_rev_id = :8 '
1348: ||' and rcd.responsibility_id = :9 '
1349: ||') ';
1350:

Line 1354: ||' from amw_role_constraint_denorm rcd '

1350:
1351: l_func_set_dynamic_sql VARCHAR2(2500) :=
1352: 'select count(distinct group_code) from ( '
1353: ||' select rcd.group_code '
1354: ||' from amw_role_constraint_denorm rcd '
1355: ||' ,'||G_AMW_USER_ROLES||' ur '
1356: ||' ,'||G_AMW_user||' u '
1357: ||' where rcd.constraint_rev_id = :1 '
1358: ||' and u.user_id = :2 '

Line 1364: ||' from amw_role_constraint_denorm rcd '

1360: ||' and ur.role_name = rcd.role_name '
1361: ||' and ur.role_orig_system = ''UMX'' '
1362: ||' UNION ALL '
1363: ||' select rcd.group_code '
1364: ||' from amw_role_constraint_denorm rcd '
1365: ||' ,'||G_AMW_USER_ROLES||' ur '
1366: ||' ,'||G_AMW_user||' u '
1367: ||' where rcd.constraint_rev_id = :3 '
1368: ||' and u.user_id = :4 '

Line 1374: ||' from amw_role_constraint_denorm rcd '

1370: ||' and ur.role_orig_system_id = rcd.responsibility_id '
1371: ||' and ur.role_orig_system = ''FND_RESP'' '
1372: ||' UNION ALL '
1373: ||' select rcd.group_code '
1374: ||' from amw_role_constraint_denorm rcd '
1375: ||' ,'||G_AMW_GRANTS||' gra '
1376: ||' ,'||G_AMW_USER||' u '
1377: ||' where rcd.constraint_rev_id = :5 '
1378: ||' and u.user_id = :6 '

Line 1386: ||' from amw_role_constraint_denorm rcd '

1382: ||' and gra.instance_type = ''GLOBAL'' '
1383: ||' and gra.object_id = -1 '
1384: ||' UNION ALL '
1385: ||' select rcd.group_code '
1386: ||' from amw_role_constraint_denorm rcd '
1387: ||' ,'||G_AMW_GRANTS||' gra '
1388: ||' where rcd.constraint_rev_id = :7 '
1389: ||' and gra.grantee_key = ''GLOBAL'' '
1390: ||' and gra.grantee_type = ''GLOBAL'' '

Line 1396: ||' from amw_role_constraint_denorm rcd '

1392: ||' and gra.instance_type = ''GLOBAL'' '
1393: ||' and gra.object_id = -1 '
1394: ||' UNION ALL '
1395: ||' select rcd.group_code '
1396: ||' from amw_role_constraint_denorm rcd '
1397: ||' where rcd.constraint_rev_id = :8 '
1398: ||' and rcd.responsibility_id = :9 '
1399: ||') ';
1400:

Line 1912: -- populate AMW_ROLE_CONSTRAINT_DENORM table

1908: -- Procedure name
1909: -- Update_Role_Constraint_Denorm
1910: --
1911: -- Purpose
1912: -- populate AMW_ROLE_CONSTRAINT_DENORM table
1913: -- Params
1914: -- p_constraint_rev_id := input constraint_rev_id (Default is NULL)
1915: -- if p_constraint_rev_id is specified, only update/create
1916: -- the corresponding role/resp with that constraint.

Line 2047: -- delete all the records from amw_role_constraint_denorm

2043: ||' AND action_id = :4 ';
2044:
2045: BEGIN
2046: IF p_constraint_rev_id IS NULL THEN
2047: -- delete all the records from amw_role_constraint_denorm
2048: DELETE FROM AMW_ROLE_CONSTRAINT_DENORM;
2049:
2050: -- check all constraints
2051: OPEN c_all_valid_constraints;

Line 2048: DELETE FROM AMW_ROLE_CONSTRAINT_DENORM;

2044:
2045: BEGIN
2046: IF p_constraint_rev_id IS NULL THEN
2047: -- delete all the records from amw_role_constraint_denorm
2048: DELETE FROM AMW_ROLE_CONSTRAINT_DENORM;
2049:
2050: -- check all constraints
2051: OPEN c_all_valid_constraints;
2052: LOOP

Line 2081: INSERT INTO AMW_ROLE_CONSTRAINT_DENORM

2077: P_GROUP_CODE_LIST_HIER => G_GROUP_CODE_LIST);
2078:
2079: IF(G_FUNCTION_ID_LIST_HIER.COUNT > 0) THEN
2080: FORALL i IN 1 .. G_FUNCTION_ID_LIST_HIER.COUNT
2081: INSERT INTO AMW_ROLE_CONSTRAINT_DENORM
2082: VALUES(sysdate -- last_update_date
2083: ,G_USER_ID -- last_updated_by
2084: ,G_LOGIN_ID -- last_update_login
2085: ,sysdate -- creation_date

Line 2158: INSERT INTO AMW_ROLE_CONSTRAINT_DENORM

2154: -- populate non-exclusion function to defnorm table
2155: IF(G_FUNCTION_ID_LIST_HIER.COUNT > 0) THEN
2156: FORALL i IN 1 .. G_FUNCTION_ID_LIST_HIER.COUNT
2157:
2158: INSERT INTO AMW_ROLE_CONSTRAINT_DENORM
2159: VALUES(sysdate -- last_update_date
2160: ,G_USER_ID -- last_updated_by
2161: ,G_LOGIN_ID -- last_update_login
2162: ,sysdate -- creation_date

Line 2179: -- delete the records from amw_role_constraint_denorm for the specified constraint

2175:
2176: CLOSE c_all_valid_constraints;
2177: ELSE
2178: -- check specified constraint
2179: -- delete the records from amw_role_constraint_denorm for the specified constraint
2180: DELETE FROM AMW_ROLE_CONSTRAINT_DENORM
2181: WHERE constraint_rev_id = p_constraint_rev_id;
2182:
2183: -- clear global list for each constraint

Line 2180: DELETE FROM AMW_ROLE_CONSTRAINT_DENORM

2176: CLOSE c_all_valid_constraints;
2177: ELSE
2178: -- check specified constraint
2179: -- delete the records from amw_role_constraint_denorm for the specified constraint
2180: DELETE FROM AMW_ROLE_CONSTRAINT_DENORM
2181: WHERE constraint_rev_id = p_constraint_rev_id;
2182:
2183: -- clear global list for each constraint
2184: Clear_List();

Line 2208: INSERT INTO AMW_ROLE_CONSTRAINT_DENORM

2204: P_GROUP_CODE_LIST_HIER => G_GROUP_CODE_LIST);
2205:
2206: IF(G_FUNCTION_ID_LIST_HIER.COUNT > 0) THEN
2207: FORALL i IN 1 .. G_FUNCTION_ID_LIST_HIER.COUNT
2208: INSERT INTO AMW_ROLE_CONSTRAINT_DENORM
2209: VALUES(sysdate -- last_update_date
2210: ,G_USER_ID -- last_updated_by
2211: ,G_LOGIN_ID -- last_update_login
2212: ,sysdate -- creation_date

Line 2285: INSERT INTO AMW_ROLE_CONSTRAINT_DENORM

2281: -- populate non-exclusion function to defnorm table
2282: IF(G_FUNCTION_ID_LIST_HIER.COUNT > 0) THEN
2283: FORALL i IN 1 .. G_FUNCTION_ID_LIST_HIER.COUNT
2284:
2285: INSERT INTO AMW_ROLE_CONSTRAINT_DENORM
2286: VALUES(sysdate -- last_update_date
2287: ,G_USER_ID -- last_updated_by
2288: ,G_LOGIN_ID -- last_update_login
2289: ,sysdate -- creation_date

Line 2357: ||' from amw_role_constraint_denorm rcd '

2353:
2354: -- find new roles this user has (results in violating the specified constraint)
2355: l_new_role_dynamic_sql VARCHAR2(500) :=
2356: 'select distinct rv.display_name '
2357: ||' from amw_role_constraint_denorm rcd '
2358: ||' ,'||G_AMW_ALL_ROLES_VL||' rv '
2359: ||' where rcd.constraint_rev_id = :1 '
2360: ||' and (rcd.role_name = rv.name or (rv.orig_system = ''FND_RESP'' and rcd.responsibility_id = rv.orig_system_id ) ) '
2361: ||' and rv.name in (:2) ';

Line 2467: ||' from amw_role_constraint_denorm rcd '

2463:
2464: -- find existing roles this user has (results in violating the specified constraint)
2465: l_existing_role_dynamic_sql VARCHAR2(500) :=
2466: 'select distinct rv.display_name '
2467: ||' from amw_role_constraint_denorm rcd '
2468: ||' ,'||G_AMW_USER_ROLES||' ur '
2469: ||' ,'||G_AMW_user||' u '
2470: ||' ,'||G_AMW_ALL_ROLES_VL||' rv '
2471: ||' where rcd.constraint_rev_id = :1 '

Line 2546: ||' from amw_role_constraint_denorm rcd '

2542:
2543: -- find existing responsibilities this user has (results in violating the specified constraint)
2544: l_existing_resp_dynamic_sql VARCHAR2(500) :=
2545: 'select distinct resp.responsibility_name '
2546: ||' from amw_role_constraint_denorm rcd '
2547: ||' ,'||G_AMW_USER_ROLES||' ur '
2548: ||' ,'||G_AMW_user||' u '
2549: ||' ,'||G_AMW_RESPONSIBILITY_VL||' resp '
2550: ||' where rcd.constraint_rev_id = :1 '

Line 2625: ||' from amw_role_constraint_denorm rcd '

2621:
2622: -- find existing menus this user has (results in violating the specified constraint)
2623: l_existing_menu_dynamic_sql VARCHAR2(1500) :=
2624: ' select menu.user_menu_name '
2625: ||' from amw_role_constraint_denorm rcd '
2626: ||' ,'||G_AMW_MENUS_VL||' menu '
2627: ||' ,'||G_AMW_user||' u '
2628: ||' ,'||G_AMW_GRANTS||' gra '
2629: ||' where rcd.constraint_rev_id = :1 '

Line 2639: ||' from amw_role_constraint_denorm rcd '

2635: ||' and gra.menu_id = rcd.menu_id '
2636: ||' and gra.menu_id = menu.menu_id '
2637: ||' UNION '
2638: ||' select menu.user_menu_name '
2639: ||' from amw_role_constraint_denorm rcd '
2640: ||' ,'||G_AMW_MENUS_VL||' menu '
2641: ||' ,'||G_AMW_GRANTS||' gra '
2642: ||' where rcd.constraint_rev_id = :3 '
2643: ||' and gra.grantee_key = ''GLOBAL'' '

Line 2863: ||' from amw_role_constraint_denorm rcd '

2859: ||' and (select count(*) '
2860: ||' from amw_constraint_entries ce '
2861: ||' where ce.constraint_rev_id = cst.constraint_rev_id) = ( '
2862: ||' select count(distinct rcd.function_id) '
2863: ||' from amw_role_constraint_denorm rcd '
2864: ||' where rcd.constraint_rev_id = cst.constraint_rev_id '
2865: ||' and ( rcd.role_name = :3 '
2866: ||' or (rcd.role_name in ( '
2867: ||' select ur.role_name '

Line 2910: ||' from amw_role_constraint_denorm rcd '

2906: ||' from amw_constraints_b cst '
2907: ||' where cst.type_code = ''ME'' '
2908: ||' and cst.start_date <= sysdate AND (cst.end_date IS NULL OR cst.end_date >= sysdate) '
2909: ||' and (select count(distinct rcd.function_id) '
2910: ||' from amw_role_constraint_denorm rcd '
2911: ||' where rcd.constraint_rev_id = cst.constraint_rev_id '
2912: ||' and ( rcd.role_name = :9 '
2913: ||' or (rcd.role_name in ( '
2914: ||' select ur.role_name '

Line 2957: ||' from amw_role_constraint_denorm rcd '

2953: ||' from amw_constraints_b cst '
2954: ||' where cst.type_code = ''SET'' '
2955: ||' and cst.start_date <= sysdate AND (cst.end_date IS NULL OR cst.end_date >= sysdate) '
2956: ||' and (select count(distinct rcd.group_code) '
2957: ||' from amw_role_constraint_denorm rcd '
2958: ||' where rcd.constraint_rev_id = cst.constraint_rev_id '
2959: ||' and (rcd.role_name = :15 '
2960: ||' or (rcd.role_name in ( '
2961: ||' select ur.role_name '

Line 3426: ||' from amw_role_constraint_denorm rcd '

3422:
3423: l_func_dynamic_sql VARCHAR2(2500) :=
3424: 'select count(distinct function_id) from ( '
3425: ||' select rcd.function_id '
3426: ||' from amw_role_constraint_denorm rcd '
3427: ||' ,'||G_AMW_USER_ROLES||' ur '
3428: ||' ,'||G_AMW_user||' u '
3429: ||' where rcd.constraint_rev_id = :1 '
3430: ||' and u.user_id = :2 '

Line 3436: ||' from amw_role_constraint_denorm rcd '

3432: ||' and ur.role_name = rcd.role_name '
3433: ||' and ur.role_orig_system = ''UMX'' '
3434: ||' UNION ALL '
3435: ||' select rcd.function_id '
3436: ||' from amw_role_constraint_denorm rcd '
3437: ||' ,'||G_AMW_USER_ROLES||' ur '
3438: ||' ,'||G_AMW_user||' u '
3439: ||' where rcd.constraint_rev_id = :3 '
3440: ||' and u.user_id = :4 '

Line 3446: ||' from amw_role_constraint_denorm rcd '

3442: ||' and ur.role_orig_system_id = rcd.responsibility_id '
3443: ||' and ur.role_orig_system = ''FND_RESP'' '
3444: ||' UNION ALL '
3445: ||' select rcd.function_id '
3446: ||' from amw_role_constraint_denorm rcd '
3447: ||' ,'||G_AMW_GRANTS||' gra '
3448: ||' ,'||G_AMW_USER||' u '
3449: ||' where rcd.constraint_rev_id = :5 '
3450: ||' and u.user_id = :6 '

Line 3458: ||' from amw_role_constraint_denorm rcd '

3454: ||' and gra.instance_type = ''GLOBAL'' '
3455: ||' and gra.object_id = -1 '
3456: ||' UNION ALL '
3457: ||' select rcd.function_id '
3458: ||' from amw_role_constraint_denorm rcd '
3459: ||' ,'||G_AMW_GRANTS||' gra '
3460: ||' where rcd.constraint_rev_id = :7 '
3461: ||' and gra.grantee_key = ''GLOBAL'' '
3462: ||' and gra.grantee_type = ''GLOBAL'' '

Line 3468: ||' from amw_role_constraint_denorm rcd '

3464: ||' and gra.instance_type = ''GLOBAL'' '
3465: ||' and gra.object_id = -1 '
3466: ||' UNION ALL '
3467: ||' select rcd.function_id '
3468: ||' from amw_role_constraint_denorm rcd '
3469: ||' where rcd.constraint_rev_id = :8 '
3470: ||' and rcd.responsibility_id = :9 '
3471: ||') ';
3472:

Line 3476: ||' from amw_role_constraint_denorm rcd '

3472:
3473: l_func_set_dynamic_sql VARCHAR2(2500) :=
3474: 'select count(distinct group_code) from ( '
3475: ||' select rcd.group_code '
3476: ||' from amw_role_constraint_denorm rcd '
3477: ||' ,'||G_AMW_USER_ROLES||' ur '
3478: ||' ,'||G_AMW_user||' u '
3479: ||' where rcd.constraint_rev_id = :1 '
3480: ||' and u.user_id = :2 '

Line 3486: ||' from amw_role_constraint_denorm rcd '

3482: ||' and ur.role_name = rcd.role_name '
3483: ||' and ur.role_orig_system = ''UMX'' '
3484: ||' UNION ALL '
3485: ||' select rcd.group_code '
3486: ||' from amw_role_constraint_denorm rcd '
3487: ||' ,'||G_AMW_USER_ROLES||' ur '
3488: ||' ,'||G_AMW_user||' u '
3489: ||' where rcd.constraint_rev_id = :3 '
3490: ||' and u.user_id = :4 '

Line 3496: ||' from amw_role_constraint_denorm rcd '

3492: ||' and ur.role_orig_system_id = rcd.responsibility_id '
3493: ||' and ur.role_orig_system = ''FND_RESP'' '
3494: ||' UNION ALL '
3495: ||' select rcd.group_code '
3496: ||' from amw_role_constraint_denorm rcd '
3497: ||' ,'||G_AMW_GRANTS||' gra '
3498: ||' ,'||G_AMW_USER||' u '
3499: ||' where rcd.constraint_rev_id = :5 '
3500: ||' and u.user_id = :6 '

Line 3508: ||' from amw_role_constraint_denorm rcd '

3504: ||' and gra.instance_type = ''GLOBAL'' '
3505: ||' and gra.object_id = -1 '
3506: ||' UNION ALL '
3507: ||' select rcd.group_code '
3508: ||' from amw_role_constraint_denorm rcd '
3509: ||' ,'||G_AMW_GRANTS||' gra '
3510: ||' where rcd.constraint_rev_id = :7 '
3511: ||' and gra.grantee_key = ''GLOBAL'' '
3512: ||' and gra.grantee_type = ''GLOBAL'' '

Line 3518: ||' from amw_role_constraint_denorm rcd '

3514: ||' and gra.instance_type = ''GLOBAL'' '
3515: ||' and gra.object_id = -1 '
3516: ||' UNION ALL '
3517: ||' select rcd.group_code '
3518: ||' from amw_role_constraint_denorm rcd '
3519: ||' where rcd.constraint_rev_id = :8 '
3520: ||' and rcd.responsibility_id = :9 '
3521: ||') ';
3522:

Line 3527: ||' from amw_role_constraint_denorm rcd '

3523: -- get the name of the new respsonsibility which this user intends to have
3524: new_resp_c refCurTyp;
3525: l_new_resp_dynamic_sql VARCHAR2(500) :=
3526: 'select resp.responsibility_name '
3527: ||' from amw_role_constraint_denorm rcd '
3528: ||' ,'||G_AMW_RESPONSIBILITY_VL||' resp '
3529: ||' where rcd.constraint_rev_id = :1 and resp.responsibility_id = :2 '
3530: ||' and rcd.responsibility_id = resp.responsibility_id ';
3531: