APPS.CN_SRP_QUOTA_RATES_PKG SQL Statements

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

Line: 12

PROCEDURE insert_row
  (SRP_QUOTA_CATE_ID           IN   NUMBER,
   ROLE_QUOTA_RATE_ID          IN   NUMBER,
   SRP_ID                      IN   NUMBER,
   QUOTA_CATEGORY_ID           IN   NUMBER,
   RATE_TIER_ID                IN   NUMBER,
   COMM_RATE                   IN   NUMBER,
   ATTRIBUTE_CATEGORY          IN   VARCHAR2 := NULL,
   ATTRIBUTE1                  IN   VARCHAR2 := NULL,
   ATTRIBUTE2                  IN   VARCHAR2 := NULL,
   ATTRIBUTE3                  IN   VARCHAR2 := NULL,
   ATTRIBUTE4                  IN   VARCHAR2 := NULL,
   ATTRIBUTE5                  IN   VARCHAR2 := NULL,
   ATTRIBUTE6                  IN   VARCHAR2 := NULL,
   ATTRIBUTE7                  IN   VARCHAR2 := NULL,
   ATTRIBUTE8                  IN   VARCHAR2 := NULL,
   ATTRIBUTE9                  IN   VARCHAR2 := NULL,
   ATTRIBUTE10                 IN   VARCHAR2 := NULL,
   ATTRIBUTE11                 IN   VARCHAR2 := NULL,
   ATTRIBUTE12                 IN   VARCHAR2 := NULL,
   ATTRIBUTE13                 IN   VARCHAR2 := NULL,
   ATTRIBUTE14                 IN   VARCHAR2 := NULL,
   ATTRIBUTE15                 IN   VARCHAR2 := NULL) IS

   l_srp_quota_rate_id        number;

Line: 40

   SELECT cn_srp_quota_rates_s.nextval
     INTO l_srp_quota_rate_id
     FROM dual;

