APPS.GME_COMPLETE_BATCH_PVT SQL Statements

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

Line: 19

    SELECT step_status
      FROM gme_batch_steps s, gme_batch_step_items item
     WHERE s.batchstep_id = item.batchstep_id
       AND item.material_detail_id = v_matl_dtl_id;

Line: 25

    SELECT *
      FROM gme_batch_steps
     WHERE batch_id = v_batch_id
       AND step_status NOT IN (gme_common_pvt.g_step_completed, gme_common_pvt.g_step_closed);

Line: 31

    SELECT hdr.*
      FROM gme_material_details dtl, gme_batch_header hdr
     WHERE dtl.batch_id = v_batch_id
       AND dtl.line_type = gme_common_pvt.g_line_type_ing
       AND dtl.phantom_id IS NOT NULL
       AND hdr.batch_id = dtl.phantom_id
       AND hdr.batch_status NOT IN (gme_common_pvt.g_batch_completed, gme_common_pvt.g_batch_closed);

Line: 40

    SELECT *
      FROM gme_material_details
     WHERE batch_id = v_batch_id
       AND (line_type = gme_common_pvt.g_line_type_ing OR
            (line_type = gme_common_pvt.g_line_type_prod AND phantom_line_id IS NOT NULL))
       FOR UPDATE OF actual_qty NOWAIT;

Line: 48

    SELECT *
      FROM gme_material_details
     WHERE batch_id = v_batch_id
       AND line_type IN (gme_common_pvt.g_line_type_prod,gme_common_pvt.g_line_type_byprod)
       AND phantom_line_id IS NULL  -- no phantom products
       FOR UPDATE OF actual_qty NOWAIT;

Line: 80

    error_update_batch       EXCEPTION;

Line: 125

    IF NOT gme_batch_header_dbl.update_row (p_batch_header => x_batch_header_rec) THEN
      RAISE error_update_batch;

Line: 130

    x_batch_header_rec.last_updated_by := gme_common_pvt.g_user_ident;

Line: 131

    x_batch_header_rec.last_update_date := gme_common_pvt.g_timestamp;

Line: 132

    x_batch_header_rec.last_update_login := gme_common_pvt.g_login_id;

Line: 180

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

Line: 194

	 -- This will insert exception all completed step products and byprodcuts.
     --Bug#5296812  Added the call to the item record.Added the condition to check the inv update ind,and transaction ind.Start
	    gme_material_detail_pvt.get_item_rec
                        (p_org_id                => l_matl_dtl_rec.organization_id
                        ,p_item_id               => l_matl_dtl_rec.inventory_item_id
                        ,x_item_rec              => l_item_rec
                        ,x_return_status         => l_return_status);

Line: 205

      IF p_batch_header_rec.update_inventory_ind = 'Y' AND l_item_rec.mtl_transactions_enabled_flag = 'Y' THEN
       --Bug#5296812 End.
       IF l_step_status = gme_common_pvt.g_step_completed THEN

           l_exception_qty := l_matl_dtl_rec.wip_plan_qty - l_matl_dtl_rec.actual_qty;

Line: 242

       END IF;--IF p_batch_header_rec.update_inventory_ind = 'Y'.....

Line: 317

       IF p_batch_header_rec.update_inventory_ind = 'Y' AND
         l_item_rec.mtl_transactions_enabled_flag = 'Y' THEN
       --Bug#5296812 End.
        l_exception_qty := l_matl_dtl_rec.wip_plan_qty - l_matl_dtl_rec.actual_qty;

Line: 351

       END IF; --IF p_batch_header_rec.update_inventory_ind = 'Y'...

Line: 369

  WHEN  error_update_batch THEN
    gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR', SQLERRM);

Line: 396

              ,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


    l_api_name               CONSTANT   VARCHAR2 (30)                := 'process_material';

Line: 415

    error_update_row              EXCEPTION;

Line: 484

      IF p_update_inv_ind = 'Y' AND
         l_item_rec.mtl_transactions_enabled_flag = 'Y' THEN
        l_start_actual_qty := l_matl_dtl_rec.actual_qty;

Line: 551

       IF p_update_inv_ind = 'Y' AND l_item_rec.mtl_transactions_enabled_flag = 'Y' THEN
       --Bug#5296812 End.
        l_exception_qty := l_matl_dtl_rec.wip_plan_qty - l_matl_dtl_rec.actual_qty;

Line: 584

      END IF;--IF p_update_inv_ind = 'Y' AND...

Line: 590

    IF NOT gme_material_details_dbl.update_row (l_matl_dtl_rec) THEN
      RAISE error_update_row;

Line: 599

  WHEN error_fetch_batch OR error_update_row THEN
    gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR', SQLERRM);

Line: 639

    SELECT revision
      FROM mtl_item_revisions_b
     WHERE inventory_item_id = v_item_id
       AND organization_id = v_org_id
       AND effectivity_date <= gme_common_pvt.g_timestamp
     ORDER BY effectivity_date desc;

Line: 1089

      SELECT count(1)
      FROM   gme_batch_steps
      WHERE  step_status NOT IN (gme_common_pvt.g_step_completed, gme_common_pvt.g_step_closed)
      AND    batch_id = v_batch_id
      AND    rownum = 1;

Line: 1099

         SELECT *
          FROM gmd_recipe_validity_rules
          WHERE recipe_validity_rule_id = v_recipe_validity_rule_id;

Line: 1105

         SELECT status_type
          FROM gmd_status
          WHERE status_code=v_validity_rule_status;