APPS.GMD_QC_MIGB12 dependencies on GMD_WIP_SPEC_VRS

Line 134: ELSE -- gmd_wip_spec_vrs

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';
137: END IF;
138:

Line 135: l_record := 'gmd_wip_spec_vrs';

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';
137: END IF;
138:
139: -- Bug# 5559748 Changed FND_LOG.LEVEL_UNEXPECTED to LEVEL_ERROR

Line 165: ELSE -- gmd_wip_spec_vrs

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';
168: END IF;
169:

Line 166: l_record := 'gmd_wip_spec_vrs';

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';
168: END IF;
169:
170: -- Bug# 5559748 Changed FND_LOG.LEVEL_UNEXPECTED to LEVEL_ERROR

Line 272: Cursor to get gmd_wip_spec_vrs.

268:
269: l_new_step_id gme_batch_steps.batchstep_id%TYPE;
270:
271: /*=====================================
272: Cursor to get gmd_wip_spec_vrs.
273: =====================================*/
274:
275: CURSOR get_wip_spec IS
276: SELECT step_no, step_id, material_detail_id, spec_vr_id

Line 277: FROM gmd_wip_spec_vrs

273: =====================================*/
274:
275: CURSOR get_wip_spec IS
276: SELECT step_no, step_id, material_detail_id, spec_vr_id
277: FROM gmd_wip_spec_vrs
278: WHERE batch_id = l_mig_batch.old_batch_id;
279:
280: l_wip_spec get_wip_spec%ROWTYPE;
281:

Line 415: Check for batch in gmd_wip_spec_vrs.

411:
412: END LOOP; -- end loop for get_sampling_event.
413:
414: /*=========================================
415: Check for batch in gmd_wip_spec_vrs.
416: =========================================*/
417: FOR l_wip_spec IN get_wip_spec LOOP
418: BEGIN -- begin for get_wip_spec
419: l_new_step_id := NULL;

Line 444: gmd_wip_spec_vrs record.

440: IF (l_mat_exception_count > 0) THEN
441: RAISE NO_WIP_MATL_ID;
442: /*==================================
443: Raise exception to to to next
444: gmd_wip_spec_vrs record.
445: Error logged in called routine.
446: ==================================*/
447: END IF;
448: END IF;

Line 450: UPDATE gmd_wip_spec_vrs

446: ==================================*/
447: END IF;
448: END IF;
449:
450: UPDATE gmd_wip_spec_vrs
451: SET batch_id = l_mig_batch.new_batch_id,
452: step_id = l_new_step_id,
453: material_detail_id = l_new_det_id
454: WHERE spec_vr_id = l_wip_spec.spec_vr_id;

Line 477: p_param1 => 'gmd_wip_spec_vrs',

473: p_context => 'Quality Batch Migration - GWS',
474: p_token1 => 'REC',
475: p_token2 => 'KEY',
476: p_token3 => 'KEYVAL',
477: p_param1 => 'gmd_wip_spec_vrs',
478: p_param2 => 'spec_vr_id',
479: p_param3 => to_char(l_wip_spec.spec_vr_id),
480: p_app_short_name => 'GMD');
481: