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_VIOLATION_USERS

Line 2273: ||' AMW_VIOLATION_USERS vu '

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 '
2275: ||' AND (gra.grantee_orig_system = ''UMX'' OR gra.grantee_orig_system = ''FND_RESP'') '
2276: ||' AND urasgn.role_name = gra.GRANTEE_KEY '
2277: ||' AND gra.menu_id = cmf.menu_id '

Line 2306: ||' AMW_VIOLATION_USERS vu '

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'')) '
2309: ||' AND gra.menu_id = cmf.menu_id '
2310: ||' AND cmf.function_id = ce.function_id '

Line 2351: ||' AMW_VIOLATION_USERS vu '

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 '
2355: ||' AND cmf.grant_flag = ''Y'' '

Line 2408: ||' AMW_VIOLATION_USERS vu '

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 '
2412: ||' AND RESP.REQUEST_GROUP_ID IS NOT NULL '

Line 2462: ||' AMW_VIOLATION_USERS vu '

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 '
2466: ||' AND ce.application_id = resp.application_id '

Line 2826: ||' FROM AMW_VIOLATION_USERS vu '

2822: c_user_dynamic_sql userCurTyp;
2823:
2824: l_user_reval_dynamic_sql VARCHAR2(200) :=
2825: 'SELECT u.user_id, u.user_name '
2826: ||' FROM AMW_VIOLATION_USERS vu '
2827: ||' ,'||G_AMW_USER||' u '
2828: ||' WHERE vu.violation_id = :1 '
2829: ||' AND vu.violated_by_id = u.user_id ';
2830:

Line 2946: -- based on the conclusion from AMW_VIOLATION_USERS

2942: -- p_constraint_rev_id := specified constraint_rev_id
2943: --
2944: -- Notes
2945: -- this is to update the violator_num, status_code in AMW_VIOLATIONS
2946: -- based on the conclusion from AMW_VIOLATION_USERS
2947: --
2948: -- History
2949: -- 01.06.2005 tsho: starting from AMW.D, consider Waivers
2950: -- 05.20.2005 tsho: starting from AMW.E, consider Revalidation

Line 2978: -- get violator_num from AMW_VIOLATION_USERS

2974:
2975: -- 05.20.2005 tsho: store the request_id getting from FND_GLOBAL
2976: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
2977:
2978: -- get violator_num from AMW_VIOLATION_USERS
2979: -- 01.06.2005 tsho: starting from AMW.D, consider waivers
2980: CURSOR c_violator_num (l_violation_id IN NUMBER) IS
2981: SELECT count(*)
2982: FROM amw_violation_users

Line 2982: FROM amw_violation_users

2978: -- get violator_num from AMW_VIOLATION_USERS
2979: -- 01.06.2005 tsho: starting from AMW.D, consider waivers
2980: CURSOR c_violator_num (l_violation_id IN NUMBER) IS
2981: SELECT count(*)
2982: FROM amw_violation_users
2983: WHERE violation_id = l_violation_id
2984: AND (waived_flag is NULL OR waived_flag <> 'Y');
2985:
2986: -- 05.20.2005 tsho: get the num of violators after revalidating this violation

Line 2989: FROM amw_violation_users

2985:
2986: -- 05.20.2005 tsho: get the num of violators after revalidating this violation
2987: CURSOR c_violator_num_aft_reval (l_violation_id IN NUMBER) IS
2988: SELECT count(*)
2989: FROM amw_violation_users
2990: WHERE violation_id = l_violation_id
2991: AND (waived_flag is NULL OR waived_flag <> 'Y')
2992: AND (corrected_flag is NULL OR corrected_flag <> 'Y');
2993:

Line 3059: -- update user in AMW_VIOLATION_USERS

3055: -- Private Procedure name
3056: -- Update_Violation_User
3057: --
3058: -- Purpose
3059: -- update user in AMW_VIOLATION_USERS
3060: -- against specified violation_id and violated_by_id
3061: --
3062: -- Params
3063: -- p_user_violation_id := specified user_violation_id

Line 3069: -- this is to update the corrected_flag in AMW_VIOLATION_USERS

3065: -- p_violated_by_id := specified violated_by_id
3066: -- p_corrected_flag := specified corrected_flag
3067: --
3068: -- Notes
3069: -- this is to update the corrected_flag in AMW_VIOLATION_USERS
3070: --
3071: -- History
3072: -- 05.23.2005 tsho: create for AMW.E Revalidation
3073: -- ===============================================================

