APPS.AMW_LOAD_CONSTRAINT_DATA dependencies on AMW_CONSTRAINT_WAIVERS

Line 156: -- delete Waivers from AMW_CONSTRAINT_WAIVERS

152: -- ===============================================================
153: -- Procedure name
154: -- delete_constraint_waivers
155: -- Purpose
156: -- delete Waivers from AMW_CONSTRAINT_WAIVERS
157: -- for specified constraint_rev_id
158: -- ===============================================================
159: procedure delete_constraint_waivers(
160: p_constraint_rev_id IN NUMBER,

Line 169: delete from amw_constraint_waivers

165: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
166: BEGIN
167: x_return_status := FND_API.G_RET_STS_SUCCESS;
168:
169: delete from amw_constraint_waivers
170: where constraint_rev_id = p_constraint_rev_id;
171:
172: if (sql%notfound) then
173: raise no_data_found;

Line 1253: ,'AMW_CONSTRAINT_WAIVERS'

1249: || ' '
1250: || SUBSTR (SQLERRM, 1, 100);
1251: fnd_file.put_line (fnd_file.LOG, SUBSTR (v_err_msg, 1, 200));
1252: update_interface_with_error (v_err_msg
1253: ,'AMW_CONSTRAINT_WAIVERS'
1254: ,l_interface_id);
1255: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1256: END IF;
1257: