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_S

Line 2889: -- store the violation_id getting from AMW_VIOLATION_S

2885:
2886: L_API_NAME CONSTANT VARCHAR2(30) := 'Create_Violation';
2887: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
2888:
2889: -- store the violation_id getting from AMW_VIOLATION_S
2890: l_violation_id NUMBER := NULL;
2891: l_row_id VARCHAR2(32767); -- 11.17.2003 tsho: need to check out
2892:
2893: -- store the request_id getting from FND_GLOBAL

Line 2896: -- get violation_id from AMW_VIOLATION_S

2892:
2893: -- store the request_id getting from FND_GLOBAL
2894: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
2895:
2896: -- get violation_id from AMW_VIOLATION_S
2897: CURSOR c_violation_id IS
2898: SELECT AMW_VIOLATION_S.NEXTVAL
2899: FROM dual;
2900:

Line 2898: SELECT AMW_VIOLATION_S.NEXTVAL

2894: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
2895:
2896: -- get violation_id from AMW_VIOLATION_S
2897: CURSOR c_violation_id IS
2898: SELECT AMW_VIOLATION_S.NEXTVAL
2899: FROM dual;
2900:
2901: BEGIN
2902: --FND_FILE.put_line(fnd_file.log,'inside api '||L_API_NAME);

Line 2904: -- get violation_id from AMW_VIOLATION_S

2900:
2901: BEGIN
2902: --FND_FILE.put_line(fnd_file.log,'inside api '||L_API_NAME);
2903:
2904: -- get violation_id from AMW_VIOLATION_S
2905: OPEN c_violation_id;
2906: FETCH c_violation_id INTO l_violation_id;
2907: CLOSE c_violation_id;
2908: