APPS.MTL_LOT_CONV_AUDIT_PKG SQL Statements

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

Line: 5

PROCEDURE INSERT_ROW(
  X_CONV_AUDIT_ID           IN OUT NOCOPY NUMBER,
  X_CONVERSION_ID           IN NUMBER,
  X_CONVERSION_DATE         IN DATE,
  X_UPDATE_TYPE_INDICATOR   IN NUMBER,
  X_BATCH_ID                IN NUMBER,
  X_REASON_ID               IN NUMBER,
  X_OLD_CONVERSION_RATE     IN NUMBER,
  X_NEW_CONVERSION_RATE     IN NUMBER,
  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_return_status           OUT NOCOPY VARCHAR2,
  x_msg_count               OUT NOCOPY NUMBER,
  x_msg_data                OUT NOCOPY VARCHAR2)

IS


CURSOR GET_AUDIT_SEQ
IS
SELECT MTL_CONV_AUDIT_ID_S.NEXTVAL
FROM FND_DUAL;

Line: 44

  INSERT INTO MTL_LOT_CONV_AUDIT (
    CONV_AUDIT_ID,
    CONVERSION_ID,
    CONVERSION_DATE,
    UPDATE_TYPE_INDICATOR,
    BATCH_ID,
    REASON_ID,
    OLD_CONVERSION_RATE,
    NEW_CONVERSION_RATE,
    EVENT_SPEC_DISP_ID,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN
    )
  VALUES (
    X_CONV_AUDIT_ID,
    X_CONVERSION_ID,
    X_CONVERSION_DATE,
    X_UPDATE_TYPE_INDICATOR,
    X_BATCH_ID,
    X_REASON_ID,
    X_OLD_CONVERSION_RATE,
    X_NEW_CONVERSION_RATE,
    X_EVENT_SPEC_DISP_ID,
    X_CREATED_BY,
    X_CREATION_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATE_LOGIN
  );

Line: 93

END INSERT_ROW;

Line: 96

PROCEDURE UPDATE_ROW(
  X_CONV_AUDIT_ID           IN NUMBER,
  X_CONVERSION_ID           IN NUMBER,
  X_CONVERSION_DATE         IN DATE,
  X_UPDATE_TYPE_INDICATOR   IN NUMBER,
  X_BATCH_ID                IN NUMBER,
  X_REASON_ID               IN NUMBER,
  X_OLD_CONVERSION_RATE     IN NUMBER,
  X_NEW_CONVERSION_RATE     IN NUMBER,
  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_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: 119

  UPDATE MTL_LOT_CONV_AUDIT SET
    CONVERSION_ID = X_CONVERSION_ID,
    CONVERSION_DATE = X_CONVERSION_DATE,
    UPDATE_TYPE_INDICATOR = X_UPDATE_TYPE_INDICATOR,
    BATCH_ID = X_BATCH_ID,
    REASON_ID = X_REASON_ID,
    OLD_CONVERSION_RATE = X_OLD_CONVERSION_RATE,
    NEW_CONVERSION_RATE = X_NEW_CONVERSION_RATE,
    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
    WHERE CONV_AUDIT_ID = X_CONV_AUDIT_ID;

Line: 151

END UPDATE_ROW;