APPS.CN_ROLE_QUOTA_RATES_PKG SQL Statements

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

Line: 3

procedure INSERT_ROW
  (X_ROWID              IN OUT NOCOPY VARCHAR2,
   X_ROLE_QUOTA_RATE_ID IN OUT NOCOPY NUMBER,
   X_ROLE_QUOTA_CATE_ID IN     NUMBER,
   X_RATE_TIER_ID       IN     NUMBER,
   X_RATE_SCHEDULE_ID   IN     NUMBER,
   X_MIN_RATE           IN     NUMBER := NULL,
   X_MAX_RATE           IN     NUMBER := NULL,
   X_COMM_RATE          IN     NUMBER := NULL,
   X_ATTRIBUTE_CATEGORY IN     VARCHAR2 := NULL,
   X_ATTRIBUTE1         IN     VARCHAR2 := NULL,
   X_ATTRIBUTE2         IN     VARCHAR2 := NULL,
   X_ATTRIBUTE3         IN     VARCHAR2 := NULL,
   X_ATTRIBUTE4         IN     VARCHAR2 := NULL,
   X_ATTRIBUTE5         IN     VARCHAR2 := NULL,
   X_ATTRIBUTE6         IN     VARCHAR2 := NULL,
   X_ATTRIBUTE7         IN     VARCHAR2 := NULL,
   X_ATTRIBUTE8         IN     VARCHAR2 := NULL,
   X_ATTRIBUTE9         IN     VARCHAR2 := NULL,
   X_ATTRIBUTE10        IN     VARCHAR2 := NULL,
   X_ATTRIBUTE11        IN     VARCHAR2 := NULL,
   X_ATTRIBUTE12        IN     VARCHAR2 := NULL,
   X_ATTRIBUTE13        IN     VARCHAR2 := NULL,
   X_ATTRIBUTE14        IN     VARCHAR2 := NULL,
   X_ATTRIBUTE15        IN     VARCHAR2 := NULL,
   X_CREATION_DATE      IN     DATE,
   X_CREATED_BY         IN     NUMBER,
   X_LAST_UPDATE_DATE   IN     DATE,
   X_LAST_UPDATED_BY    IN     NUMBER,
   X_LAST_UPDATE_LOGIN  IN     NUMBER,
   X_OBJECT_VERSION_NUMBER  IN   NUMBER
  ) IS
     cursor C is select ROWID from cn_role_quota_rates
       where ROLE_QUOTA_RATE_ID = x_role_quota_rate_id;

Line: 38

     CURSOR id IS SELECT cn_role_quota_rates_s.NEXTVAL FROM dual;

Line: 50

   insert into CN_ROLE_QUOTA_RATES
     (ROLE_QUOTA_RATE_ID,
      ROLE_QUOTA_CATE_ID,
      RATE_TIER_ID,
      RATE_SCHEDULE_ID,
      MIN_RATE,
      MAX_RATE,
      COMM_RATE,
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15,
      LAST_UPDATE_DATE,
      LAST_UPDATED_BY,
      LAST_UPDATE_LOGIN,
      CREATION_DATE,
      created_by,
      OBJECT_VERSION_NUMBER
      )
     VALUES
     (X_ROLE_QUOTA_RATE_ID,
      X_ROLE_QUOTA_CATE_ID,
      X_RATE_TIER_ID,
      X_RATE_SCHEDULE_ID,
      X_MIN_RATE,
      X_MAX_RATE,
      X_COMM_RATE,
      X_ATTRIBUTE_CATEGORY,
      X_ATTRIBUTE1,
      X_ATTRIBUTE2,
      X_ATTRIBUTE3,
      X_ATTRIBUTE4,
      X_ATTRIBUTE5,
      X_ATTRIBUTE6,
      X_ATTRIBUTE7,
      X_ATTRIBUTE8,
      X_ATTRIBUTE9,
      X_ATTRIBUTE10,
      X_ATTRIBUTE11,
      X_ATTRIBUTE12,
      X_ATTRIBUTE13,
      X_ATTRIBUTE14,
      X_ATTRIBUTE15,
      X_LAST_UPDATE_DATE,
      X_LAST_UPDATED_BY,
      X_LAST_UPDATE_LOGIN,
      X_CREATION_DATE,
      x_created_by,
      X_OBJECT_VERSION_NUMBER
   );

Line: 121

end INSERT_ROW;

