APPS.GME_REVERT_STEP_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 42

         SELECT batchstep_no, s.step_status,d.dep_type,d.standard_delay, s.steprelease_type
         FROM   gme_batch_step_dependencies d, gme_batch_steps s
         WHERE  d.batchstep_id = s.batchstep_id AND
                d.dep_step_id = v_batchstep_id AND
                s.batch_id = v_batch_id AND
                d.batch_id = s.batch_id;

Line: 51

       SELECT D.*
       FROM   gme_batch_step_items i, gme_material_details d
         WHERE  d.batch_id = v_batch_id AND
                i.material_detail_id = d.material_detail_id AND
                i.batchstep_id = v_batchstep_id AND
                d.release_type = 3
      FOR UPDATE OF actual_qty NOWAIT;

Line: 146

      IF NOT (gme_batch_steps_dbl.update_row (l_batch_step_rec)) THEN
         RAISE batch_step_upd_err;

Line: 171

                gme_debug.put_line ('batch update inventory '
                                      ||l_batch_header_rec.update_inventory_ind);

Line: 187

      UPDATE gme_batch_step_activities
      SET    actual_cmplt_date = NULL
             ,last_updated_by     = gme_common_pvt.g_user_ident
             ,last_update_date    = gme_common_pvt.g_timestamp
             ,last_update_login   = gme_common_pvt.g_login_id
      WHERE  batchstep_id = l_batch_step_rec.batchstep_id
             AND batch_id = p_batch_header_rec.batch_id;

Line: 196

      UPDATE gme_batch_step_resources
      SET    actual_cmplt_date = NULL
             ,last_updated_by     = gme_common_pvt.g_user_ident
             ,last_update_date    = gme_common_pvt.g_timestamp
             ,last_update_login   = gme_common_pvt.g_login_id
      WHERE  batchstep_id = l_batch_step_rec.batchstep_id;