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_VIOLATIONS

Line 2872: -- create violation in AMW_VIOLATIONS

2868: -- Private Function name
2869: -- Create_Violation
2870: --
2871: -- Purpose
2872: -- create violation in AMW_VIOLATIONS
2873: -- against specified constraint
2874: --
2875: -- Params
2876: -- p_constraint_rev_id := specified constraint_rev_id

Line 2909: AMW_VIOLATIONS_PKG.insert_row(x_rowid => l_row_id,

2905: OPEN c_violation_id;
2906: FETCH c_violation_id INTO l_violation_id;
2907: CLOSE c_violation_id;
2908:
2909: AMW_VIOLATIONS_PKG.insert_row(x_rowid => l_row_id,
2910: x_violation_id => l_violation_id,
2911: x_constraint_rev_id => p_constraint_rev_id,
2912: x_request_id => l_request_id,
2913: x_request_date => SYSDATE,

Line 2925: --FND_FILE.put_line(fnd_file.log,'AMW_VIOLATIONS_PKG.insert_row: l_violation_id= '||l_violation_id);

2921: x_last_update_login => G_LOGIN_ID,
2922: x_security_group_id => G_SECURITY_GROUP_ID,
2923: x_object_version_number => 1);
2924:
2925: --FND_FILE.put_line(fnd_file.log,'AMW_VIOLATIONS_PKG.insert_row: l_violation_id= '||l_violation_id);
2926:
2927: RETURN l_violation_id;
2928: END Create_Violation;
2929:

Line 2937: -- update violation in AMW_VIOLATIONS

2933: -- Private Procedure name
2934: -- Update_Violation
2935: --
2936: -- Purpose
2937: -- update violation in AMW_VIOLATIONS
2938: -- against specified violation_id and its constraint_rev_id
2939: --
2940: -- Params
2941: -- p_violation_id := specified violation_id

Line 2945: -- this is to update the violator_num, status_code in AMW_VIOLATIONS

2941: -- p_violation_id := specified violation_id
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

Line 3037: AMW_VIOLATIONS_PKG.update_row(x_violation_id => p_violation_id,

3033: l_reval_request_date := SYSDATE;
3034: l_reval_requested_by_id := G_PARTY_ID;
3035: END IF;
3036:
3037: AMW_VIOLATIONS_PKG.update_row(x_violation_id => p_violation_id,
3038: x_constraint_rev_id => p_constraint_rev_id,
3039: x_violator_num => l_violator_num,
3040: x_status_code => l_violation_status,
3041: x_last_updated_by => G_USER_ID,

Line 6586: -- create vilation record for specified constriant in AMW_VIOLATIONS

6582:
6583: BEGIN
6584: --FND_FILE.put_line(fnd_file.log,'inside api '||L_API_NAME);
6585:
6586: -- create vilation record for specified constriant in AMW_VIOLATIONS
6587: l_violation_id := Create_Violation(p_constraint_rev_id);
6588: IF (l_violation_id IS NULL) THEN
6589: -- create violation in AMW_VIOLATIONS is not successful
6590: RETURN;

Line 6589: -- create violation in AMW_VIOLATIONS is not successful

6585:
6586: -- create vilation record for specified constriant in AMW_VIOLATIONS
6587: l_violation_id := Create_Violation(p_constraint_rev_id);
6588: IF (l_violation_id IS NULL) THEN
6589: -- create violation in AMW_VIOLATIONS is not successful
6590: RETURN;
6591: END IF;
6592:
6593: --FND_FILE.put_line(fnd_file.log,'Violation Id '||l_violation_id);

Line 6880: ,amw_violations v

6876: CURSOR c_constraint(l_violation_id IN NUMBER) IS
6877: SELECT cst.constraint_rev_id
6878: ,cst.type_code
6879: FROM amw_constraints_b cst
6880: ,amw_violations v
6881: WHERE v.violation_id = l_violation_id
6882: AND v.constraint_rev_id = cst.constraint_rev_id;
6883: l_constraint c_constraint%ROWTYPE;
6884:

Line 7501: DELETE FROM amw_violations

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;
7503:
7504: ELSE
7505:

Line 7512: FROM amw_violations

7508: SELECT resp_violation_id
7509: FROM amw_violation_resp
7510: WHERE violation_id IN (
7511: SELECT violation_id
7512: FROM amw_violations
7513: WHERE status_code = 'NA'
7514: AND creation_date < l_date));
7515:
7516:

Line 7520: FROM amw_violations

7516:
7517: DELETE FROM amw_violation_resp
7518: WHERE violation_id IN (
7519: SELECT violation_id
7520: FROM amw_violations
7521: WHERE status_code = 'NA'
7522: AND creation_date < l_date);
7523:
7524: DELETE FROM amw_violat_user_entries

Line 7530: FROM amw_violations

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'
7532: AND creation_date < l_date ));
7533:
7534: DELETE FROM amw_violation_users

Line 7537: FROM amw_violations

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'
7539: AND creation_date < l_date );
7540:
7541: DELETE FROM amw_violations

Line 7541: DELETE FROM amw_violations

7537: FROM amw_violations
7538: WHERE status_code = 'NA'
7539: AND creation_date < l_date );
7540:
7541: DELETE FROM amw_violations
7542: WHERE status_code = 'NA'
7543: AND creation_date < l_date ;
7544:
7545: END IF;