eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GME_RELEASE_BATCH_STEP_PVT SQL Statements

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

Line: 17


  x_batch_step_rec   Output updated batch step record.
  x_exception_material_tbl Table of records of exceptions found while releasing the step, any dependent steps
                           and possibly the batch (if it was released).
  x_return_status    outcome of the API call
            S - Success
            E - Error
            U - Unexpected error
            X - Exceptions found
=============================================================================================*/
   PROCEDURE release_step (
      p_batch_step_rec           IN              gme_batch_steps%ROWTYPE
     ,p_batch_header_rec         IN              gme_batch_header%ROWTYPE
     ,x_batch_step_rec           OUT NOCOPY      gme_batch_steps%ROWTYPE
     ,x_exception_material_tbl   IN OUT NOCOPY   gme_common_pvt.exceptions_tab
     ,x_return_status            OUT NOCOPY      VARCHAR2)
   IS
      l_api_name      CONSTANT VARCHAR2 (30)              := 'RELEASE_STEP';

Line: 144


  x_batch_step_rec   Output updated batch step record.
  x_exception_material_tbl Table of records of exceptions found while releasing the step, any dependent steps
  x_return_status    outcome of the API call
            S - Success
            E - Error
            U - Unexpected error
            X - Exception found
=============================================================================================*/
   PROCEDURE release_step_recursive (
      p_batch_step_rec           IN              gme_batch_steps%ROWTYPE
     ,p_batch_header_rec         IN              gme_batch_header%ROWTYPE
     ,x_batch_step_rec           OUT NOCOPY      gme_batch_steps%ROWTYPE
     ,x_exception_material_tbl   IN OUT NOCOPY   gme_common_pvt.exceptions_tab
     ,x_return_status            OUT NOCOPY      VARCHAR2)
   IS
      l_api_name       CONSTANT VARCHAR2 (30)   := 'release_step_recursive';

Line: 163


      update_step_qty_error     EXCEPTION;

Line: 243


                 ,p_update_inv_ind              => p_batch_header_rec.update_inventory_ind
                 ,x_exception_material_tbl      => x_exception_material_tbl
                 ,x_return_status               => l_return_status);

Line: 257


      /* Invoke the update step qty API to update the step quantities and the */
      /* quantities of the succeeding steps                                   */
      l_in_batch_step_rec := x_batch_step_rec;

Line: 260


      gme_update_step_qty_pvt.update_step_qty
                                     (p_batch_step_rec      => l_in_batch_step_rec
                                     ,x_message_count       => l_msg_count
                                     ,x_message_list        => l_msg_stack
                                     ,x_return_status       => l_return_status
                                     ,x_batch_step_rec      => x_batch_step_rec);

Line: 268


         RAISE update_step_qty_error;

Line: 286


      WHEN update_step_qty_error THEN
         x_return_status := l_return_status;

Line: 315


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

Line: 546


  This procedure releases the step and updates actual dates for activity and resource.
Parameters
  p_batch_step_rec       Input Batch Step Line
  p_batch_header_rec     Batch Header that step belongs to
  x_batch_step_rec       Output Batch Step Line
  x_return_status        outcome of the API call
            S - Success
            E - Error
            U - Unexpected error
 History
     G. Muratore     27-MAR-2012  Bug 13706812
        Improved performance of activities cursor. This issue was found by migration testing.
=============================================================================================*/
   PROCEDURE release_step_line (
      p_batch_step_rec           IN              gme_batch_steps%ROWTYPE
     ,x_batch_step_rec           OUT NOCOPY      gme_batch_steps%ROWTYPE
     ,x_exception_material_tbl   IN OUT NOCOPY   gme_common_pvt.exceptions_tab
     ,x_return_status            OUT NOCOPY      VARCHAR2)
   IS
      l_api_name   CONSTANT VARCHAR2 (30)             := 'release_step_line';

Line: 586


      /*  Update the Batch Step Status to WIP */
      x_batch_step_rec.step_status := gme_common_pvt.g_step_wip;

Line: 590


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

Line: 595


      x_batch_step_rec.last_updated_by := gme_common_pvt.g_user_ident;

Line: 596


      x_batch_step_rec.last_update_date := gme_common_pvt.g_timestamp;

Line: 597


      x_batch_step_rec.last_update_login := gme_common_pvt.g_login_id;

Line: 602


      UPDATE gme_batch_step_activities
         SET actual_start_date = x_batch_step_rec.actual_start_date
            ,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 = x_batch_step_rec.batchstep_id
         AND batch_id = x_batch_step_rec.batch_id;

Line: 612


      UPDATE gme_batch_step_resources
         SET actual_start_date = x_batch_step_rec.actual_start_date
            ,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 = x_batch_step_rec.batchstep_id;

Line: 645


     ,p_update_inv_ind           IN            VARCHAR2
     ,x_exception_material_tbl   IN OUT NOCOPY gme_common_pvt.exceptions_tab
     ,x_return_status            OUT NOCOPY    VARCHAR2)
   IS
      CURSOR cur_step_ingredients (v_batchstep_id NUMBER)
      IS
         SELECT matl.*
           FROM gme_material_details matl, gme_batch_step_items item
          WHERE item.batchstep_id = v_batchstep_id
            AND item.material_detail_id = matl.material_detail_id
            AND matl.line_type = gme_common_pvt.g_line_type_ing
            AND matl.release_type = gme_common_pvt.g_mtl_autobystep_release;

Line: 710


                          ,p_update_inv_ind              => p_update_inv_ind
                          ,x_exception_material_tbl      => x_exception_material_tbl
                          ,x_return_status               => l_return_status);

Line: 756


         SELECT *
          FROM gmd_recipe_validity_rules
          WHERE recipe_validity_rule_id = v_recipe_validity_rule_id;

Line: 762


         SELECT status_type
          FROM gmd_status
          WHERE status_code=v_validity_rule_status;