The following lines contain the word 'select', 'insert', 'update' or 'delete':
G_LAST_UPDATE_DATE DATE := Sysdate;
G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
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
;
select cn_role_quota_formulas_s.nextval
into l_attain_tier_id
from dual;
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
);
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;
G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
l_api_name CONSTANT VARCHAR2(30) := 'Update_Attain_Tier';
SELECT *
FROM cn_attain_tiers
WHERE attain_tier_id = p_attain_tier.attain_tier_id;
SAVEPOINT Update_Attain_Tier;
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;
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
);
ROLLBACK TO Update_Attain_Tier;
ROLLBACK TO Update_Attain_Tier;
ROLLBACK TO Update_Attain_Tier;
END Update_Attain_Tier;
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';
SAVEPOINT Delete_Attain_Tier;
CN_ATTAIN_TIERS_PKG.DELETE_ROW(
X_ATTAIN_TIER_ID => p_attain_tier.ATTAIN_TIER_ID);
ROLLBACK TO Delete_Attain_Tier;
ROLLBACK TO Delete_Attain_Tier;
ROLLBACK TO Delete_Attain_Tier;
END Delete_Attain_Tier;
SELECT *
FROM cn_attain_tiers
WHERE attain_schedule_id = p_attain_schedule_id
ORDER BY percent
;