APPS.MTL_LOT_UOM_CONV_PKG SQL Statements

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

Line: 5

PROCEDURE INSERT_ROW(
  X_CONVERSION_ID           IN OUT NOCOPY NUMBER,
  X_LOT_NUMBER              IN VARCHAR2,
  X_ORGANIZATION_ID         IN NUMBER,
  X_INVENTORY_ITEM_ID       IN NUMBER,
  X_FROM_UNIT_OF_MEASURE    IN VARCHAR2,
  X_FROM_UOM_CODE           IN VARCHAR2,
  X_FROM_UOM_CLASS          IN VARCHAR2,
  X_TO_UNIT_OF_MEASURE      IN VARCHAR2,
  X_TO_UOM_CODE             IN VARCHAR2,
  X_TO_UOM_CLASS            IN VARCHAR2,
  X_CONVERSION_RATE         IN NUMBER,
  X_DISABLE_DATE            IN DATE,
  X_EVENT_SPEC_DISP_ID      IN NUMBER,
  X_CREATED_BY              IN NUMBER,
  X_CREATION_DATE           IN DATE,
  X_LAST_UPDATED_BY         IN NUMBER,
  X_LAST_UPDATE_DATE        IN DATE,
  X_LAST_UPDATE_LOGIN       IN NUMBER,
  X_REQUEST_ID              IN NUMBER,
  X_PROGRAM_APPLICATION_ID  IN NUMBER,
  X_PROGRAM_ID              IN NUMBER,
  X_PROGRAM_UPDATE_DATE     IN DATE,
  x_return_status           OUT NOCOPY VARCHAR2,
  x_msg_count               OUT NOCOPY NUMBER,
  x_msg_data                OUT NOCOPY VARCHAR2)

IS


CURSOR GET_CONV_SEQ
IS
SELECT MTL_CONVERSION_ID_S.NEXTVAL
FROM FND_DUAL;

Line: 54

  INSERT INTO MTL_LOT_UOM_CLASS_CONVERSIONS(
      CONVERSION_ID,
      LOT_NUMBER,
      ORGANIZATION_ID,
      INVENTORY_ITEM_ID,
      FROM_UNIT_OF_MEASURE,
      FROM_UOM_CODE,
      FROM_UOM_CLASS,
      TO_UNIT_OF_MEASURE,
      TO_UOM_CODE,
      TO_UOM_CLASS,
      CONVERSION_RATE,
      DISABLE_DATE,
      EVENT_SPEC_DISP_ID,
      CREATED_BY,
      CREATION_DATE,
      LAST_UPDATED_BY,
      LAST_UPDATE_DATE,
      LAST_UPDATE_LOGIN,
      REQUEST_ID,
      PROGRAM_APPLICATION_ID,
      PROGRAM_ID,
      PROGRAM_UPDATE_DATE
      )
  VALUES(
      X_CONVERSION_ID,
      X_LOT_NUMBER,
      X_ORGANIZATION_ID,
      X_INVENTORY_ITEM_ID,
      X_FROM_UNIT_OF_MEASURE,
      X_FROM_UOM_CODE,
      X_FROM_UOM_CLASS,
      X_TO_UNIT_OF_MEASURE,
      X_TO_UOM_CODE,
      X_TO_UOM_CLASS,
      X_CONVERSION_RATE,
      X_DISABLE_DATE,
      X_EVENT_SPEC_DISP_ID,
      X_CREATED_BY,
      X_CREATION_DATE,
      X_LAST_UPDATED_BY,
      X_LAST_UPDATE_DATE,
      X_LAST_UPDATE_LOGIN,
      X_REQUEST_ID,
      X_PROGRAM_APPLICATION_ID,
      X_PROGRAM_ID,
      X_PROGRAM_UPDATE_DATE
  );

Line: 122

END INSERT_ROW;

Line: 125

