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_VIOLATION_PUB dependencies on AMW_CONSTRAINT_ENTRIES

Line 203: FROM amw_constraint_entries

199:
200:
201: CURSOR c_constraint_entries_count (l_constraint_rev_id IN NUMBER) IS
202: SELECT count(*)
203: FROM amw_constraint_entries
204: WHERE constraint_rev_id=l_constraint_rev_id;
205:
206: TYPE refCurTyp IS REF CURSOR;
207: func_acess_count_c refCurTyp;

Line 336: ||' ,amw_constraint_entries cst '

332: ' select ur.role_orig_system_id '
333: ||' from '
334: || G_AMW_USER_ROLES||' ur '
335: ||' ,'||G_AMW_user||' u '
336: ||' ,amw_constraint_entries cst '
337: ||' where u.user_id = :1 '
338: ||' and cst.constraint_rev_id = :2 '
339: ||' and u.user_name = ur.user_name '
340: ||' and ur.role_orig_system_id = cst.function_id '

Line 344: ||' from amw_constraint_entries cst '

340: ||' and ur.role_orig_system_id = cst.function_id '
341: ||' and ur.role_orig_system = ''FND_RESP'' '
342: ||' UNION '
343: ||' select cst.function_id as orig_system_id '
344: ||' from amw_constraint_entries cst '
345: ||' where cst.constraint_rev_id = :3 '
346: ||' and cst.function_id = :4 ';
347:
348:

Line 360: ||' ,amw_constraint_entries cst '

356: ' select cst.group_code '
357: ||' from '
358: || G_AMW_USER_ROLES||' ur '
359: ||' ,'||G_AMW_user||' u '
360: ||' ,amw_constraint_entries cst '
361: ||' where u.user_id = :1 '
362: ||' and cst.constraint_rev_id = :2 '
363: ||' and u.user_name = ur.user_name '
364: ||' and ur.role_orig_system_id = cst.function_id '

Line 368: ||' from amw_constraint_entries cst '

364: ||' and ur.role_orig_system_id = cst.function_id '
365: ||' and ur.role_orig_system = ''FND_RESP'' '
366: ||' UNION '
367: ||' select cst.group_code '
368: ||' from amw_constraint_entries cst '
369: ||' where cst.constraint_rev_id = :3 '
370: ||' and cst.function_id = :4 ';
371:
372: l_resp_set_dynamic_sql VARCHAR2(32767) :=

Line 449: ||' select FUNCTION_ID from amw_constraint_entries where constraint_rev_id = :10'

445: ||'select function_id from ( '
446: || l_func_id_sql
447: ||') '
448: ||' MINUS '
449: ||' select FUNCTION_ID from amw_constraint_entries where constraint_rev_id = :10'
450: ||')';
451:
452:
453:

Line 549: ||' select FUNCTION_ID from amw_constraint_entries where constraint_rev_id = :5'

545: l_resp_sql := 'select count(distinct role_orig_system_id)'
546: ||' from ('
547: || l_resp_all_sql
548: ||' MINUS '
549: ||' select FUNCTION_ID from amw_constraint_entries where constraint_rev_id = :5'
550: ||')';
551:
552:
553: OPEN resp_acess_count_c FOR l_resp_sql USING

Line 712: FROM amw_constraint_entries

708: l_func_access_count NUMBER;
709: l_group_access_count NUMBER;
710: CURSOR c_constraint_entries_count (l_constraint_rev_id IN NUMBER) IS
711: SELECT count(*)
712: FROM amw_constraint_entries
713: WHERE constraint_rev_id=l_constraint_rev_id;
714:
715:
716: TYPE refCurTyp IS REF CURSOR;

Line 825: ||' from amw_constraint_entries rcd '

821: -- get the name of the new respsonsibility which this user intends to have
822: new_resp_c refCurTyp;
823: l_new_resp_dynamic_sql VARCHAR2(500) :=
824: 'select resp.responsibility_name '
825: ||' from amw_constraint_entries rcd '
826: ||' ,'||G_AMW_RESPONSIBILITY_VL||' resp '
827: ||' where rcd.constraint_rev_id = :1 and resp.responsibility_id = :2 '
828: ||' and rcd.function_id = resp.responsibility_id ';
829:

Line 833: ||' from amw_constraint_entries rcd '

829:
830: new_func_c refCurTyp;
831: l_new_func_dynamic_sql VARCHAR2(500) :=
832: 'select func.user_function_name '
833: ||' from amw_constraint_entries rcd '
834: ||' ,'|| G_AMW_FORM_FUNCTIONS_VL ||' func '
835: ||' where rcd.constraint_rev_id = :1 '
836: ||' and rcd.function_id = func.function_id ';
837:

Line 857: ||' ,amw_constraint_entries cst '

