APPS.CN_ATTAIN_TIER_PVT SQL Statements

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

Line: 38

     G_LAST_UPDATE_DATE          DATE := Sysdate;

Line: 39

     G_LAST_UPDATED_BY           NUMBER := fnd_global.user_id;

Line: 42

     G_LAST_UPDATE_LOGIN         NUMBER := fnd_global.login_id;

Line: 86

   SELECT count(1)
     INTO l_temp_count
     FROM cn_attain_tiers
    WHERE attain_schedule_id = p_attain_tier.attain_schedule_id
      AND percent = p_attain_tier.percent
        ;

Line: 109

   select cn_role_quota_formulas_s.nextval
     into l_attain_tier_id
     from dual;

Line: 113

   CN_ATTAIN_TIERS_PKG.INSERT_ROW
   (
    X_ROWID => G_ROWID,
    X_ATTAIN_TIER_ID => l_attain_tier_id,
    X_ATTAIN_SCHEDULE_ID => p_attain_tier.ATTAIN_SCHEDULE_ID,
    X_PERCENT => p_attain_tier.PERCENT,
    X_ATTRIBUTE_CATEGORY => p_attain_tier.ATTRIBUTE_CATEGORY,
    X_ATTRIBUTE1 => p_attain_tier.ATTRIBUTE1,
    X_ATTRIBUTE2 => p_attain_tier.ATTRIBUTE2,
    X_ATTRIBUTE3 => p_attain_tier.ATTRIBUTE3,
    X_ATTRIBUTE4 => p_attain_tier.ATTRIBUTE4,
    X_ATTRIBUTE5 => p_attain_tier.ATTRIBUTE5,
    X_ATTRIBUTE6 => p_attain_tier.ATTRIBUTE6,
    X_ATTRIBUTE7 => p_attain_tier.ATTRIBUTE7,
    X_ATTRIBUTE8 => p_attain_tier.ATTRIBUTE8,
    X_ATTRIBUTE9 => p_attain_tier.ATTRIBUTE9,
    X_ATTRIBUTE10 => p_attain_tier.ATTRIBUTE10,
    X_ATTRIBUTE11 => p_attain_tier.ATTRIBUTE11,
    X_ATTRIBUTE12 => p_attain_tier.ATTRIBUTE12,
    X_ATTRIBUTE13 => p_attain_tier.ATTRIBUTE13,
    X_ATTRIBUTE14 => p_attain_tier.ATTRIBUTE14,
    X_ATTRIBUTE15 => p_attain_tier.ATTRIBUTE15,
    X_OBJECT_VERSION_NUMBER => 1,
    X_CREATION_DATE => G_CREATION_DATE,
    X_CREATED_BY => G_CREATED_BY,
    X_LAST_UPDATE_DATE => G_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY => G_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN => G_LAST_UPDATE_LOGIN
   );

Line: 206

PROCEDURE Update_Attain_Tier
  (p_api_version                 IN      NUMBER,
   p_init_msg_list               IN      VARCHAR2 := FND_API.G_FALSE,
   p_commit                      IN      VARCHAR2 := FND_API.G_FALSE,
   p_validation_level            IN      NUMBER  := FND_API.G_VALID_LEVEL_FULL,
   p_attain_tier                 IN      attain_tier_rec_type,
   x_return_status               OUT NOCOPY     VARCHAR2,
   x_msg_count                   OUT NOCOPY     NUMBER,
   x_msg_data                    OUT NOCOPY     VARCHAR2
 ) IS

     G_LAST_UPDATE_DATE          DATE := Sysdate;

Line: 218

     G_LAST_UPDATED_BY           NUMBER := fnd_global.user_id;

Line: 219

     G_LAST_UPDATE_LOGIN         NUMBER := fnd_global.login_id;

Line: 222

     l_api_name           CONSTANT VARCHAR2(30)  := 'Update_Attain_Tier';

Line: 228

	SELECT *
	  FROM cn_attain_tiers
	  WHERE attain_tier_id = p_attain_tier.attain_tier_id;

Line: 235

   SAVEPOINT   Update_Attain_Tier;