PROCEDURE UPDATE_ROW(
  X_CONVERSION_ID           IN NUMBER,
  X_LOT_NUMBER              IN VARCHAR2,
  X_ORGANIZATION_ID         IN NUMBER,
  X_INVENTORY_ITEM_ID       IN NUMBER,
  X_FROM_UNIT_OF_MEASURE    IN VARCHAR2,
  X_FROM_UOM_CODE           IN VARCHAR2,
  X_FROM_UOM_CLASS          IN VARCHAR2,
  X_TO_UNIT_OF_MEASURE      IN VARCHAR2,
  X_TO_UOM_CODE             IN VARCHAR2,
  X_TO_UOM_CLASS            IN VARCHAR2,
  X_CONVERSION_RATE         IN NUMBER,
  X_DISABLE_DATE            IN DATE,
  X_EVENT_SPEC_DISP_ID      IN NUMBER,
  X_LAST_UPDATED_BY         IN NUMBER,
  X_LAST_UPDATE_DATE        IN DATE,
  X_LAST_UPDATE_LOGIN       IN NUMBER,
  X_REQUEST_ID              IN NUMBER,
  X_PROGRAM_APPLICATION_ID  IN NUMBER,
  X_PROGRAM_ID              IN NUMBER,
  X_PROGRAM_UPDATE_DATE     IN DATE,
  x_return_status           OUT NOCOPY VARCHAR2,
  x_msg_count               OUT NOCOPY NUMBER,
  x_msg_data                OUT NOCOPY VARCHAR2)

IS

BEGIN

  x_return_status := FND_API.G_RET_STS_SUCCESS;

Line: 155

  UPDATE MTL_LOT_UOM_CLASS_CONVERSIONS SET
      LOT_NUMBER = X_LOT_NUMBER,
      ORGANIZATION_ID = X_ORGANIZATION_ID,
      INVENTORY_ITEM_ID = X_INVENTORY_ITEM_ID,
      FROM_UNIT_OF_MEASURE = X_FROM_UNIT_OF_MEASURE,
      FROM_UOM_CODE = X_FROM_UOM_CODE,
      FROM_UOM_CLASS = X_FROM_UOM_CLASS,
      TO_UNIT_OF_MEASURE = X_TO_UNIT_OF_MEASURE,
      TO_UOM_CODE = X_TO_UOM_CODE,
      TO_UOM_CLASS = X_TO_UOM_CLASS,
      CONVERSION_RATE = X_CONVERSION_RATE,
      DISABLE_DATE = X_DISABLE_DATE,
      EVENT_SPEC_DISP_ID = X_EVENT_SPEC_DISP_ID,
      LAST_UPDATED_BY = X_LAST_UPDATED_BY,
      LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
      LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
      REQUEST_ID = X_REQUEST_ID,
      PROGRAM_APPLICATION_ID = X_PROGRAM_APPLICATION_ID,
      PROGRAM_ID = X_PROGRAM_ID,
      PROGRAM_UPDATE_DATE = X_PROGRAM_UPDATE_DATE
    WHERE CONVERSION_ID = X_CONVERSION_ID;

Line: 193

END UPDATE_ROW;

Line: 197

PROCEDURE DELETE_ROW(
  X_CONVERSION_ID           IN NUMBER,
  X_DISABLE_DATE            IN DATE,
  X_LAST_UPDATED_BY         IN NUMBER,
  X_LAST_UPDATE_DATE        IN DATE,
  X_LAST_UPDATE_LOGIN       IN NUMBER,
  X_REQUEST_ID              IN NUMBER,
  X_PROGRAM_APPLICATION_ID  IN NUMBER,
  X_PROGRAM_ID              IN NUMBER,
  X_PROGRAM_UPDATE_DATE     IN DATE,
  x_return_status           OUT NOCOPY VARCHAR2,
  x_msg_count               OUT NOCOPY NUMBER,
  x_msg_data                OUT NOCOPY VARCHAR2)

IS

BEGIN

    x_return_status := FND_API.G_RET_STS_SUCCESS;

Line: 216

    UPDATE MTL_LOT_UOM_CLASS_CONVERSIONS SET
      DISABLE_DATE = X_DISABLE_DATE,
      LAST_UPDATED_BY = X_LAST_UPDATED_BY,
      LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
      LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
      REQUEST_ID = X_REQUEST_ID,
      PROGRAM_APPLICATION_ID = X_PROGRAM_APPLICATION_ID,
      PROGRAM_ID = X_PROGRAM_ID,
      PROGRAM_UPDATE_DATE = X_PROGRAM_UPDATE_DATE
    WHERE CONVERSION_ID = X_CONVERSION_ID;

Line: 244

END DELETE_ROW;

Line: 267

      SELECT        *
      FROM mtl_lot_uom_class_conversions
      WHERE conversion_id = x_conversion_id
      AND   organization_id = x_organization_id
      FOR UPDATE OF organization_id NOWAIT;

Line: 282

      fnd_message.set_name('FND', 'FORM_RECORD_DELETED');