APPS.GMD_QC_MIGRATE_TO_1151J dependencies on GMD_EVENT_SPEC_DISP

Line 5021: INSERT INTO gmd_event_spec_disp

5017:
5018:
5019: /* Create new event spec disposition, use sample dispostion */
5020:
5021: INSERT INTO gmd_event_spec_disp
5022: (
5023: event_spec_disp_id,
5024: sampling_event_id,
5025: spec_id,

Line 5279: FROM gmd_event_spec_disp d, gmd_samples s

5275:
5276: /* Retrieve sample_event_spec_disp_id, spec_id using sample id */
5277: CURSOR c_get_ids IS
5278: SELECT d.event_spec_disp_id, d.spec_id
5279: FROM gmd_event_spec_disp d, gmd_samples s
5280: WHERE d.sampling_event_id = s.sampling_event_id and
5281: s.sample_id = rslt_rec.sample_id;
5282: id_rec c_get_ids%ROWTYPE;
5283:

Line 5744: l_event_spec_tab GMD_EVENT_SPEC_DISP%ROWTYPE;

5740: IS
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;

Line 5794: SELECT /*+ INDEX(ESD GMD_EVENT_SPEC_DISP_N1) */

5790: WHERE sampling_event_id = psampling_event_id;
5791:
5792: -- Bug 3601780
5793: CURSOR c_ip_samples is
5794: SELECT /*+ INDEX(ESD GMD_EVENT_SPEC_DISP_N1) */
5795: s.sample_id ip_sample, esd.sampling_event_id ip_sampling_event,
5796: esd.event_spec_disp_id ip_event_spec
5797: FROM gmd_samples s,
5798: gmd_event_spec_disp esd

Line 5798: gmd_event_spec_disp esd

5794: SELECT /*+ INDEX(ESD GMD_EVENT_SPEC_DISP_N1) */
5795: s.sample_id ip_sample, esd.sampling_event_id ip_sampling_event,
5796: esd.event_spec_disp_id ip_event_spec
5797: FROM gmd_samples s,
5798: gmd_event_spec_disp esd
5799: WHERE S.sampling_event_id = ESD.sampling_event_id
5800: AND S.SAMPLE_DISPOSITION = '2I'
5801: and NOT EXISTS
5802: ( SELECT /*+ INDEX(SR GMD_SPEC_RESULTS_PK) */

Line 5924: update gmd_event_spec_disp

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'
5926: where event_spec_disp_id = l_ip_samples.ip_event_spec ;
5927: update gmd_sampling_events
5928: set disposition = '3C'