1317: x_return_status OUT NOCOPY VARCHAR2) IS
1318:
1319: CURSOR c_get_spec_id(p_sample_id NUMBER) IS
1320: select c.spec_id 1321: from gmd_samples a, 1322: gmd_sampling_events b,
1323: gmd_event_spec_disp c
1324: where a.sample_id = p_sample_id
1325: and a.sampling_event_id = b.sampling_event_id