Line 3088: -- get user_violation_id from AMW_VIOLATION_USERS

3084:
3085: -- store the user_violation_id
3086: l_user_violation_id NUMBER := NULL;
3087:
3088: -- get user_violation_id from AMW_VIOLATION_USERS
3089: CURSOR c_user_violation_id (l_violation_id IN NUMBER, l_violated_by_id IN NUMBER) IS
3090: SELECT user_violation_id
3091: FROM amw_violation_users
3092: WHERE violation_id = l_violation_id

Line 3091: FROM amw_violation_users

3087:
3088: -- get user_violation_id from AMW_VIOLATION_USERS
3089: CURSOR c_user_violation_id (l_violation_id IN NUMBER, l_violated_by_id IN NUMBER) IS
3090: SELECT user_violation_id
3091: FROM amw_violation_users
3092: WHERE violation_id = l_violation_id
3093: AND violated_by_id = l_violated_by_id;
3094:
3095: BEGIN

Line 3100: -- get user_violation_id from AMW_VIOLATION_USERS if not specified

3096: --FND_FILE.put_line(fnd_file.log,'inside api '||L_API_NAME);
3097:
3098: IF (p_user_violation_id IS NULL) THEN
3099: BEGIN
3100: -- get user_violation_id from AMW_VIOLATION_USERS if not specified
3101: OPEN c_user_violation_id(p_violation_id, p_violated_by_id);
3102: FETCH c_user_violation_id INTO l_user_violation_id;
3103: CLOSE c_user_violation_id;
3104:

