APPS.GMD_QC_MIGB12 dependencies on GMD_SAMPLING_EVENTS

Line 131: IF (p_rec_context = 1) THEN -- gmd_sampling_events

127: Format the error message based on the context
128: that this routine was called from.
129: ===============================================*/
130:
131: IF (p_rec_context = 1) THEN -- gmd_sampling_events
132: l_record := 'gmd_sampling_events';
133: l_recordkey := 'sampling_event_id';
134: ELSE -- gmd_wip_spec_vrs
135: l_record := 'gmd_wip_spec_vrs';

Line 132: l_record := 'gmd_sampling_events';

128: that this routine was called from.
129: ===============================================*/
130:
131: IF (p_rec_context = 1) THEN -- gmd_sampling_events
132: l_record := 'gmd_sampling_events';
133: l_recordkey := 'sampling_event_id';
134: ELSE -- gmd_wip_spec_vrs
135: l_record := 'gmd_wip_spec_vrs';
136: l_recordkey := 'spec_vr_id';

Line 162: IF (p_rec_context = 1) THEN -- gmd_sampling_events

158: Format the error message based on the context
159: that this routine was called from.
160: ===============================================*/
161:
162: IF (p_rec_context = 1) THEN -- gmd_sampling_events
163: l_record := 'gmd_sampling_events';
164: l_recordkey := 'sampling_event_id';
165: ELSE -- gmd_wip_spec_vrs
166: l_record := 'gmd_wip_spec_vrs';

Line 163: l_record := 'gmd_sampling_events';

159: that this routine was called from.
160: ===============================================*/
161:
162: IF (p_rec_context = 1) THEN -- gmd_sampling_events
163: l_record := 'gmd_sampling_events';
164: l_recordkey := 'sampling_event_id';
165: ELSE -- gmd_wip_spec_vrs
166: l_record := 'gmd_wip_spec_vrs';
167: l_recordkey := 'spec_vr_id';

Line 249: Cursor to get gmd_sampling_events.

245: l_mig_batch get_mig_batch%ROWTYPE;
246:
247:
248: /*=====================================
249: Cursor to get gmd_sampling_events.
250: =====================================*/
251:
252: CURSOR get_sampling_event IS
253: SELECT step_no, step_id, material_detail_id, sampling_event_id

Line 254: FROM gmd_sampling_events

250: =====================================*/
251:
252: CURSOR get_sampling_event IS
253: SELECT step_no, step_id, material_detail_id, sampling_event_id
254: FROM gmd_sampling_events
255: WHERE batch_id = l_mig_batch.old_batch_id;
256:
257: l_sam_event get_sampling_event%ROWTYPE;
258:

Line 316: Check for batch in gmd_sampling_events.

312:
313: BEGIN -- begin for get_mig_batch
314:
315: /*===========================================
316: Check for batch in gmd_sampling_events.
317: ===========================================*/
318: FOR l_sam_event IN get_sampling_event LOOP
319: BEGIN -- begin for get_sampling_event
320: l_new_step_id := NULL;

Line 352: Update gmd_sampling_events and

348: END IF;
349: END IF;
350:
351: /*==================================
352: Update gmd_sampling_events and
353: gmd_samples.
354: ==================================*/
355:
356: UPDATE gmd_sampling_events

Line 356: UPDATE gmd_sampling_events

352: Update gmd_sampling_events and
353: gmd_samples.
354: ==================================*/
355:
356: UPDATE gmd_sampling_events
357: SET batch_id = l_mig_batch.new_batch_id,
358: step_id = l_new_step_id,
359: material_detail_id = l_new_det_id
360: WHERE sampling_event_id = l_sam_event.sampling_event_id;

Line 392: p_param1 => 'gmd_sampling_events',

388: p_context => 'Quality Batch Migration - GSE',
389: p_token1 => 'REC',
390: p_token2 => 'KEY',
391: p_token3 => 'KEYVAL',
392: p_param1 => 'gmd_sampling_events',
393: p_param2 => 'sampling_event_id',
394: p_param3 => to_char(l_sam_event.sampling_event_id),
395: p_app_short_name => 'GMD');
396: