APPS.GME_TERMINATE_STEP_PVT SQL Statements

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

Line: 33

     ,p_update_inventory_ind   IN              VARCHAR2
     ,p_actual_cmplt_date      IN              DATE
     ,x_batch_step_rec         OUT NOCOPY      gme_batch_steps%ROWTYPE
     ,x_return_status          OUT NOCOPY      VARCHAR2)
   IS
      /* Variable Declarations */
      l_resource_txns              gme_resource_txns_gtmp%ROWTYPE;

Line: 53

         SELECT *
           FROM gme_batch_step_resources
          WHERE batchstep_id = v_batchstep_id;

Line: 59

         SELECT *
           FROM gme_batch_step_activities
          WHERE batchstep_id = v_batchstep_id;

Line: 86

      DELETE FROM gme_batch_step_rsrc_summary
            WHERE batchstep_id = x_batch_step_rec.batchstep_id;

Line: 111

         IF NOT (gme_batch_step_activities_dbl.update_row
                                                         (l_activities_tab (i) ) ) THEN
            RAISE activity_upd_err;

Line: 141

         IF NOT (gme_batch_step_resources_dbl.update_row (l_resources_tab (i) ) ) THEN
            RAISE resource_upd_err;

Line: 145

         IF (p_update_inventory_ind = 'Y') THEN
            l_resource_txns.line_id :=
                                    l_resources_tab (i).batchstep_resource_id;

Line: 164

                                    || 'Calling  resource txn update)delete_row');

Line: 167

                  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: 174

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

Line: 203

                             || ' Calling  batch step update_row');

Line: 206

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