APPS.AHL_UNIT_THRESHOLDS_PKG SQL Statements

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

Line: 6

PROCEDURE insert_row (
  P_X_UNIT_THRESHOLD_ID        IN OUT NOCOPY NUMBER,
  P_UNIT_DEFERRAL_ID           IN     NUMBER,
  P_COUNTER_ID                 IN     NUMBER,
  P_COUNTER_VALUE              IN     NUMBER,
  P_CTR_VALUE_TYPE_CODE        IN     VARCHAR2,
  P_ATTRIBUTE_CATEGORY         IN     VARCHAR2,
  P_ATTRIBUTE1                 IN     VARCHAR2,
  P_ATTRIBUTE2                 IN     VARCHAR2,
  P_ATTRIBUTE3                 IN     VARCHAR2,
  P_ATTRIBUTE4                 IN     VARCHAR2,
  P_ATTRIBUTE5                 IN     VARCHAR2,
  P_ATTRIBUTE6                 IN     VARCHAR2,
  P_ATTRIBUTE7                 IN     VARCHAR2,
  P_ATTRIBUTE8                 IN     VARCHAR2,
  P_ATTRIBUTE9                 IN     VARCHAR2,
  P_ATTRIBUTE10                IN     VARCHAR2,
  P_ATTRIBUTE11                IN     VARCHAR2,
  P_ATTRIBUTE12                IN     VARCHAR2,
  P_ATTRIBUTE13                IN     VARCHAR2,
  P_ATTRIBUTE14                IN     VARCHAR2,
  P_ATTRIBUTE15                IN     VARCHAR2,
  P_OBJECT_VERSION_NUMBER      IN     NUMBER,
  P_LAST_UPDATE_DATE           IN     DATE,
  P_LAST_UPDATED_BY            IN     NUMBER,
  P_CREATION_DATE              IN     DATE,
  P_CREATED_BY                 IN     NUMBER,
  P_LAST_UPDATE_LOGIN          IN     NUMBER
) IS

BEGIN
  insert into ahl_unit_thresholds(
  UNIT_THRESHOLD_ID,
  UNIT_DEFERRAL_ID,
  COUNTER_ID,
  COUNTER_VALUE,
  CTR_VALUE_TYPE_CODE,
  ATTRIBUTE_CATEGORY,
  ATTRIBUTE1,
  ATTRIBUTE2,
  ATTRIBUTE3,
  ATTRIBUTE4,
  ATTRIBUTE5,
  ATTRIBUTE6,
  ATTRIBUTE7,
  ATTRIBUTE8,
  ATTRIBUTE9,
  ATTRIBUTE10,
  ATTRIBUTE11,
  ATTRIBUTE12,
  ATTRIBUTE13,
  ATTRIBUTE14,
  ATTRIBUTE15,
  OBJECT_VERSION_NUMBER,
  LAST_UPDATE_DATE,
  LAST_UPDATED_BY,
  CREATION_DATE,
  CREATED_BY,
  LAST_UPDATE_LOGIN
  ) values (
  AHL_UNIT_THRESHOLDS_S.NEXTVAL,
  P_UNIT_DEFERRAL_ID,
  P_COUNTER_ID,
  P_COUNTER_VALUE,
  P_CTR_VALUE_TYPE_CODE,
  P_ATTRIBUTE_CATEGORY,
  P_ATTRIBUTE1,
  P_ATTRIBUTE2,
  P_ATTRIBUTE3,
  P_ATTRIBUTE4,
  P_ATTRIBUTE5,
  P_ATTRIBUTE6,
  P_ATTRIBUTE7,
  P_ATTRIBUTE8,
  P_ATTRIBUTE9,
  P_ATTRIBUTE10,
  P_ATTRIBUTE11,
  P_ATTRIBUTE12,
  P_ATTRIBUTE13,
  P_ATTRIBUTE14,
  P_ATTRIBUTE15,
  P_OBJECT_VERSION_NUMBER,
  P_LAST_UPDATE_DATE,
  P_LAST_UPDATED_BY,
  P_CREATION_DATE,
  P_CREATED_BY,
  P_LAST_UPDATE_LOGIN
  ) RETURNING UNIT_THRESHOLD_ID INTO P_X_UNIT_THRESHOLD_ID;

