DBA Data[Home] [Help]

APPS.GME_REROUTE_BATCH_PVT dependencies on GME_BATCH_STEP_ITEMS

Line 503: FROM gme_batch_step_items

499: (l_material_detail_rec.phantom_line_id )) THEN
500: l_phantom_associated_to_step := TRUE;
501: l_phantom_batch_step_rec.batch_id:= l_phantom_ids_tab (i);
502: SELECT batchstep_id INTO l_phantom_batch_step_rec.batchstep_id
503: FROM gme_batch_step_items
504: WHERE batch_id = l_phantom_ids_tab (i)
505: AND material_detail_id = l_material_detail_rec.phantom_line_id;
506: IF NOT gme_batch_steps_dbl.fetch_row(l_phantom_batch_step_rec, l_phantom_batch_step_rec) THEN
507: l_proc := 'gme_batch_steps_dbl.fetch_row';

Line 677: DELETE FROM gme_batch_step_items

673:
674: DELETE FROM gme_batch_step_resources
675: WHERE batch_id = p_batch_id;
676:
677: DELETE FROM gme_batch_step_items
678: WHERE batch_id = p_batch_id;
679:
680: DELETE FROM gme_batch_step_dependencies
681: WHERE batch_id = p_batch_id;