APPS.GMD_SAMPLES_PUB dependencies on GMD_SAMPLE_SPEC_DISP

Line 152: , x_sample_spec_disp OUT NOCOPY GMD_SAMPLE_SPEC_DISP%ROWTYPE

148: , p_find_matching_spec IN VARCHAR2
149: , p_grade IN VARCHAR2 DEFAULT NULL --3431884
150: , x_qc_samples_rec OUT NOCOPY GMD_SAMPLES%ROWTYPE
151: , x_sampling_events_rec OUT NOCOPY GMD_SAMPLING_EVENTS%ROWTYPE
152: , x_sample_spec_disp OUT NOCOPY GMD_SAMPLE_SPEC_DISP%ROWTYPE
153: , x_event_spec_disp_rec OUT NOCOPY GMD_EVENT_SPEC_DISP%ROWTYPE
154: , x_results_tab OUT NOCOPY GMD_API_PUB.gmd_results_tab
155: , x_spec_results_tab OUT NOCOPY GMD_API_PUB.gmd_spec_results_tab
156: , x_return_status OUT NOCOPY VARCHAR2

Line 169: l_sample_spec_disp GMD_SAMPLE_SPEC_DISP%ROWTYPE;

165: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
166: l_samples_val_rec GMD_SAMPLES%ROWTYPE;
167: l_qc_samples_rec GMD_SAMPLES%ROWTYPE;
168: l_qc_samples_out_rec GMD_SAMPLES%ROWTYPE;
169: l_sample_spec_disp GMD_SAMPLE_SPEC_DISP%ROWTYPE;
170: l_event_spec_disp_rec GMD_EVENT_SPEC_DISP%ROWTYPE;
171: l_sampling_events GMD_SAMPLING_EVENTS%ROWTYPE;
172: l_sampling_events_out GMD_SAMPLING_EVENTS%ROWTYPE;
173: l_results_tab GMD_API_PUB.gmd_results_tab;

Line 722: -- it was not querying the record. Error message was shown with no rows in gmd_sample_spec_disp

718: --IF l_qc_samples_out_rec.sample_disposition <> '0RT' THEN
719:
720: -- bug# 3468060
721: -- if a planned sample was created using public layer api and queried in forms application,
722: -- it was not querying the record. Error message was shown with no rows in gmd_sample_spec_disp
723: -- removed the below if condition for planned samples. Need to create event spec dispositions rows.
724: --IF l_qc_samples_out_rec.sample_disposition <> '0PL' THEN
725: GMD_RESULTS_GRP.create_rslt_and_spec_rslt_rows(
726: p_sample => l_qc_samples_out_rec,