APPS.GME_REOPEN_STEP_PVT SQL Statements

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

Line: 68

            IF NOT (gme_batch_steps_dbl.update_row
                                        (p_batch_step      => l_batch_steps_tab
                                                                           (i) ) ) THEN
               RAISE batch_step_upd_err;

Line: 154

         SELECT batch_status, automatic_step_calculation
               ,enforce_step_dependency
           FROM gme_batch_header
          WHERE batch_id = l_batch_id;

Line: 161

         SELECT COUNT (*)
           FROM gme_batch_step_dependencies gbsd, gme_batch_steps gbs
          WHERE gbs.batchstep_id = gbsd.batchstep_id
            AND gbsd.dep_step_id = l_batchstep_id
            AND gbs.batch_id = l_batch_id
            AND gbsd.batch_id = gbs.batch_id
            AND gbsd.dep_type = 0
            AND gbs.step_status = 4;

Line: 219

      IF NOT (gme_batch_steps_dbl.update_row (p_batch_step      => x_batch_step_rec) ) THEN
         RAISE batch_step_upd_err;

Line: 223

      x_batch_step_rec.last_update_date := gme_common_pvt.g_timestamp;

Line: 224

      x_batch_step_rec.last_updated_by := gme_common_pvt.g_user_ident;

Line: 225

      x_batch_step_rec.last_update_login := gme_common_pvt.g_login_id;