APPS.GMD_QC_MIGRATE_TO_1151J dependencies on GMD_SAMPLE_SPEC_DISP

Line 5054: INSERT INTO gmd_sample_spec_disp

5050: ) RETURNING event_spec_disp_id INTO l_event_spec_disp_id; --Bug 3486120, changed it for perm.
5051:
5052: /* Create new sample spec disposition to hold sample dispostion */
5053:
5054: INSERT INTO gmd_sample_spec_disp
5055: (
5056: event_spec_disp_id,
5057: sample_id,
5058: disposition,

Line 5745: l_sample_spec_tab GMD_SAMPLE_SPEC_DISP%ROWTYPE;

5741:
5742: /* ------------- LOCAL VARIABLES ------------------- */
5743: l_return_status VARCHAR2(4);
5744: l_event_spec_tab GMD_EVENT_SPEC_DISP%ROWTYPE;
5745: l_sample_spec_tab GMD_SAMPLE_SPEC_DISP%ROWTYPE;
5746: l_spec_results_tab GMD_API_PUB.gmd_spec_results_tab;
5747: l_results_tab GMD_API_PUB.gmd_results_tab;
5748: l_spec_vr_id NUMBER;
5749: l_temp NUMBER;

Line 5921: update gmd_sample_spec_disp

5917: IF c_cnt_results%NOTFOUND THEN */
5918: update gmd_samples
5919: set sample_disposition = '3C'
5920: where sample_id = l_ip_samples.ip_sample;
5921: update gmd_sample_spec_disp
5922: set disposition = '3C'
5923: where event_spec_disp_id = l_ip_samples.ip_event_spec ;
5924: update gmd_event_spec_disp
5925: set disposition = '3C'