APPS.WMA_INV_WRAPPERS SQL Statements

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

Line: 28

      select expiration_date
        into x_lot_exp
        from mtl_lot_numbers
       where lot_number = p_lot_number
         and inventory_item_id = p_inventory_item_id
         and organization_id = p_organization_id;

Line: 40

  PROCEDURE insertLot(p_header_id     IN NUMBER,
                      p_lot_number    IN VARCHAR2,
                      x_return_status OUT NOCOPY VARCHAR2,
                      x_err_msg       OUT NOCOPY VARCHAR2) IS
  l_msg_count NUMBER;

Line: 46

    WMS_WIP_INTEGRATION.insert_lot(p_header_id     => p_header_id,
                                   p_lot_number    => p_lot_number,
                                   x_return_status => x_return_status,
                                   x_msg_count     => l_msg_count,
                                   x_msg_data      => x_err_msg);

Line: 58

  end insertLot;

Line: 64

      select lot_number
        from wip_lpn_completions_lots
       where header_id = v_header_id;

Line: 74

        wms_wip_integration.insert_lot(p_header_id, lots_rec.lot_number,  x_return_status, l_msg_count, x_err_msg);

Line: 88

  PROCEDURE updateSerials(p_header_id IN NUMBER,
                          x_err_msg   OUT NOCOPY VARCHAR2,
                          x_return_status   OUT NOCOPY VARCHAR2) IS
  cursor serials(v_header_id NUMBER) IS
    select fm_serial_number
      from wip_lpn_completions_serials
     where header_id = v_header_id;

Line: 102

      wms_wip_integration.update_serial(p_header_id     => p_header_id,
                                        p_serial_number => serials_rec.fm_serial_number,
                                        x_return_status => x_return_status,
                                        x_msg_count     => l_msg_count,
                                        x_msg_data      => x_err_msg);

Line: 118

  END updateSerials;

Line: 120

  PROCEDURE updateLSAttributes(p_header_id       IN NUMBER,
                               x_return_status   OUT NOCOPY VARCHAR2,
                               x_err_msg         OUT NOCOPY VARCHAR2) IS BEGIN
    x_return_status := fnd_api.G_RET_STS_SUCCESS;

Line: 126

      updateSerials(p_header_id, x_err_msg, x_return_status);

Line: 131

  end updateLSAttributes;

Line: 326

    wms_wip_integration.update_mo_line(p_lpn_id => p_lpn_id,
                                       p_wms_process_flag => 1,
                                       x_return_status => x_return_status,
                                       x_msg_count => l_msg_count,
                                       x_msg_data => x_err_msg);

Line: 339

  PROCEDURE updateLpnContext(p_api_version   IN NUMBER,
                             p_init_msg_list IN VARCHAR2,
                             p_commit        IN VARCHAR2,
                             p_lpn_id        IN NUMBER,
                             p_lpn_context   IN NUMBER,
                             x_return_status OUT NOCOPY VARCHAR2,
                             x_err_msg       OUT NOCOPY VARCHAR2) IS
  lpnRec WMS_CONTAINER_PUB.LPN;

Line: 366

  END updateLpnContext;

Line: 405

    update wip_lpn_completions
       set subinventory_code = p_subinventory_code,
           locator_id        = p_locator_id
     where header_id = p_header_id
    returning wip_entity_id, organization_id, inventory_item_id, wip_entity_type
      into l_wipID, l_orgID, l_itemID, l_entityType;

Line: 433

      select count(*)
        into l_ctoItemCount
        from mtl_system_items
       where inventory_item_id = l_itemID
         and organization_id = l_orgID
         and build_in_wip_flag = 'Y'
         and base_item_id is not null
         and bom_item_type = wip_constants.standard_type
         and replenish_to_order_flag = 'Y';

Line: 444

      select count(*)
      into l_soExistsFlag
      from wip_lpn_completions
      where header_id = p_header_id
        and demand_source_header_id is not null
        and demand_source_line is not null;