APPS.GME_CANCEL_STEP_PVT SQL Statements

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

Line: 40

     ,p_update_inventory_ind   IN              VARCHAR2
     ,x_batch_step_rec         OUT NOCOPY      gme_batch_steps%ROWTYPE
     ,x_return_status          OUT NOCOPY      VARCHAR2)
   IS
      /* Miscellaneous */
      l_resource_tab               gme_common_pvt.number_tab;

Line: 56

         SELECT batchstep_resource_id
           FROM gme_batch_step_resources
          WHERE batchstep_id = v_batchstep_id;

Line: 74

      IF p_update_inventory_ind = 'Y' THEN
         /* Get all the resources associated with the step */
         OPEN cur_get_resource_ids (x_batch_step_rec.batchstep_id);

Line: 99

                                      || ' Calling  resource delete_row');

Line: 102

               IF NOT (gme_resource_txns_gtmp_dbl.update_row
                                   (p_resource_txns      => l_resource_txns_tab
                                                                           (j) ) ) THEN
                  RAISE resource_txns_gtmp_del_err;

Line: 109

      END IF;                            /* IF p_update_inventory_ind = 'Y' */

Line: 119

                             || ' Calling step update_row');

Line: 122

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