299: FOR UPDATE NOWAIT;
300:
301: UPDATE gmd_samples
302: SET delete_mark = 1,
303: last_updated_by = fnd_global.user_id,
304: last_update_date = SYSDATE
305: WHERE sample_id = p_sample_id
306: ;
307: ELSIF p_organization_id IS NOT NULL AND
314: FOR UPDATE NOWAIT;
315:
316: UPDATE gmd_samples
317: SET delete_mark = 1,
318: last_updated_by = fnd_global.user_id,
319: last_update_date = SYSDATE
320: WHERE organization_id = p_organization_id
321: AND sample_no = p_sample_no
322: ;