APPS.GME_INSERT_STEP_PVT SQL Statements

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

Line: 4

   g_pkg_name   CONSTANT VARCHAR2 (30) := 'GME_API_INSERT_STEP';

Line: 6

   PROCEDURE insert_batch_step (
      p_gme_batch_header   IN              gme_batch_header%ROWTYPE
     ,p_gme_batch_step     IN              gme_batch_steps%ROWTYPE
     ,x_gme_batch_step     OUT NOCOPY      gme_batch_steps%ROWTYPE
     ,x_return_status      OUT NOCOPY      VARCHAR2)
   IS
      CURSOR get_steps_count (v_batchstep_no NUMBER, v_batch_id NUMBER)
      IS
         SELECT COUNT (*)
           FROM gme_batch_steps
          WHERE batch_id = v_batch_id
            AND batchstep_no = v_batchstep_no
            AND delete_mark = 0;

Line: 24

         SELECT organization_code
            FROM mtl_parameters
            WHERE organization_id = p_org_id ;

Line: 31

         SELECT conversion_rate, uom_class
           FROM mtl_uom_conversions
          WHERE uom_code = v_um_code
	   AND  inventory_item_id = 0;

Line: 38

         SELECT 1
         FROM   sys.DUAL
         WHERE  EXISTS ( SELECT 1
                         FROM   gme_text_header
                         WHERE  text_code = v_text_code);

Line: 82

      batch_step_update_error     EXCEPTION;

Line: 88

         gme_debug.put_line ('Begin Insert_Batch_Step');

Line: 173

                (   'Insert_Batch_Step... GMD_FETCH_OPRN.FETCH_OPRN returned '
                 || l_recipe_rout_act.COUNT
                 || ' ACTIVITIES');

Line: 177

                (   'Insert_Batch_Step... GMD_FETCH_OPRN.FETCH_OPRN returned '
                 || l_recipe_rout_resc.COUNT
                 || ' RESOURCES');

Line: 183

               (   'Insert_Batch_Step... GMD_FETCH_OPRN.FETCH_OPRN returned '
                || l_recipe_rout_act (i).oprn_id
                || ' operation_id');

Line: 187

                (   'Insert_Batch_Step... GMD_FETCH_OPRN.FETCH_OPRN returned '
                 || l_recipe_rout_act (i).minimum_transfer_qty
                 || ' minimum_transfer_qty at Activity '||l_recipe_rout_act (i).activity);

Line: 200

               ('Insert_Batch Step - GMD_FETCH_OPRN.FETCH_OPRN returned no activities');

Line: 209

               ('Insert_Batch Step - GMD_FETCH_OPRN.FETCH_OPRN returned no resources');

Line: 225

      SELECT minimum_transfer_qty, process_qty_uom
        INTO l_recipe_rout_step (1).minimum_transfer_qty,
             l_recipe_rout_step (1).process_qty_uom
        FROM gmd_operations_b
       WHERE oprn_id = p_gme_batch_step.oprn_id;

Line: 247

      /* SELECT process_qty_um
        INTO l_recipe_rout_step (1).process_qty_uom
        FROM gmd_operations
       WHERE oprn_id = p_gme_batch_step.oprn_id;*/

Line: 365

      IF NOT (gme_batch_steps_dbl.update_row (p_batch_step      => x_gme_batch_step) ) THEN
         RAISE batch_step_update_error;

Line: 370

      gme_common_pvt.log_message ('GME_INSERT_BATCH_STEP_SUCCESS');

Line: 374

         gme_debug.put_line ('End Insert_Batch_Step');

Line: 379

            gme_debug.put_line ('insert_step --> invalid batch status');

Line: 383

         gme_common_pvt.log_message ('GME_INV_STATUS_INSERT_STEP');

Line: 386

            gme_debug.put_line ('insert_step --> no oprn passed');

Line: 395

            gme_debug.put_line ('insert_step --> step qty < zero');

Line: 403

            gme_debug.put_line ('insert_step --> no ORGANIZATION_ID supplied');

Line: 419

      WHEN batch_step_fetch_error OR batch_step_update_error THEN
         IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
            gme_debug.put_line
                              (fnd_msg_pub.get (p_encoded      => fnd_api.g_false) );

Line: 432

            gme_debug.put_line (   'GME insert_step API -- when others '
                                || SQLERRM);

Line: 437

         fnd_msg_pub.add_exc_msg ('GME_API_INSERT_STEP', 'INSERT_BATCH_STEP');

Line: 438

   END insert_batch_step;

Line: 467

         SELECT max_capacity, capacity_um   --Bug#5231180 changed to capacity um
           FROM cr_rsrc_mst
          WHERE resources = p_rsrc
            AND delete_mark = 0
            AND capacity_constraint = 1;

Line: 476

         SELECT std_factor, um_type
           FROM sy_uoms_mst
          WHERE um_code = v_um_code; */

Line: 481

         SELECT conversion_rate, uom_class
           FROM mtl_uom_conversions
          WHERE uom_code = v_um_code
	   AND  inventory_item_id = 0;

Line: 491

         gme_debug.put_line ('Insert_batch_step... BEGIN calc max cap');

Line: 547

                   gme_debug.put_line('GME insert_step API calc_max_cap --> resources in diff UOM types...');

Line: 589

         gme_debug.put_line ('Insert_batch_step... END calc max cap');

Line: 597

                      (   'GME insert_step API calc_max_cap --> when others '
                       || SQLERRM);