Line: 45

   INSERT INTO cn_srp_quota_rates
     (srp_quota_rate_id, srp_quota_cate_id, role_quota_rate_id, srp_id,
      quota_category_id, rate_tier_id, 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
     (l_srp_quota_rate_id, srp_quota_cate_id, role_quota_rate_id, srp_id,
      quota_category_id, rate_tier_id, comm_rate, attribute_category,
      attribute1,  attribute2,  attribute3,  attribute4,  attribute5,
      attribute6,  attribute7,  attribute8,  attribute9,  attribute10,
      attribute11, attribute12, attribute13, attribute14, attribute15,
      sysdate, fnd_global.user_id, fnd_global.login_id,
      sysdate, fnd_global.user_id, 1);

Line: 60

END Insert_Row;

Line: 70

PROCEDURE update_row
  (SRP_QUOTA_RATE_ID           IN   NUMBER,
   SRP_QUOTA_CATE_ID           IN   NUMBER   := FND_API.G_MISS_NUM,
   ROLE_QUOTA_RATE_ID          IN   NUMBER   := FND_API.G_MISS_NUM,
   SRP_ID                      IN   NUMBER   := FND_API.G_MISS_NUM,
   QUOTA_CATEGORY_ID           IN   NUMBER   := FND_API.G_MISS_NUM,
   RATE_TIER_ID                IN   NUMBER   := FND_API.G_MISS_NUM,
   COMM_RATE                   IN   NUMBER   := FND_API.G_MISS_NUM,
   ATTRIBUTE_CATEGORY          IN   VARCHAR2 := FND_API.G_MISS_CHAR,
   ATTRIBUTE1                  IN   VARCHAR2 := FND_API.G_MISS_CHAR,
   ATTRIBUTE2                  IN   VARCHAR2 := FND_API.G_MISS_CHAR,
   ATTRIBUTE3                  IN   VARCHAR2 := FND_API.G_MISS_CHAR,
   ATTRIBUTE4                  IN   VARCHAR2 := FND_API.G_MISS_CHAR,
   ATTRIBUTE5                  IN   VARCHAR2 := FND_API.G_MISS_CHAR,
   ATTRIBUTE6                  IN   VARCHAR2 := FND_API.G_MISS_CHAR,
   ATTRIBUTE7                  IN   VARCHAR2 := FND_API.G_MISS_CHAR,
   ATTRIBUTE8                  IN   VARCHAR2 := FND_API.G_MISS_CHAR,
   ATTRIBUTE9                  IN   VARCHAR2 := FND_API.G_MISS_CHAR,
   ATTRIBUTE10                 IN   VARCHAR2 := FND_API.G_MISS_CHAR,
   ATTRIBUTE11                 IN   VARCHAR2 := FND_API.G_MISS_CHAR,
   ATTRIBUTE12                 IN   VARCHAR2 := FND_API.G_MISS_CHAR,
   ATTRIBUTE13                 IN   VARCHAR2 := FND_API.G_MISS_CHAR,
   ATTRIBUTE14                 IN   VARCHAR2 := FND_API.G_MISS_CHAR,
   ATTRIBUTE15                 IN   VARCHAR2 := FND_API.G_MISS_CHAR) IS

   l_srp_quota_rate_id         number := srp_quota_rate_id;

Line: 120

   CURSOR l_update_csr IS
     SELECT srp_quota_cate_id, role_quota_rate_id, quota_category_id, srp_id,
       rate_tier_id, comm_rate,  attribute_category, attribute1, attribute2,
       attribute3,  attribute4,  attribute5,  attribute6,  attribute7,
       attribute8,  attribute9,  attribute10, attribute11, attribute12,
       attribute13, attribute14, attribute15, object_version_number
       FROM cn_srp_quota_rates r
       WHERE r.srp_quota_rate_id = l_srp_quota_rate_id;

Line: 133

   OPEN l_update_csr;

Line: 134

   FETCH l_update_csr INTO l_srp_quota_cate_id, l_quota_category_id,
     l_role_quota_rate_id, l_srp_id, l_rate_tier_id, l_comm_rate,
     l_attribute_category, l_attribute1, l_attribute2, l_attribute3,
     l_attribute4,  l_attribute5 , l_attribute6,  l_attribute7,  l_attribute8,
     l_attribute9,  l_attribute10, l_attribute11, l_attribute12, l_attribute13,
     l_attribute14, l_attribute15, l_object_version_number;

Line: 140

   CLOSE l_update_csr;

Line: 166

   UPDATE cn_srp_quota_rates r SET
     srp_quota_cate_id = l_srp_quota_cate_id,
     role_quota_rate_id = l_role_quota_rate_id,
     quota_category_id = l_quota_category_id, srp_id = l_srp_id,
     rate_tier_id = l_rate_tier_id, comm_rate = l_comm_rate,
     attribute_category = l_attribute_category,
     attribute1 = l_attribute1, attribute2 = l_attribute2,
     attribute3 = l_attribute3, attribute4 = l_attribute4,
     attribute5 = l_attribute5, attribute6 = l_attribute6,
     attribute7 = l_attribute7, attribute8 = l_attribute8,
     attribute9 = l_attribute9, attribute10 = l_attribute10,
     attribute11 = l_attribute11, attribute12 = l_attribute12,
     attribute13 = l_attribute13, attribute14 = l_attribute14,
     attribute15 = l_attribute15,
     object_version_number = l_object_version_number + 1,
     last_update_date = sysdate,
     last_updated_by = fnd_global.user_id,
     last_update_login = fnd_global.login_id
     WHERE r.srp_quota_rate_id = l_srp_quota_rate_id;

Line: 185

END Update_Row;

Line: 194

PROCEDURE delete_row
  (SRP_QUOTA_RATE_ID           IN   NUMBER) IS
   l_srp_quota_rate_id         number := srp_quota_rate_id;

Line: 198

   DELETE FROM cn_srp_quota_rates r
     WHERE r.srp_quota_rate_id = l_srp_quota_rate_id;

Line: 200

END Delete_Row;