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.AMW_CONSTRAINT_PVT dependencies on AMW_CONSTRAINT_ENTRIES

Line 259: -- need to pass in amw_constraint_entries.group_code for each item

255: -- 12.21.2004 tsho: set default NULL for p_access_given_date, p_access_given_by
256: -- 12.21.2004 tsho: fix for performance bug 4036679
257: -- History
258: -- 05.24.2005 tsho: AMW.E Incompatible Sets,
259: -- need to pass in amw_constraint_entries.group_code for each item
260: -- ===============================================================
261: FUNCTION PROCESS_MENU_TREE_DOWN_FOR_CST(
262: p_constraint_rev_id in number,
263: p_menu_id in number,

Line 595: -- need to pass in amw_constraint_entries.group_code for each item

591: -- 12.21.2004 tsho: set default NULL for p_access_given_date, p_access_given_by
592: -- 12.21.2004 tsho: fix for performance bug 4036679
593: -- History
594: -- 05.24.2005 tsho: AMW.E Incompatible Sets,
595: -- need to pass in amw_constraint_entries.group_code for each item
596: -- ===============================================================
597: FUNCTION PROCESS_MENU_TREE_DOWN_FOR_MN(
598: p_menu_id in number,
599: p_function_id in number,

Line 1483: ||' AMW_CONSTRAINT_ENTRIES ce, '

1479: ||' usr.user_id, '
1480: ||' ce.group_code '
1481: ||' FROM '||G_AMW_GRANTS||' gra, '
1482: ||' '||G_AMW_COMPILED_MENU_FUNCTIONS||' cmf, '
1483: ||' AMW_CONSTRAINT_ENTRIES ce, '
1484: ||' '||G_AMW_USER_ROLE_ASSIGNMENTS||' urasgn, '
1485: ||' '||G_AMW_USER||' usr '
1486: ||' WHERE urasgn.user_name = usr.user_name '
1487: ||' AND (gra.grantee_orig_system = ''UMX'' OR gra.grantee_orig_system = ''FND_RESP'') '

Line 1514: ||' AMW_CONSTRAINT_ENTRIES ce, '

1510: ||' usr.user_id, '
1511: ||' ce.group_code '
1512: ||' FROM '||G_AMW_GRANTS||' gra, '
1513: ||' '||G_AMW_COMPILED_MENU_FUNCTIONS||' cmf, '
1514: ||' AMW_CONSTRAINT_ENTRIES ce, '
1515: ||' '||G_AMW_USER||' usr '
1516: ||' WHERE (( gra.GRANTEE_KEY = usr.user_name AND gra.GRANTEE_TYPE = ''USER'') '
1517: ||' OR (gra.GRANTEE_KEY = ''GLOBAL'' AND gra.GRANTEE_TYPE = ''GLOBAL'')) '
1518: ||' AND gra.menu_id = cmf.menu_id '

Line 1558: ||' AMW_CONSTRAINT_ENTRIES ce '

1554: ||' WF_LOCAL_ROLES rol, '
1555: ||' FND_APPLICATION_VL appl, '
1556: ||' '||G_AMW_RESPONSIBILITY||' resp, '
1557: ||' '||G_AMW_COMPILED_MENU_FUNCTIONS||' cmf, '
1558: ||' AMW_CONSTRAINT_ENTRIES ce '
1559: ||' WHERE ce.CONSTRAINT_REV_ID = :2 '
1560: ||' AND (ce.object_type is null OR ce.object_type = ''FUNC'') '
1561: ||' AND cmf.menu_id = resp.menu_id '
1562: ||' AND cmf.grant_flag = ''Y'' '

Line 1612: ||' AMW_CONSTRAINT_ENTRIES ACE '

1608: ||' WF_LOCAL_ROLES rol, '
1609: ||' FND_APPLICATION_VL appl, '
1610: ||' '||G_AMW_RESPONSIBILITY||' RESP, '
1611: ||' '||G_AMW_REQUEST_GROUP_UNITS||' RGU, '
1612: ||' AMW_CONSTRAINT_ENTRIES ACE '
1613: ||' WHERE ACE.CONSTRAINT_REV_ID=:4 '
1614: ||' AND ACE.OBJECT_TYPE=''CP'' '
1615: ||' AND RESP.GROUP_APPLICATION_ID IS NOT NULL '
1616: ||' AND RESP.REQUEST_GROUP_ID IS NOT NULL '

Line 1665: ||' AMW_CONSTRAINT_ENTRIES ce '

1661: ||' '||G_AMW_USER||' usr, '
1662: ||' WF_LOCAL_ROLES rol, '
1663: ||' FND_APPLICATION_VL appl, '
1664: ||' '||G_AMW_RESPONSIBILITY||' resp, '
1665: ||' AMW_CONSTRAINT_ENTRIES ce '
1666: ||' WHERE ce.CONSTRAINT_REV_ID = :1 '
1667: ||' AND ce.object_type = ''RESP'' '
1668: ||' AND ce.function_id = resp.responsibility_id '
1669: ||' AND ce.application_id = resp.application_id '

Line 2064: ||' FROM AMW_CONSTRAINT_ENTRIES constraintEntry '

2060: ||' FROM '||G_AMW_COMPILED_MENU_FUNCTIONS
2061: ||' WHERE grant_flag = ''Y'' '
2062: ||' AND function_id in ( '
2063: ||' SELECT constraintEntry.FUNCTION_ID '
2064: ||' FROM AMW_CONSTRAINT_ENTRIES constraintEntry '
2065: ||' WHERE constraintEntry.CONSTRAINT_REV_ID = :1 '
2066: ||' ) '
2067: ||' ) '
2068: ||' ) ';

Line 2079: ||' ,AMW_CONSTRAINT_ENTRIES ce '

2075: ||' SELECT ur.user_name '
2076: ||' FROM '||G_AMW_USER_ROLES||' ur '
2077: ||' ,'||G_AMW_RESPONSIBILITY||' resp '
2078: ||' ,'||G_AMW_COMPILED_MENU_FUNCTIONS||' cmf '
2079: ||' ,AMW_CONSTRAINT_ENTRIES ce '
2080: ||' WHERE ur.role_orig_system = ''FND_RESP'' '
2081: ||' AND ur.role_orig_system_id = resp.responsibility_id '
2082: ||' AND resp.menu_id = cmf.menu_id '
2083: ||' AND cmf.function_id = ce.function_id AND (ce.object_type is null OR ce.object_type = ''FUNC'') '

Line 2092: ||' ,AMW_CONSTRAINT_ENTRIES ce '

2088: ||' SELECT ur.user_name '
2089: ||' FROM '||G_AMW_USER_ROLES||' ur '
2090: ||' ,'||G_AMW_RESPONSIBILITY||' resp '
2091: ||' ,'||G_AMW_REQUEST_GROUP_UNITS||' rgu '
2092: ||' ,AMW_CONSTRAINT_ENTRIES ce '
2093: ||' WHERE ur.role_orig_system = ''FND_RESP'' '
2094: ||' AND ur.role_orig_system_id = resp.responsibility_id '
2095: ||' AND resp.request_group_id = rgu.request_group_id '
2096: ||' AND rgu.request_unit_type = ''P'' '

Line 2105: ||' ,AMW_CONSTRAINT_ENTRIES ce '

2101: ||' SELECT ur.user_name '
2102: ||' FROM '||G_AMW_USER_ROLES||' ur '
2103: ||' ,'||G_AMW_GRANTS||' gra '
2104: ||' ,'||G_AMW_COMPILED_MENU_FUNCTIONS||' cmf '
2105: ||' ,AMW_CONSTRAINT_ENTRIES ce '
2106: ||' WHERE (ur.role_orig_system = ''UMX'' OR ur.role_orig_system = ''FND_RESP'') '
2107: ||' AND ur.ROLE_NAME = gra.GRANTEE_KEY '
2108: ||' AND gra.INSTANCE_TYPE = ''GLOBAL'' '
2109: ||' AND gra.OBJECT_ID = -1 '

Line 2120: ||' ,AMW_CONSTRAINT_ENTRIES ce '

2116: ||' SELECT ur.user_name '
2117: ||' FROM '||G_AMW_USER_ROLES||' ur '
2118: ||' ,'||G_AMW_GRANTS||' gra '
2119: ||' ,'||G_AMW_COMPILED_MENU_FUNCTIONS||' cmf '
2120: ||' ,AMW_CONSTRAINT_ENTRIES ce '
2121: ||' WHERE ur.user_name = gra.GRANTEE_KEY '
2122: ||' AND gra.INSTANCE_TYPE = ''GLOBAL'' '
2123: ||' AND gra.OBJECT_ID = -1 '
2124: ||' AND gra.GRANTEE_TYPE = ''USER'' '

Line 2140: ||' FROM AMW_CONSTRAINT_ENTRIES constraintEntry '

2136: ||' AND ur.start_date <= sysdate AND (ur.end_date >= sysdate or ur.end_date is null) '
2137: ||' AND u.start_date <= sysdate AND (u.end_date >= sysdate or u.end_date is null) '
2138: ||' AND ur.responsibility_id in ( '
2139: ||' SELECT constraintEntry.FUNCTION_ID '
2140: ||' FROM AMW_CONSTRAINT_ENTRIES constraintEntry '
2141: ||' WHERE constraintEntry.CONSTRAINT_REV_ID = :1 '
2142: ||' ) ';
2143:
2144:

Line 2270: ||' AMW_CONSTRAINT_ENTRIES ce, '

2266: ||' usr.user_id ,'
2267: ||' ce.group_code '
2268: ||' FROM '||G_AMW_GRANTS||' gra, '
2269: ||' '||G_AMW_COMPILED_MENU_FUNCTIONS||' cmf, '
2270: ||' AMW_CONSTRAINT_ENTRIES ce, '
2271: ||' '||G_AMW_USER_ROLE_ASSIGNMENTS||' urasgn, '
2272: ||' '||G_AMW_USER||' usr, '
2273: ||' AMW_VIOLATION_USERS vu '
2274: ||' WHERE urasgn.user_name = usr.user_name '

Line 2304: ||' AMW_CONSTRAINT_ENTRIES ce, '

2300: ||' usr.user_id ,'
2301: ||' ce.group_code '
2302: ||' FROM '||G_AMW_GRANTS||' gra, '
2303: ||' '||G_AMW_COMPILED_MENU_FUNCTIONS||' cmf, '
2304: ||' AMW_CONSTRAINT_ENTRIES ce, '
2305: ||' '||G_AMW_USER||' usr , '
2306: ||' AMW_VIOLATION_USERS vu '
2307: ||' WHERE (( gra.GRANTEE_KEY = usr.user_name AND gra.GRANTEE_TYPE = ''USER'') '
2308: ||' OR (gra.GRANTEE_KEY = ''GLOBAL'' AND gra.GRANTEE_TYPE = ''GLOBAL'')) '

Line 2350: ||' AMW_CONSTRAINT_ENTRIES ce , '

2346: ||' WF_LOCAL_ROLES rol, '
2347: ||' FND_APPLICATION_VL appl, '
2348: ||' FND_RESPONSIBILITY resp, '
2349: ||' FND_COMPILED_MENU_FUNCTIONS cmf, '
2350: ||' AMW_CONSTRAINT_ENTRIES ce , '
2351: ||' AMW_VIOLATION_USERS vu '
2352: ||' WHERE ce.CONSTRAINT_REV_ID = :2 '
2353: ||' AND (ce.object_type is null OR ce.object_type = ''FUNC'') '
2354: ||' AND cmf.menu_id = resp.menu_id '

Line 2407: ||' AMW_CONSTRAINT_ENTRIES ACE , '

2403: ||' WF_LOCAL_ROLES rol, '
2404: ||' FND_APPLICATION_VL appl, '
2405: ||' FND_RESPONSIBILITY RESP, '
2406: ||' FND_REQUEST_GROUP_UNITS RGU, '
2407: ||' AMW_CONSTRAINT_ENTRIES ACE , '
2408: ||' AMW_VIOLATION_USERS vu '
2409: ||' WHERE ACE.CONSTRAINT_REV_ID=:5 '
2410: ||' AND ACE.OBJECT_TYPE=''CP'' '
2411: ||' AND RESP.GROUP_APPLICATION_ID IS NOT NULL '

Line 2461: ||' AMW_CONSTRAINT_ENTRIES ce , '

2457: ||' '||G_AMW_USER||' usr, '
2458: ||' WF_LOCAL_ROLES rol, '
2459: ||' FND_APPLICATION_VL appl, '
2460: ||' '||G_AMW_RESPONSIBILITY||' resp, '
2461: ||' AMW_CONSTRAINT_ENTRIES ce , '
2462: ||' AMW_VIOLATION_USERS vu '
2463: ||' WHERE ce.CONSTRAINT_REV_ID = :1 '
2464: ||' AND ce.object_type = ''RESP'' '
2465: ||' AND ce.function_id = resp.responsibility_id '

Line 3402: FROM amw_constraint_entries

3398: l_function_id_list NumberTable;
3399: l_constraint_function_id NUMBER;
3400: CURSOR c_constraint_entries (l_constraint_rev_id IN NUMBER) IS
3401: SELECT function_id
3402: FROM amw_constraint_entries
3403: WHERE constraint_rev_id=l_constraint_rev_id;
3404:
3405:
3406: -- find the responsibilities by specified user_id

Line 3686: FROM amw_constraint_entries

3682: l_function_id_list NumberTable;
3683: l_constraint_function_id NUMBER;
3684: CURSOR c_constraint_entries (l_constraint_rev_id IN NUMBER) IS
3685: SELECT function_id
3686: FROM amw_constraint_entries
3687: WHERE constraint_rev_id=l_constraint_rev_id;
3688:
3689:
3690: -- find the responsibilities by specified user_id

Line 3946: ||' FROM AMW_CONSTRAINT_ENTRIES ce, '

3942: ||' resp.application_id, '
3943: ||' resp.menu_id, '
3944: ||' ce.function_id, '
3945: ||' ce.group_code '
3946: ||' FROM AMW_CONSTRAINT_ENTRIES ce, '
3947: ||' '||G_AMW_COMPILED_MENU_FUNCTIONS||' cmf, '
3948: ||' '||G_AMW_RESPONSIBILITY||' resp '
3949: ||' WHERE ce.CONSTRAINT_REV_ID = :1 '
3950: ||' AND (ce.OBJECT_TYPE is null OR ce.OBJECT_TYPE = ''FUNC'') '

Line 4070: -- need to record amw_constraint_entries.group_code for each item

4066: -- Notes
4067: -- 12.21.2004 tsho: fix for performance bug 4036679
4068: -- History
4069: -- 05.24.2005 tsho: AMW.E Incompatible Sets,
4070: -- need to record amw_constraint_entries.group_code for each item
4071: -- 05.25.2005 tsho: consider Concurrent Programs as constraint entries
4072: -- ===============================================================
4073: Procedure Populate_Ptnl_Access_List (
4074: p_constraint_rev_id IN NUMBER

Line 4101: ||' AMW_CONSTRAINT_ENTRIES ACE '

4097: ||' RGU.CREATION_DATE ACCESS_GIVEN_DATE, '
4098: ||' RGU.CREATED_BY ACCESS_GIVEN_BY '
4099: ||' FROM '||G_AMW_RESPONSIBILITY||' RESP, '
4100: ||' '||G_AMW_REQUEST_GROUP_UNITS||' RGU, '
4101: ||' AMW_CONSTRAINT_ENTRIES ACE '
4102: ||' WHERE RESP.GROUP_APPLICATION_ID IS NOT NULL '
4103: ||' AND RESP.REQUEST_GROUP_ID IS NOT NULL '
4104: ||' AND RGU.REQUEST_UNIT_TYPE = ''P'' '
4105: ||' AND ACE.OBJECT_TYPE=''CP'' '

Line 4124: ||' AMW_CONSTRAINT_ENTRIES ACE, '

4120: ||' RGU.CREATION_DATE ACCESS_GIVEN_DATE, '
4121: ||' RGU.CREATED_BY ACCESS_GIVEN_BY '
4122: ||' FROM '||G_AMW_RESPONSIBILITY||' RESP , '
4123: ||' '||G_AMW_REQUEST_GROUP_UNITS||' RGU, '
4124: ||' AMW_CONSTRAINT_ENTRIES ACE, '
4125: ||' '||G_AMW_CONCURRENT_PROGRAMS_VL||' CON '
4126: ||' WHERE RESP.GROUP_APPLICATION_ID IS NOT NULL '
4127: ||' AND RESP.REQUEST_GROUP_ID IS NOT NULL '
4128: ||' AND RGU.REQUEST_UNIT_TYPE = ''A'' '

Line 4849: FROM amw_constraint_entries

4845: IS
4846:
4847: CURSOR c_constraint_entries (l_constraint_rev_id IN NUMBER) IS
4848: SELECT function_id,object_type,group_code
4849: FROM amw_constraint_entries
4850: WHERE constraint_rev_id=l_constraint_rev_id;
4851:
4852: CURSOR c_resp_violation_id IS
4853: SELECT AMW_VIOLATION_RESP_S.NEXTVAL

Line 5308: FROM amw_constraint_entries

5304: IS
5305:
5306: CURSOR c_constraint_entries (l_constraint_rev_id IN NUMBER) IS
5307: SELECT function_id,object_type,group_code
5308: FROM amw_constraint_entries
5309: WHERE constraint_rev_id=l_constraint_rev_id;
5310:
5311: CURSOR c_resp_violation_id IS
5312: SELECT AMW_VIOLATION_RESP_S.NEXTVAL

Line 5655: FROM amw_constraint_entries

5651: -- find the number of constraint entries(incompatible functions) by specified constraint_rev_id
5652: l_constraint_function_count NUMBER;
5653: CURSOR c_constraint_entries_count (l_constraint_rev_id IN NUMBER) IS
5654: SELECT count(*)
5655: FROM amw_constraint_entries
5656: WHERE constraint_rev_id=l_constraint_rev_id;
5657:
5658: CURSOR c_valid_user_waivers (l_constraint_rev_id IN NUMBER) IS
5659: SELECT PK1

Line 6165: FROM amw_constraint_entries

6161: -- find the number of constraint entries(incompatible responsibilities) by specified constraint_rev_id
6162: l_constraint_resp_count NUMBER;
6163: CURSOR c_constraint_entries_count (l_constraint_rev_id IN NUMBER) IS
6164: SELECT count(*)
6165: FROM amw_constraint_entries
6166: WHERE constraint_rev_id=l_constraint_rev_id;
6167:
6168: CURSOR c_valid_user_waivers (l_constraint_rev_id IN NUMBER) IS
6169: SELECT PK1