Line: 95

END insert_row;

Line: 99

PROCEDURE update_row (
  P_UNIT_THRESHOLD_ID          IN     NUMBER,
  P_UNIT_DEFERRAL_ID           IN     NUMBER,
  P_COUNTER_ID                 IN     NUMBER,
  P_COUNTER_VALUE              IN     NUMBER,
  P_CTR_VALUE_TYPE_CODE        IN     VARCHAR2,
  P_ATTRIBUTE_CATEGORY         IN     VARCHAR2,
  P_ATTRIBUTE1                 IN     VARCHAR2,
  P_ATTRIBUTE2                 IN     VARCHAR2,
  P_ATTRIBUTE3                 IN     VARCHAR2,
  P_ATTRIBUTE4                 IN     VARCHAR2,
  P_ATTRIBUTE5                 IN     VARCHAR2,
  P_ATTRIBUTE6                 IN     VARCHAR2,
  P_ATTRIBUTE7                 IN     VARCHAR2,
  P_ATTRIBUTE8                 IN     VARCHAR2,
  P_ATTRIBUTE9                 IN     VARCHAR2,
  P_ATTRIBUTE10                IN     VARCHAR2,
  P_ATTRIBUTE11                IN     VARCHAR2,
  P_ATTRIBUTE12                IN     VARCHAR2,
  P_ATTRIBUTE13                IN     VARCHAR2,
  P_ATTRIBUTE14                IN     VARCHAR2,
  P_ATTRIBUTE15                IN     VARCHAR2,
  P_OBJECT_VERSION_NUMBER      IN     NUMBER,
  P_LAST_UPDATE_DATE           IN     DATE,
  P_LAST_UPDATED_BY            IN     NUMBER,
  P_LAST_UPDATE_LOGIN          IN     NUMBER
) IS

BEGIN
  update ahl_unit_thresholds set
  UNIT_DEFERRAL_ID = P_UNIT_DEFERRAL_ID,
  COUNTER_ID = P_COUNTER_ID,
  COUNTER_VALUE = P_COUNTER_VALUE,
  CTR_VALUE_TYPE_CODE = P_CTR_VALUE_TYPE_CODE,
  ATTRIBUTE_CATEGORY = P_ATTRIBUTE_CATEGORY,
  ATTRIBUTE1 = P_ATTRIBUTE1,
  ATTRIBUTE2 = P_ATTRIBUTE2,
  ATTRIBUTE3 = P_ATTRIBUTE3,
  ATTRIBUTE4 = P_ATTRIBUTE4,
  ATTRIBUTE5 = P_ATTRIBUTE5,
  ATTRIBUTE6 = P_ATTRIBUTE6,
  ATTRIBUTE7 = P_ATTRIBUTE7,
  ATTRIBUTE8 = P_ATTRIBUTE8,
  ATTRIBUTE9 = P_ATTRIBUTE9,
  ATTRIBUTE10 = P_ATTRIBUTE10,
  ATTRIBUTE11 = P_ATTRIBUTE11,
  ATTRIBUTE12 = P_ATTRIBUTE12,
  ATTRIBUTE13 = P_ATTRIBUTE13,
  ATTRIBUTE14 = P_ATTRIBUTE14,
  ATTRIBUTE15 = P_ATTRIBUTE15,
  OBJECT_VERSION_NUMBER = P_OBJECT_VERSION_NUMBER,
  LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,
  LAST_UPDATED_BY = P_LAST_UPDATED_BY,
  LAST_UPDATE_LOGIN = P_LAST_UPDATE_LOGIN
  where UNIT_THRESHOLD_ID = P_UNIT_THRESHOLD_ID;

Line: 159

END update_row;

Line: 163

PROCEDURE delete_row (
  P_UNIT_THRESHOLD_ID          IN     NUMBER
) IS
BEGIN

  delete from ahl_unit_thresholds
  where UNIT_THRESHOLD_ID = P_UNIT_THRESHOLD_ID;

Line: 175

END delete_row;