Line: 268

   SELECT count(1)
     INTO l_temp_count
     FROM cn_attain_tiers
    WHERE attain_schedule_id = p_attain_tier.attain_schedule_id
      AND percent = p_attain_tier.percent
      AND attain_tier_id <> p_attain_tier.attain_tier_id;

Line: 303

   CN_ATTAIN_TIERS_PKG.UPDATE_ROW
   (
    X_ATTAIN_TIER_ID => p_attain_tier.ATTAIN_TIER_ID,
    X_ATTAIN_SCHEDULE_ID => p_attain_tier.ATTAIN_SCHEDULE_ID,
    X_PERCENT => p_attain_tier.PERCENT,
    X_ATTRIBUTE_CATEGORY => p_attain_tier.ATTRIBUTE_CATEGORY,
    X_ATTRIBUTE1 => p_attain_tier.ATTRIBUTE1,
    X_ATTRIBUTE2 => p_attain_tier.ATTRIBUTE2,
    X_ATTRIBUTE3 => p_attain_tier.ATTRIBUTE3,
    X_ATTRIBUTE4 => p_attain_tier.ATTRIBUTE4,
    X_ATTRIBUTE5 => p_attain_tier.ATTRIBUTE5,
    X_ATTRIBUTE6 => p_attain_tier.ATTRIBUTE6,
    X_ATTRIBUTE7 => p_attain_tier.ATTRIBUTE7,
    X_ATTRIBUTE8 => p_attain_tier.ATTRIBUTE8,
    X_ATTRIBUTE9 => p_attain_tier.ATTRIBUTE9,
    X_ATTRIBUTE10 => p_attain_tier.ATTRIBUTE10,
    X_ATTRIBUTE11 => p_attain_tier.ATTRIBUTE11,
    X_ATTRIBUTE12 => p_attain_tier.ATTRIBUTE12,
    X_ATTRIBUTE13 => p_attain_tier.ATTRIBUTE13,
    X_ATTRIBUTE14 => p_attain_tier.ATTRIBUTE14,
    X_ATTRIBUTE15 => p_attain_tier.ATTRIBUTE15,
    X_OBJECT_VERSION_NUMBER => p_attain_tier.OBJECT_VERSION_NUMBER+1,
    X_LAST_UPDATE_DATE => G_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY => G_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN => G_LAST_UPDATE_LOGIN
   );

Line: 342

     ROLLBACK TO Update_Attain_Tier;

Line: 349

     ROLLBACK TO Update_Attain_Tier;

Line: 356

     ROLLBACK TO Update_Attain_Tier;

Line: 369

END Update_Attain_Tier;

Line: 393

PROCEDURE Delete_Attain_Tier
  (p_api_version                 IN      NUMBER,
   p_init_msg_list               IN      VARCHAR2 := FND_API.G_FALSE,
   p_commit                      IN      VARCHAR2 := FND_API.G_FALSE,
   p_validation_level            IN      NUMBER  := FND_API.G_VALID_LEVEL_FULL,
   p_attain_tier                 IN      attain_tier_rec_type,
   x_return_status               OUT NOCOPY     VARCHAR2,
   x_msg_count                   OUT NOCOPY     NUMBER,
   x_msg_data                    OUT NOCOPY     VARCHAR2
 ) IS
     l_api_name           CONSTANT VARCHAR2(30) := 'Delete_Attain_Tier';

Line: 407

   SAVEPOINT   Delete_Attain_Tier;

Line: 425

    CN_ATTAIN_TIERS_PKG.DELETE_ROW(
       X_ATTAIN_TIER_ID => p_attain_tier.ATTAIN_TIER_ID);

Line: 440

     ROLLBACK TO Delete_Attain_Tier;

Line: 447

     ROLLBACK TO Delete_Attain_Tier;

Line: 454

     ROLLBACK TO Delete_Attain_Tier;

Line: 467

END Delete_Attain_Tier;

Line: 509

        SELECT *
          FROM cn_attain_tiers
         WHERE attain_schedule_id = p_attain_schedule_id
      ORDER BY percent
             ;