Line 3115: AMW_VIOLATION_USERS_PKG.UPDATE_ROW (

3111: return;
3112: END;
3113: END IF;
3114:
3115: AMW_VIOLATION_USERS_PKG.UPDATE_ROW (
3116: x_user_violation_id => l_user_violation_id,
3117: x_violation_id => p_violation_id,
3118: x_violated_by_id => p_violated_by_id,
3119: x_last_updated_by => G_USER_ID,

Line 3204: -- thus store user_id directly rather party_id in AMW_VIOLATION_USERS

3200: CLOSE c_user_dynamic_sql;
3201: */
3202: -- 01.02.2003 tsho: bug 3348191 - duplicated user shown
3203: -- because same party_id(person) maps to multiple user_id(login acct),
3204: -- thus store user_id directly rather party_id in AMW_VIOLATION_USERS
3205: /*
3206: SELECT person_party_id
3207: INTO l_party_id
3208: FROM FND_USER

Line 3220: -- don't create a record in AMW_VIOLATION_USERS

3216: END;
3217:
3218: IF ((G_PV_FUNCTION_ID_LIST IS NULL) OR (G_PV_FUNCTION_ID_LIST.FIRST IS NULL)) THEN
3219: -- no potential violation for this user against this constraint
3220: -- don't create a record in AMW_VIOLATION_USERS
3221: RETURN;
3222: END IF;
3223:
3224: -- get user_violation_id from AMW_USER_VIOLATION_S

Line 3229: AMW_VIOLATION_USERS_PKG.insert_row(x_rowid => l_row_id,

3225: OPEN c_user_violation_id;
3226: FETCH c_user_violation_id INTO l_user_violation_id;
3227: CLOSE c_user_violation_id;
3228:
3229: AMW_VIOLATION_USERS_PKG.insert_row(x_rowid => l_row_id,
3230: x_user_violation_id => l_user_violation_id,
3231: x_violation_id => p_violation_id,
3232: x_violated_by_id => l_party_id,
3233: x_last_updated_by => G_USER_ID,

Line 3240: --FND_FILE.put_line(fnd_file.log,'AMW_VIOLATION_USERS_PKG.insert_row: l_user_violation_id= '|| l_user_violation_id);

3236: x_creation_date => SYSDATE,
3237: x_last_update_login => G_LOGIN_ID,
3238: x_security_group_id => NULL);
3239:
3240: --FND_FILE.put_line(fnd_file.log,'AMW_VIOLATION_USERS_PKG.insert_row: l_user_violation_id= '|| l_user_violation_id);
3241:
3242: -- bulk insert to AMW_VIOLAT_USER_ENTRIES
3243: FORALL i IN 1 .. G_PV_FUNCTION_ID_LIST.COUNT
3244: INSERT INTO AMW_VIOLAT_USER_ENTRIES VALUES (

Line 4544: -- thus store user_id directly rather party_id in AMW_VIOLATION_USERS

4540: -- find party_id with specified user_id
4541: BEGIN
4542: -- 01.02.2003 tsho: bug 3348191 - duplicated user shown
4543: -- because same party_id(person) maps to multiple user_id(login acct),
4544: -- thus store user_id directly rather party_id in AMW_VIOLATION_USERS
4545: l_party_id := p_user_id;
4546:
4547: EXCEPTION
4548: WHEN no_data_found THEN

Line 4582: UPDATE AMW_VIOLATION_USERS SET CORRECTED_FLAG = 'N'

4578: -- responsibilities will not fetch the end dated responsibilities. So no action is taken against the
4579: -- user having responsibilities which violate the constraint.
4580: -- Updated the corrected_flag of all the violating users to yes. For the violating users,
4581: -- the corrected_flag will be set to no.
4582: UPDATE AMW_VIOLATION_USERS SET CORRECTED_FLAG = 'N'
4583: WHERE USER_VIOLATION_ID = l_user_violation_id;
4584: -- ptulasi : 18/02/2008
4585: -- bug : 6722113 : Added below condition to not to display waived of responsibilities in
4586: -- the violation report users tab

Line 4588: UPDATE AMW_VIOLATION_USERS SET WAIVED_FLAG = 'Y'

4584: -- ptulasi : 18/02/2008
4585: -- bug : 6722113 : Added below condition to not to display waived of responsibilities in
4586: -- the violation report users tab
4587: IF l_is_user_waived = 'Y' THEN
4588: UPDATE AMW_VIOLATION_USERS SET WAIVED_FLAG = 'Y'
4589: WHERE USER_VIOLATION_ID = l_user_violation_id;
4590: END IF;
4591: END IF;
4592: ELSE

Line 4603: AMW_VIOLATION_USERS_PKG.insert_row(x_rowid => l_row_id,

4599: OPEN c_user_violation_id;
4600: FETCH c_user_violation_id INTO l_user_violation_id;
4601: CLOSE c_user_violation_id;
4602:
4603: AMW_VIOLATION_USERS_PKG.insert_row(x_rowid => l_row_id,
4604: x_user_violation_id => l_user_violation_id,
4605: x_violation_id => p_violation_id,
4606: x_violated_by_id => l_party_id,
4607: x_last_updated_by => G_USER_ID,

Line 4726: -- thus store user_id directly rather party_id in AMW_VIOLATION_USERS

4722: -- find party_id with specified user_id
4723: BEGIN
4724: -- 01.02.2003 tsho: bug 3348191 - duplicated user shown
4725: -- because same party_id(person) maps to multiple user_id(login acct),
4726: -- thus store user_id directly rather party_id in AMW_VIOLATION_USERS
4727: l_party_id := p_user_id;
4728:
4729: EXCEPTION
4730: WHEN no_data_found THEN

Line 4748: UPDATE AMW_VIOLATION_USERS SET CORRECTED_FLAG = 'N'

4744: -- responsibilities will not fetch the end dated responsibilities. So no action is taken against the
4745: -- user having responsibilities which violate the constraint.
4746: -- Updated the corrected_flag of all the violating users to yes. For the violating users,
4747: -- the corrected_flag will be set to no.
4748: UPDATE AMW_VIOLATION_USERS SET CORRECTED_FLAG = 'N'
4749: WHERE USER_VIOLATION_ID = l_user_violation_id;
4750:
4751: END IF;
4752:

Line 4763: AMW_VIOLATION_USERS_PKG.insert_row(x_rowid => l_row_id,

4759: OPEN c_user_violation_id;
4760: FETCH c_user_violation_id INTO l_user_violation_id;
4761: CLOSE c_user_violation_id;
4762:
4763: AMW_VIOLATION_USERS_PKG.insert_row(x_rowid => l_row_id,
4764: x_user_violation_id => l_user_violation_id,
4765: x_violation_id => p_violation_id,
4766: x_violated_by_id => l_party_id,
4767: x_last_updated_by => G_USER_ID,

Line 5667: FROM amw_violation_users

5663: AND start_date <= sysdate AND (end_date >= sysdate or end_date is null);
5664:
5665: CURSOR c_original_user_violation_id (l_violation_id IN NUMBER) IS
5666: SELECT violated_by_id,user_violation_id
5667: FROM amw_violation_users
5668: WHERE violation_id = l_violation_id;
5669:
5670: l_user_access_func_list G_NUMBER_TABLE;
5671: l_user_access_func_nowaiv_list G_NUMBER_TABLE;

Line 5835: FROM amw_violation_users

5831: AND start_date <= sysdate AND (end_date >= sysdate or end_date is null);
5832:
5833: CURSOR c_original_user_violation_id (l_violation_id IN NUMBER) IS
5834: SELECT violated_by_id,user_violation_id
5835: FROM amw_violation_users
5836: WHERE violation_id = l_violation_id;
5837:
5838: l_user_access_func_list G_NUMBER_TABLE;
5839: l_user_access_func_nowaiv_list G_NUMBER_TABLE;

Line 5999: FROM amw_violation_users

5995: AND start_date <= sysdate AND (end_date >= sysdate or end_date is null);
5996:
5997: CURSOR c_original_user_violation_id (l_violation_id IN NUMBER) IS
5998: SELECT violated_by_id,user_violation_id
5999: FROM amw_violation_users
6000: WHERE violation_id = l_violation_id;
6001:
6002: l_user_access_func_list G_NUMBER_TABLE;
6003: l_user_access_func_nowaiv_list G_NUMBER_TABLE;

Line 6177: FROM amw_violation_users

6173: AND start_date <= sysdate AND (end_date >= sysdate or end_date is null);
6174:
6175: CURSOR c_original_user_violation_id (l_violation_id IN NUMBER) IS
6176: SELECT violated_by_id,user_violation_id
6177: FROM amw_violation_users
6178: WHERE violation_id = l_violation_id;
6179:
6180: L_RESP_ID_LIST G_RESPS_TABLE;
6181: l_waive_user_id NUMBER;

Line 6307: FROM amw_violation_users

6303: AND start_date <= sysdate AND (end_date >= sysdate or end_date is null);
6304:
6305: CURSOR c_original_user_violation_id (l_violation_id IN NUMBER) IS
6306: SELECT violated_by_id,user_violation_id
6307: FROM amw_violation_users
6308: WHERE violation_id = l_violation_id;
6309:
6310: L_RESP_ID_LIST G_RESPS_TABLE;
6311: l_waive_user_id NUMBER;

Line 6443: FROM amw_violation_users

6439: AND start_date <= sysdate AND (end_date >= sysdate or end_date is null);
6440:
6441: CURSOR c_original_user_violation_id (l_violation_id IN NUMBER) IS
6442: SELECT violated_by_id,user_violation_id
6443: FROM amw_violation_users
6444: WHERE violation_id = l_violation_id;
6445:
6446: BEGIN
6447: --FND_FILE.put_line(fnd_file.log,'inside api '||L_API_NAME);

Line 6904: UPDATE AMW_VIOLATION_USERS

6900: -- responsibilities will not fetch the end dated responsibilities. So no action is taken against the
6901: -- user having responsibilities which violate the constraint.
6902: -- Updated the corrected_flag of all the violating users to yes. For the violating users,
6903: -- the corrected_flag will be set to no.
6904: UPDATE AMW_VIOLATION_USERS
6905: SET CORRECTED_FLAG = 'Y'
6906: WHERE VIOLATION_ID = p_violation_id;
6907:
6908: IF (l_constraint.constraint_rev_id IS NOT NULL AND l_constraint.type_code IS NOT NULL) THEN

Line 7498: DELETE FROM amw_violation_users

7494:
7495: DELETE FROM amw_violat_user_entries
7496: WHERE creation_date < l_date;
7497:
7498: DELETE FROM amw_violation_users
7499: WHERE creation_date < l_date;
7500:
7501: DELETE FROM amw_violations
7502: WHERE creation_date < l_date;

Line 7527: FROM amw_violation_users

7523:
7524: DELETE FROM amw_violat_user_entries
7525: WHERE user_violation_id IN (
7526: SELECT user_violation_id
7527: FROM amw_violation_users
7528: WHERE violation_id IN (
7529: SELECT violation_id
7530: FROM amw_violations
7531: WHERE status_code = 'NA'

Line 7534: DELETE FROM amw_violation_users

7530: FROM amw_violations
7531: WHERE status_code = 'NA'
7532: AND creation_date < l_date ));
7533:
7534: DELETE FROM amw_violation_users
7535: WHERE violation_id IN (
7536: SELECT violation_id
7537: FROM amw_violations
7538: WHERE status_code = 'NA'