APPS.OKL_EQUIPMENT_EXCHANGE_PUB SQL Statements

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

Line: 85

  PROCEDURE update_serial_number(
       p_api_version                    IN  NUMBER,
       p_init_msg_list                  IN  VARCHAR2 DEFAULT OKL_API.G_FALSE,
       p_instance_id                    IN  NUMBER,
       p_instance_name                  IN  VARCHAR2,
       p_serial_number                  IN  VARCHAR2,
       p_inventory_item_id              IN  NUMBER,
       x_return_status                  OUT NOCOPY VARCHAR2,
       x_msg_count                      OUT NOCOPY NUMBER,
       x_msg_data                       OUT NOCOPY VARCHAR2)
  AS

    l_return_status          VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line: 113

    okl_equipment_exchange_pvt.update_serial_number (p_api_version   => p_api_version,
                                                    p_init_msg_list => p_init_msg_list,
                                                   p_instance_id      => p_instance_id,
                                                   p_instance_name    => p_instance_name,
                                                   p_serial_number    => p_serial_number,
                                                   p_inventory_item_id => p_inventory_item_id,
                                                   x_return_status => l_return_status,
                                                   x_msg_count     => l_msg_count,
                                                   x_msg_data      => l_msg_data);

Line: 156

      FND_MSG_PUB.ADD_EXC_MSG('OKL_EQUIPMENT_EXCHANGE_PUB','update_serial_number');

Line: 160

  END update_serial_number;