Line: 149

      cursor c1 is SELECT
  ROLE_QUOTA_CATE_ID,
  RATE_TIER_ID,
  RATE_SCHEDULE_ID,
        MIN_RATE,
  MAX_RATE,
  COMM_RATE,
  ATTRIBUTE_CATEGORY,
  ATTRIBUTE1,
  ATTRIBUTE2,
  ATTRIBUTE3,
  ATTRIBUTE4,
  ATTRIBUTE5,
  ATTRIBUTE6,
  ATTRIBUTE7,
  ATTRIBUTE8,
  ATTRIBUTE9,
  ATTRIBUTE10,
  ATTRIBUTE11,
  ATTRIBUTE12,
  ATTRIBUTE13,
  ATTRIBUTE14,
  ATTRIBUTE15,
  ROLE_QUOTA_RATE_ID,
        OBJECT_VERSION_NUMBER
  from cn_role_quota_rates
  where ROLE_QUOTA_RATE_ID = x_role_quota_rate_id
  for update of ROLE_QUOTA_RATE_ID nowait;

Line: 186

      fnd_message.set_name('CN', 'CN_RECORD_DELETED');

Line: 243

procedure UPDATE_ROW
  (X_ROLE_QUOTA_RATE_ID IN     NUMBER,
   X_ROLE_QUOTA_CATE_ID IN     NUMBER,
   X_RATE_TIER_ID       IN     NUMBER,
   X_RATE_SCHEDULE_ID   IN     NUMBER,
   X_MIN_RATE           IN     NUMBER,
   X_MAX_RATE           IN     NUMBER,
   X_COMM_RATE          IN     NUMBER,
   X_ATTRIBUTE_CATEGORY IN     VARCHAR2,
   X_ATTRIBUTE1         IN     VARCHAR2,
   X_ATTRIBUTE2         IN     VARCHAR2,
   X_ATTRIBUTE3         IN     VARCHAR2,
   X_ATTRIBUTE4         IN     VARCHAR2,
   X_ATTRIBUTE5         IN     VARCHAR2,
   X_ATTRIBUTE6         IN     VARCHAR2,
   X_ATTRIBUTE7         IN     VARCHAR2,
   X_ATTRIBUTE8         IN     VARCHAR2,
   X_ATTRIBUTE9         IN     VARCHAR2,
   X_ATTRIBUTE10        IN     VARCHAR2,
   X_ATTRIBUTE11        IN     VARCHAR2,
   X_ATTRIBUTE12        IN     VARCHAR2,
   X_ATTRIBUTE13        IN     VARCHAR2,
   X_ATTRIBUTE14        IN     VARCHAR2,
   X_ATTRIBUTE15        IN     VARCHAR2,
   X_LAST_UPDATE_DATE   IN     DATE,
   X_LAST_UPDATED_BY    IN     NUMBER,
   X_LAST_UPDATE_LOGIN  IN     NUMBER,
   X_OBJECT_VERSION_NUMBER  IN   NUMBER
   ) IS
BEGIN
   update CN_ROLE_QUOTA_RATES SET
     ROLE_QUOTA_CATE_ID = X_ROLE_QUOTA_CATE_ID,
     RATE_TIER_ID = X_RATE_TIER_ID,
     RATE_SCHEDULE_ID = X_RATE_SCHEDULE_ID,
     MIN_RATE = X_MIN_RATE,
     MAX_RATE = X_MAX_RATE,
     COMM_RATE = X_COMM_RATE,
     ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
     ATTRIBUTE1 = X_ATTRIBUTE1,
     ATTRIBUTE2 = X_ATTRIBUTE2,
     ATTRIBUTE3 = X_ATTRIBUTE3,
     ATTRIBUTE4 = X_ATTRIBUTE4,
     ATTRIBUTE5 = X_ATTRIBUTE5,
     ATTRIBUTE6 = X_ATTRIBUTE6,
     ATTRIBUTE7 = X_ATTRIBUTE7,
     ATTRIBUTE8 = X_ATTRIBUTE8,
     ATTRIBUTE9 = X_ATTRIBUTE9,
     ATTRIBUTE10 = X_ATTRIBUTE10,
     ATTRIBUTE11 = X_ATTRIBUTE11,
     ATTRIBUTE12 = X_ATTRIBUTE12,
     ATTRIBUTE13 = X_ATTRIBUTE13,
     ATTRIBUTE14 = X_ATTRIBUTE14,
     ATTRIBUTE15 = X_ATTRIBUTE15,
     ROLE_QUOTA_RATE_ID = X_ROLE_QUOTA_RATE_ID,
     LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
     LAST_UPDATED_BY = X_LAST_UPDATED_BY,
     LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
     OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER
     where ROLE_QUOTA_RATE_ID = x_role_quota_rate_id;

Line: 306

end UPDATE_ROW;

Line: 308

procedure DELETE_ROW (
  X_ROLE_QUOTA_RATE_ID in NUMBER
) is
begin
  delete from CN_ROLE_QUOTA_RATES
  where ROLE_QUOTA_RATE_ID = X_ROLE_QUOTA_RATE_ID;

Line: 319

end DELETE_ROW;