140: p_sample IN GMD_SAMPLES%ROWTYPE
141: , p_migration IN VARCHAR2 DEFAULT NULL
142: , x_event_spec_disp OUT NOCOPY GMD_EVENT_SPEC_DISP%ROWTYPE
143: , x_sample_spec_disp OUT NOCOPY GMD_SAMPLE_SPEC_DISP%ROWTYPE
144: , x_results_tab OUT NOCOPY GMD_API_PUB.gmd_results_tab
145: , x_spec_results_tab OUT NOCOPY GMD_API_PUB.gmd_spec_results_tab
146: , x_return_status OUT NOCOPY VARCHAR2
147: );
148:
141: , p_migration IN VARCHAR2 DEFAULT NULL
142: , x_event_spec_disp OUT NOCOPY GMD_EVENT_SPEC_DISP%ROWTYPE
143: , x_sample_spec_disp OUT NOCOPY GMD_SAMPLE_SPEC_DISP%ROWTYPE
144: , x_results_tab OUT NOCOPY GMD_API_PUB.gmd_results_tab
145: , x_spec_results_tab OUT NOCOPY GMD_API_PUB.gmd_spec_results_tab
146: , x_return_status OUT NOCOPY VARCHAR2
147: );
148:
149:
163: PROCEDURE compare_rslt_and_spec
164: (
165: p_sample_id IN NUMBER
166: , p_spec_id IN NUMBER
167: , x_test_ids OUT NOCOPY GMD_API_PUB.number_tab
168: , x_return_status OUT NOCOPY VARCHAR2
169: );
170:
171:
172: PROCEDURE compare_cmpst_rslt_and_spec
173: (
174: p_composite_spec_disp_id IN NUMBER
175: , p_spec_id IN NUMBER
176: , x_test_ids OUT NOCOPY GMD_API_PUB.number_tab
177: , x_return_status OUT NOCOPY VARCHAR2
178: );
179:
180:
190:
191: PROCEDURE add_tests_to_sample
192: (
193: p_sample IN GMD_SAMPLES%ROWTYPE
194: , p_test_ids IN GMD_API_PUB.number_tab
195: , p_event_spec_disp_id IN NUMBER
196: , x_results_tab OUT NOCOPY GMD_API_PUB.gmd_results_tab
197: , x_spec_results_tab OUT NOCOPY GMD_API_PUB.gmd_spec_results_tab
198: , x_return_status OUT NOCOPY VARCHAR2
192: (
193: p_sample IN GMD_SAMPLES%ROWTYPE
194: , p_test_ids IN GMD_API_PUB.number_tab
195: , p_event_spec_disp_id IN NUMBER
196: , x_results_tab OUT NOCOPY GMD_API_PUB.gmd_results_tab
197: , x_spec_results_tab OUT NOCOPY GMD_API_PUB.gmd_spec_results_tab
198: , x_return_status OUT NOCOPY VARCHAR2
199: , p_test_qty IN NUMBER DEFAULT NULL
200: , p_test_qty_uom IN VARCHAR2 DEFAULT NULL
193: p_sample IN GMD_SAMPLES%ROWTYPE
194: , p_test_ids IN GMD_API_PUB.number_tab
195: , p_event_spec_disp_id IN NUMBER
196: , x_results_tab OUT NOCOPY GMD_API_PUB.gmd_results_tab
197: , x_spec_results_tab OUT NOCOPY GMD_API_PUB.gmd_spec_results_tab
198: , x_return_status OUT NOCOPY VARCHAR2
199: , p_test_qty IN NUMBER DEFAULT NULL
200: , p_test_qty_uom IN VARCHAR2 DEFAULT NULL
201: );
217:
218:
219: PROCEDURE add_test_to_samples
220: (
221: p_sample_ids IN GMD_API_PUB.number_tab
222: , p_test_id IN NUMBER
223: , p_event_spec_disp_id IN NUMBER
224: , x_results_tab OUT NOCOPY GMD_API_PUB.gmd_results_tab
225: , x_spec_results_tab OUT NOCOPY GMD_API_PUB.gmd_spec_results_tab
220: (
221: p_sample_ids IN GMD_API_PUB.number_tab
222: , p_test_id IN NUMBER
223: , p_event_spec_disp_id IN NUMBER
224: , x_results_tab OUT NOCOPY GMD_API_PUB.gmd_results_tab
225: , x_spec_results_tab OUT NOCOPY GMD_API_PUB.gmd_spec_results_tab
226: , x_return_status OUT NOCOPY VARCHAR2
227: , p_test_qty IN NUMBER DEFAULT NULL
228: , p_test_qty_uom IN VARCHAR2 DEFAULT NULL
221: p_sample_ids IN GMD_API_PUB.number_tab
222: , p_test_id IN NUMBER
223: , p_event_spec_disp_id IN NUMBER
224: , x_results_tab OUT NOCOPY GMD_API_PUB.gmd_results_tab
225: , x_spec_results_tab OUT NOCOPY GMD_API_PUB.gmd_spec_results_tab
226: , x_return_status OUT NOCOPY VARCHAR2
227: , p_test_qty IN NUMBER DEFAULT NULL
228: , p_test_qty_uom IN VARCHAR2 DEFAULT NULL
229: );
286:
287: PROCEDURE get_sample_ids_for_se
288: (
289: p_sampling_event_id IN NUMBER
290: , x_sample_ids OUT NOCOPY GMD_API_PUB.number_tab
291: , x_return_status OUT NOCOPY VARCHAR2
292: );
293:
294:
293:
294:
295: PROCEDURE populate_result_data_points
296: (
297: p_sample_ids IN GMD_API_PUB.number_tab
298: , p_event_spec_disp_id IN NUMBER
299: , x_return_status OUT NOCOPY VARCHAR2
300: );
301: