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_schedules
WHERE name = p_attain_schedule.name
;
select cn_role_quota_formulas_s.nextval
into l_attain_schedule_id
from dual;
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
);
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;
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_Schedule';
SELECT *
FROM cn_attain_schedules
WHERE attain_schedule_id = p_attain_schedule.attain_schedule_id;
SAVEPOINT Update_Attain_Schedule;
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;
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
);
ROLLBACK TO Update_Attain_Schedule;
ROLLBACK TO Update_Attain_Schedule;
ROLLBACK TO Update_Attain_Schedule;
END Update_Attain_Schedule;
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';
SELECT attain_tier_id
FROM cn_attain_tiers
WHERE attain_schedule_id = p_attain_schedule.attain_schedule_id
;
SAVEPOINT Delete_Attain_Schedule;
SELECT count(1)
INTO l_temp_count
FROM cn_role_details
WHERE attain_schedule_id = p_attain_schedule.attain_schedule_id
AND rownum = 1;
FND_MESSAGE.SET_NAME ('CN' , 'CN_CANT_DELETE');
CN_ATTAIN_SCHEDULES_PKG.DELETE_ROW(
X_ATTAIN_SCHEDULE_ID => p_attain_schedule.ATTAIN_SCHEDULE_ID);
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
);
ROLLBACK TO Delete_Attain_Schedule;
ROLLBACK TO Delete_Attain_Schedule;
ROLLBACK TO Delete_Attain_Schedule;
END Delete_Attain_Schedule;
SELECT *
FROM cn_attain_schedules
ORDER BY name
;