302: FOR UPDATE NOWAIT;
303:
304: UPDATE gmd_samples
305: SET delete_mark = 1,
306: last_updated_by = fnd_global.user_id,
307: last_update_date = SYSDATE
308: WHERE sample_id = p_sample_id
309: ;
310: ELSIF p_organization_id IS NOT NULL AND
317: FOR UPDATE NOWAIT;
318:
319: UPDATE gmd_samples
320: SET delete_mark = 1,
321: last_updated_by = fnd_global.user_id,
322: last_update_date = SYSDATE
323: WHERE organization_id = p_organization_id
324: AND sample_no = p_sample_no
325: ;