APPS.CN_SRP_ROLLOVER_QUOTA_PVT SQL Statements

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

Line: 13

PROCEDURE Update_Srp_Rollover_Quota
  (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_srp_rollover_quota          IN      srp_rollover_quota_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)  := 'Update_Srp_Rollover_Quota';

Line: 28

	SELECT *
	  FROM cn_srp_rollover_quotas
	  WHERE srp_rollover_quota_id = p_srp_rollover_quota.srp_rollover_quota_id;

Line: 68

   SAVEPOINT   Update_Srp_Rollover_Quota;

Line: 174

   SELECT


      Decode(p_srp_rollover_quota.rollover,
	    fnd_api.g_miss_num, l_old_srp_rollover_quota.rollover,
	    p_srp_rollover_quota.rollover),

      Decode(p_srp_rollover_quota.ATTRIBUTE_CATEGORY,
	    fnd_api.g_miss_char, NULL,
	    p_srp_rollover_quota.ATTRIBUTE_CATEGORY),
     Decode(p_srp_rollover_quota.ATTRIBUTE1,
	    fnd_api.g_miss_char, NULL,
	    p_srp_rollover_quota.ATTRIBUTE1),
     Decode(p_srp_rollover_quota.ATTRIBUTE2,
	    fnd_api.g_miss_char, NULL,
	    p_srp_rollover_quota.ATTRIBUTE2),
     Decode(p_srp_rollover_quota.ATTRIBUTE3,
	    fnd_api.g_miss_char, NULL,
	    p_srp_rollover_quota.ATTRIBUTE3),
     Decode(p_srp_rollover_quota.ATTRIBUTE4,
	    fnd_api.g_miss_char, NULL,
	    p_srp_rollover_quota.ATTRIBUTE4),
     Decode(p_srp_rollover_quota.ATTRIBUTE5,
	    fnd_api.g_miss_char, NULL,
	    p_srp_rollover_quota.ATTRIBUTE5),
     Decode(p_srp_rollover_quota.ATTRIBUTE6,
	    fnd_api.g_miss_char, NULL,
	    p_srp_rollover_quota.ATTRIBUTE6),
     Decode(p_srp_rollover_quota.ATTRIBUTE7,
	    fnd_api.g_miss_char, NULL,
	    p_srp_rollover_quota.ATTRIBUTE7),
     Decode(p_srp_rollover_quota.ATTRIBUTE8,
	    fnd_api.g_miss_char, NULL,
	    p_srp_rollover_quota.ATTRIBUTE8),
     Decode(p_srp_rollover_quota.ATTRIBUTE9,
	    fnd_api.g_miss_char, NULL,
	    p_srp_rollover_quota.ATTRIBUTE9),
     Decode(p_srp_rollover_quota.ATTRIBUTE10,
	    fnd_api.g_miss_char, NULL,
	    p_srp_rollover_quota.ATTRIBUTE10),
     Decode(p_srp_rollover_quota.ATTRIBUTE11,
	    fnd_api.g_miss_char, NULL,
	    p_srp_rollover_quota.ATTRIBUTE11),
     Decode(p_srp_rollover_quota.ATTRIBUTE12,
	    fnd_api.g_miss_char, NULL,
	    p_srp_rollover_quota.ATTRIBUTE12),
     Decode(p_srp_rollover_quota.ATTRIBUTE13,
	    fnd_api.g_miss_char, NULL,
	    p_srp_rollover_quota.ATTRIBUTE13),
     Decode(p_srp_rollover_quota.ATTRIBUTE14,
	    fnd_api.g_miss_char, NULL,
	    p_srp_rollover_quota.ATTRIBUTE14),
     Decode(p_srp_rollover_quota.ATTRIBUTE15,
	    fnd_api.g_miss_char, NULL,
	    p_srp_rollover_quota.ATTRIBUTE15)

   INTO
      l_rollover,
     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
    FROM dual;

Line: 253

     select customized_flag
     into l_customized_flag
     from cn_srp_quota_assigns
     where srp_quota_assign_id = p_srp_rollover_quota.srp_quota_assign_id;

Line: 263

   CN_SRP_ROLLOVER_QUOTAS_PKG.UPDATE_ROW (
   X_SRP_ROLLOVER_QUOTA_ID => p_srp_rollover_quota.srp_rollover_quota_id,
   X_SRP_QUOTA_ASSIGN_ID => p_srp_rollover_quota.srp_quota_assign_id,
   X_ROLLOVER_QUOTA_ID => p_srp_rollover_quota.rollover_quota_id,
   X_QUOTA_ID => p_srp_rollover_quota.quota_id,
   X_SOURCE_QUOTA_ID => p_srp_rollover_quota.source_quota_id,
   X_ROLLOVER => l_rollover,
   X_ATTRIBUTE_CATEGORY => l_attribute_category,
   X_ATTRIBUTE1 => l_attribute1,
   X_ATTRIBUTE2 => l_attribute2,
   X_ATTRIBUTE3 => l_attribute3,
   X_ATTRIBUTE4 => l_attribute4,
   X_ATTRIBUTE5 => l_attribute5,
   X_ATTRIBUTE6 => l_attribute6,
   X_ATTRIBUTE7 => l_attribute7,
   X_ATTRIBUTE8 => l_attribute8,
   X_ATTRIBUTE9 => l_attribute9,
   X_ATTRIBUTE10 => l_attribute10,
   X_ATTRIBUTE11 => l_attribute11,
   X_ATTRIBUTE12 => l_attribute12,
   X_ATTRIBUTE13 => l_attribute13,
   X_ATTRIBUTE14 => l_attribute14,
   X_ATTRIBUTE15 => l_attribute15,
   X_CREATED_BY => fnd_global.user_id,
   X_CREATION_DATE => sysdate,
   X_LAST_UPDATE_DATE => sysdate,
   X_LAST_UPDATED_BY => fnd_global.user_id,
   X_LAST_UPDATE_LOGIN => fnd_global.login_id
   );

Line: 309

     ROLLBACK TO Update_Srp_Rollover_Quota;

Line: 316

     ROLLBACK TO Update_Srp_Rollover_Quota;

Line: 323

     ROLLBACK TO Update_Srp_Rollover_Quota;

Line: 336

END Update_Srp_Rollover_Quota;