APPS.GMD_SAMPLES_PUB dependencies on GMD_SAMPLE_SPEC_DISP

Line 161: , x_sample_spec_disp OUT NOCOPY GMD_SAMPLE_SPEC_DISP%ROWTYPE

157: , p_lpn IN VARCHAR2 DEFAULT NULL -- 7027149
158: , p_create_new_sample_group IN VARCHAR2 -- 12846165
159: , x_qc_samples_rec OUT NOCOPY GMD_SAMPLES%ROWTYPE
160: , x_sampling_events_rec OUT NOCOPY GMD_SAMPLING_EVENTS%ROWTYPE
161: , x_sample_spec_disp OUT NOCOPY GMD_SAMPLE_SPEC_DISP%ROWTYPE
162: , x_event_spec_disp_rec OUT NOCOPY GMD_EVENT_SPEC_DISP%ROWTYPE
163: , x_results_tab OUT NOCOPY GMD_API_PUB.gmd_results_tab
164: , x_spec_results_tab OUT NOCOPY GMD_API_PUB.gmd_spec_results_tab
165: , x_return_status OUT NOCOPY VARCHAR2

Line 178: l_sample_spec_disp GMD_SAMPLE_SPEC_DISP%ROWTYPE;

174: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
175: l_samples_val_rec GMD_SAMPLES%ROWTYPE;
176: l_qc_samples_rec GMD_SAMPLES%ROWTYPE;
177: l_qc_samples_out_rec GMD_SAMPLES%ROWTYPE;
178: l_sample_spec_disp GMD_SAMPLE_SPEC_DISP%ROWTYPE;
179: l_event_spec_disp_rec GMD_EVENT_SPEC_DISP%ROWTYPE;
180: l_sampling_events GMD_SAMPLING_EVENTS%ROWTYPE;
181: l_sampling_events_out GMD_SAMPLING_EVENTS%ROWTYPE;
182: l_results_tab GMD_API_PUB.gmd_results_tab;

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

802: --IF l_qc_samples_out_rec.sample_disposition <> '0RT' THEN
803:
804: -- bug# 3468060
805: -- if a planned sample was created using public layer api and queried in forms application,
806: -- it was not querying the record. Error message was shown with no rows in gmd_sample_spec_disp
807: -- removed the below if condition for planned samples. Need to create event spec dispositions rows.
808: --IF l_qc_samples_out_rec.sample_disposition <> '0PL' THEN
809: GMD_RESULTS_GRP.create_rslt_and_spec_rslt_rows(
810: p_sample => l_qc_samples_out_rec,