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_VIOLAT_USER_ENTRIES

Line 3125: DELETE FROM AMW_VIOLAT_USER_ENTRIES

3121: x_last_update_login => G_USER_ID,
3122: x_security_group_id => G_SECURITY_GROUP_ID,
3123: x_waived_flag => null,
3124: x_corrected_flag => p_corrected_flag);
3125: DELETE FROM AMW_VIOLAT_USER_ENTRIES
3126: WHERE USER_VIOLATION_ID=l_user_violation_id;
3127:
3128: --FND_FILE.put_line(fnd_file.log,'Came out'||L_API_NAME);
3129: END Update_Violation_User;

Line 3151: -- 05.17.2005 tsho: starting from AMW.E, add column: ROLE_NAME to AMW_VIOLAT_USER_ENTRIES

3147: --
3148: -- 01.10.2005 tsho: Deprecated,
3149: -- use Write_Func_To_Table_For_User or Write_Resp_To_Table_For_User instead
3150: -- History
3151: -- 05.17.2005 tsho: starting from AMW.E, add column: ROLE_NAME to AMW_VIOLAT_USER_ENTRIES
3152: -- ===============================================================
3153: Procedure Write_To_Table (
3154: p_violation_id IN NUMBER,
3155: p_constraint_rev_id IN NUMBER,

Line 3242: -- bulk insert to AMW_VIOLAT_USER_ENTRIES

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 (
3245: SYSDATE, -- last_update_date
3246: G_USER_ID, -- last_updated_by

Line 3244: INSERT INTO AMW_VIOLAT_USER_ENTRIES VALUES (

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 (
3245: SYSDATE, -- last_update_date
3246: G_USER_ID, -- last_updated_by
3247: G_LOGIN_ID, -- last_update_login
3248: SYSDATE, -- creation_date

Line 4571: DELETE FROM AMW_VIOLAT_USER_ENTRIES

4567:
4568: IF (p_revalidate_flag IS NOT NULL AND p_revalidate_flag = 'Y') THEN
4569: IF (G_User_Violation_Id_list.exists(p_user_id)) THEN
4570: l_user_violation_id :=G_User_Violation_Id_list(p_user_id);
4571: DELETE FROM AMW_VIOLAT_USER_ENTRIES
4572: WHERE USER_VIOLATION_ID =l_user_violation_id;
4573:
4574: -- ptulasi : 18-02-2008
4575: -- bug : 6689589 : If a responsibility violating the constraint is end dated, the staus for the

Line 4630: INSERT INTO AMW_VIOLAT_USER_ENTRIES(

4626: -- the violation report
4627: listkey := L_USERVIO_ENTRIES(k).application_id||'@'||L_USERVIO_ENTRIES(k).Responsibility_id;
4628: IF (((l_is_user_waived IS NULL OR l_is_user_waived <> 'Y')
4629: AND (NOT l_waived_resp_appl_list.exists(listkey))) OR (l_is_user_waived = 'Y')) THEN
4630: INSERT INTO AMW_VIOLAT_USER_ENTRIES(
4631: LAST_UPDATE_DATE,
4632: LAST_UPDATED_BY,
4633: LAST_UPDATE_LOGIN,
4634: CREATION_DATE,

Line 4688: -- 05.17.2005 tsho: starting from AMW.E, add column: ROLE_NAME to AMW_VIOLAT_USER_ENTRIES

4684: -- when calling this procedure means it's gaurantee
4685: -- the specified user has violated the specified constraint
4686: --
4687: -- History
4688: -- 05.17.2005 tsho: starting from AMW.E, add column: ROLE_NAME to AMW_VIOLAT_USER_ENTRIES
4689: -- 05.23.2005 tsho: starting from AMW.E, Revalidation
4690: -- ===============================================================
4691: Procedure Write_Resp_To_Table_For_User (
4692: p_violation_id IN NUMBER,

Line 4737: DELETE FROM AMW_VIOLAT_USER_ENTRIES

4733:
4734: IF (p_revalidate_flag IS NOT NULL AND p_revalidate_flag = 'Y') THEN
4735: IF (G_User_Violation_Id_list.exists(p_user_id)) THEN
4736: l_user_violation_id :=G_User_Violation_Id_list(p_user_id);
4737: DELETE FROM AMW_VIOLAT_USER_ENTRIES
4738: WHERE USER_VIOLATION_ID = l_user_violation_id;
4739:
4740: -- ptulasi : 18-02-2008
4741: -- bug : 6689589 : If a responsibility violating the constraint is end dated, the staus for the

Line 4784: INSERT INTO AMW_VIOLAT_USER_ENTRIES(

4780: LOOP
4781: L_USERVIO_ENTRIES:=L_RESP_ID_LIST(listkey);
4782: FOR k IN L_USERVIO_ENTRIES.FIRST .. L_USERVIO_ENTRIES.LAST
4783: LOOP
4784: INSERT INTO AMW_VIOLAT_USER_ENTRIES(
4785: LAST_UPDATE_DATE,
4786: LAST_UPDATED_BY,
4787: LAST_UPDATE_LOGIN,
4788: CREATION_DATE,

Line 7495: DELETE FROM amw_violat_user_entries

7491:
7492: DELETE FROM amw_violation_resp
7493: WHERE creation_date < l_date;
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;

Line 7524: DELETE FROM amw_violat_user_entries

7520: FROM amw_violations
7521: WHERE status_code = 'NA'
7522: AND creation_date < l_date);
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 (