APPS.CN_ATTAIN_SCHEDULE_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: 83

   SELECT count(1)
     INTO l_temp_count
     FROM cn_attain_schedules
    WHERE name = p_attain_schedule.name
        ;

Line: 97

   select cn_role_quota_formulas_s.nextval
     into l_attain_schedule_id
     from dual;

Line: 101

   CN_ATTAIN_SCHEDULES_PKG.INSERT_ROW
   (
    X_ROWID => G_ROWID,
    X_ATTAIN_SCHEDULE_ID => l_attain_schedule_id,
    X_NAME => p_attain_schedule.NAME,
    X_ATTRIBUTE_CATEGORY => p_attain_schedule.ATTRIBUTE_CATEGORY,
    X_ATTRIBUTE1 => p_attain_schedule.ATTRIBUTE1,
    X_ATTRIBUTE2 => p_attain_schedule.ATTRIBUTE2,
    X_ATTRIBUTE3 => p_attain_schedule.ATTRIBUTE3,
    X_ATTRIBUTE4 => p_attain_schedule.ATTRIBUTE4,
    X_ATTRIBUTE5 => p_attain_schedule.ATTRIBUTE5,
    X_ATTRIBUTE6 => p_attain_schedule.ATTRIBUTE6,
    X_ATTRIBUTE7 => p_attain_schedule.ATTRIBUTE7,
    X_ATTRIBUTE8 => p_attain_schedule.ATTRIBUTE8,
    X_ATTRIBUTE9 => p_attain_schedule.ATTRIBUTE9,
    X_ATTRIBUTE10 => p_attain_schedule.ATTRIBUTE10,
    X_ATTRIBUTE11 => p_attain_schedule.ATTRIBUTE11,
    X_ATTRIBUTE12 => p_attain_schedule.ATTRIBUTE12,
    X_ATTRIBUTE13 => p_attain_schedule.ATTRIBUTE13,
    X_ATTRIBUTE14 => p_attain_schedule.ATTRIBUTE14,
    X_ATTRIBUTE15 => p_attain_schedule.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: 193

PROCEDURE Update_Attain_Schedule
  (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_schedule                 IN      attain_schedule_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: 205

     G_LAST_UPDATED_BY           NUMBER := fnd_global.user_id;

Line: 206

     G_LAST_UPDATE_LOGIN         NUMBER := fnd_global.login_id;

Line: 209

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

Line: 215

	SELECT *
	  FROM cn_attain_schedules
	  WHERE attain_schedule_id = p_attain_schedule.attain_schedule_id;

Line: 222

   SAVEPOINT   Update_Attain_Schedule;

Line: 254

   SELECT count(1)
     INTO l_temp_count
     FROM cn_attain_schedules
    WHERE name = p_attain_schedule.name
      AND attain_schedule_id <> p_attain_schedule.attain_schedule_id;

Line: 280

   CN_ATTAIN_SCHEDULES_PKG.UPDATE_ROW
   (
    X_ATTAIN_SCHEDULE_ID => p_attain_schedule.ATTAIN_SCHEDULE_ID,
    X_NAME => p_attain_schedule.NAME,
    X_ATTRIBUTE_CATEGORY => p_attain_schedule.ATTRIBUTE_CATEGORY,
    X_ATTRIBUTE1 => p_attain_schedule.ATTRIBUTE1,
    X_ATTRIBUTE2 => p_attain_schedule.ATTRIBUTE2,
    X_ATTRIBUTE3 => p_attain_schedule.ATTRIBUTE3,
    X_ATTRIBUTE4 => p_attain_schedule.ATTRIBUTE4,
    X_ATTRIBUTE5 => p_attain_schedule.ATTRIBUTE5,
    X_ATTRIBUTE6 => p_attain_schedule.ATTRIBUTE6,
    X_ATTRIBUTE7 => p_attain_schedule.ATTRIBUTE7,
    X_ATTRIBUTE8 => p_attain_schedule.ATTRIBUTE8,
    X_ATTRIBUTE9 => p_attain_schedule.ATTRIBUTE9,
    X_ATTRIBUTE10 => p_attain_schedule.ATTRIBUTE10,
    X_ATTRIBUTE11 => p_attain_schedule.ATTRIBUTE11,
    X_ATTRIBUTE12 => p_attain_schedule.ATTRIBUTE12,
    X_ATTRIBUTE13 => p_attain_schedule.ATTRIBUTE13,
    X_ATTRIBUTE14 => p_attain_schedule.ATTRIBUTE14,
    X_ATTRIBUTE15 => p_attain_schedule.ATTRIBUTE15,
    X_OBJECT_VERSION_NUMBER => p_attain_schedule.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: 318

     ROLLBACK TO Update_Attain_Schedule;

Line: 325

     ROLLBACK TO Update_Attain_Schedule;

Line: 332

     ROLLBACK TO Update_Attain_Schedule;

Line: 345

END Update_Attain_Schedule;

Line: 369

PROCEDURE Delete_Attain_Schedule
  (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_schedule             IN      attain_schedule_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_Schedule';

Line: 383

	SELECT attain_tier_id
	  FROM cn_attain_tiers
	  WHERE attain_schedule_id = p_attain_schedule.attain_schedule_id
              ;

Line: 393

   SAVEPOINT   Delete_Attain_Schedule;

Line: 413

   SELECT count(1)
     INTO l_temp_count
     FROM cn_role_details
    WHERE attain_schedule_id = p_attain_schedule.attain_schedule_id
      AND rownum = 1;

Line: 421

	FND_MESSAGE.SET_NAME ('CN' , 'CN_CANT_DELETE');

Line: 428

   CN_ATTAIN_SCHEDULES_PKG.DELETE_ROW(
       X_ATTAIN_SCHEDULE_ID => p_attain_schedule.ATTAIN_SCHEDULE_ID);

Line: 435

       CN_ATTAIN_TIER_PVT.Delete_Attain_Tier
  	       (p_api_version		=> p_api_version,
   		p_init_msg_list         => p_init_msg_list,
   		p_commit                => p_commit,
   		p_validation_level      => p_validation_level,
   		p_attain_tier           => l_temp_attain_tier,
   		x_return_status         => x_return_status,
   		x_msg_count             => x_msg_count,
   		x_msg_data              => x_msg_data
               );

Line: 464

     ROLLBACK TO Delete_Attain_Schedule;

Line: 471

     ROLLBACK TO Delete_Attain_Schedule;

Line: 478

     ROLLBACK TO Delete_Attain_Schedule;

Line: 491

END Delete_Attain_Schedule;

Line: 531

        SELECT *
          FROM cn_attain_schedules
      ORDER BY name
             ;