853: ' select ur.role_orig_system_id '
854: ||' from '
855: || G_AMW_USER_ROLES||' ur '
856: ||' ,'||G_AMW_user||' u '
857: ||' ,amw_constraint_entries cst '
858: ||' where u.user_id = :1 '
859: ||' and cst.constraint_rev_id = :2 '
860: ||' and u.user_name = ur.user_name '
861: ||' and ur.role_orig_system_id = cst.function_id '

Line 865: ||' from amw_constraint_entries cst '

861: ||' and ur.role_orig_system_id = cst.function_id '
862: ||' and ur.role_orig_system = ''FND_RESP'' '
863: ||' UNION '
864: ||' select cst.function_id as orig_system_id '
865: ||' from amw_constraint_entries cst '
866: ||' where cst.constraint_rev_id = :3 '
867: ||' and cst.function_id = :4 ';
868:
869:

Line 881: ||' ,amw_constraint_entries cst '

877: ' select cst.group_code '
878: ||' from '
879: || G_AMW_USER_ROLES||' ur '
880: ||' ,'||G_AMW_user||' u '
881: ||' ,amw_constraint_entries cst '
882: ||' where u.user_id = :1 '
883: ||' and cst.constraint_rev_id = :2 '
884: ||' and u.user_name = ur.user_name '
885: ||' and ur.role_orig_system_id = cst.function_id '

Line 889: ||' from amw_constraint_entries cst '

885: ||' and ur.role_orig_system_id = cst.function_id '
886: ||' and ur.role_orig_system = ''FND_RESP'' '
887: ||' UNION '
888: ||' select cst.group_code '
889: ||' from amw_constraint_entries cst '
890: ||' where cst.constraint_rev_id = :3 '
891: ||' and cst.function_id = :4 ';
892:
893: l_resp_set_dynamic_sql VARCHAR2(32767) :=

Line 1165: ||' select FUNCTION_ID from amw_constraint_entries where constraint_rev_id = :5'

1161: l_resp_sql := 'select count(distinct role_orig_system_id)'
1162: ||' from ('
1163: || l_resp_all_sql
1164: ||' MINUS '
1165: ||' select FUNCTION_ID from amw_constraint_entries where constraint_rev_id = :5'
1166: ||')';
1167:
1168:
1169: OPEN resp_acess_count_c FOR l_resp_sql USING

Line 1535: ||' from amw_constraint_entries cste '

1531: ||' and ur.role_orig_system = ''FND_RESP'' '
1532: ||' and ur.role_orig_system_id = resp.responsibility_id '
1533: ||' UNION ALL '
1534: ||' select distinct resp.responsibility_name '
1535: ||' from amw_constraint_entries cste '
1536: ||' ,'||G_AMW_USER_ROLES||' ur '
1537: ||' ,'||G_AMW_user||' u '
1538: ||' ,'||G_AMW_RESPONSIBILITY_VL||' resp '
1539: ||' where cste.constraint_rev_id = :3 '

Line 1903: from AMW_CONSTRAINT_ENTRIES

1899: and objective_code = 'PR';
1900:
1901: cursor CONSTRAINT_ENTRIES(p_constraint_rev_id NUMBER) is
1902: select distinct FUNCTION_ID, GROUP_CODE
1903: from AMW_CONSTRAINT_ENTRIES
1904: where
1905: CONSTRAINT_REV_ID = p_constraint_rev_id and
1906: (OBJECT_TYPE = 'FUNC' or OBJECT_TYPE is null);
1907:

Line 1910: from AMW_CONSTRAINT_ENTRIES

1906: (OBJECT_TYPE = 'FUNC' or OBJECT_TYPE is null);
1907:
1908: cursor CONSTRAINT_GROUP_CODES(p_constraint_rev_id NUMBER) is
1909: select distinct GROUP_CODE
1910: from AMW_CONSTRAINT_ENTRIES
1911: where
1912: CONSTRAINT_REV_ID = p_constraint_rev_id and
1913: (OBJECT_TYPE = 'FUNC' or OBJECT_TYPE is null);
1914:

Line 2090: from AMW_CONSTRAINT_ENTRIES

2086: and objective_code = 'PR';
2087:
2088: cursor CONSTRAINT_ENTRIES(p_constraint_rev_id NUMBER) is
2089: select distinct FUNCTION_ID, GROUP_CODE
2090: from AMW_CONSTRAINT_ENTRIES
2091: where
2092: CONSTRAINT_REV_ID = p_constraint_rev_id and
2093: (OBJECT_TYPE = 'FUNC' or OBJECT_TYPE is null);
2094:

Line 2097: from AMW_CONSTRAINT_ENTRIES

2093: (OBJECT_TYPE = 'FUNC' or OBJECT_TYPE is null);
2094:
2095: cursor CONSTRAINT_GROUP_CODES(p_constraint_rev_id NUMBER) is
2096: select distinct GROUP_CODE
2097: from AMW_CONSTRAINT_ENTRIES
2098: where
2099: CONSTRAINT_REV_ID = p_constraint_rev_id and
2100: (OBJECT_TYPE = 'FUNC' or OBJECT_TYPE is null);
2101: