The following lines contain the word 'select', 'insert', 'update' or 'delete':
insert into CS_KB_SET_USED_HISTS (
SET_ID,
HISTORY_ID,
USED_TYPE,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15
) values (
P_SET_ID,
P_HISTORY_ID,
P_USED_TYPE,
l_date,
l_created_by,
l_date,
l_created_by,
l_login,
P_ATTRIBUTE_CATEGORY,
P_ATTRIBUTE1,
P_ATTRIBUTE2,
P_ATTRIBUTE3,
P_ATTRIBUTE4,
P_ATTRIBUTE5,
P_ATTRIBUTE6,
P_ATTRIBUTE7,
P_ATTRIBUTE8,
P_ATTRIBUTE9,
P_ATTRIBUTE10,
P_ATTRIBUTE11,
P_ATTRIBUTE12,
P_ATTRIBUTE13,
P_ATTRIBUTE14,
P_ATTRIBUTE15
);
function Update_Set_Used_History(
P_SET_ID in NUMBER,
P_HISTORY_ID in NUMBER,
P_USED_TYPE in VARCHAR2 DEFAULT NULL,
P_ATTRIBUTE_CATEGORY in VARCHAR2 DEFAULT NULL,
P_ATTRIBUTE1 in VARCHAR2 DEFAULT NULL,
P_ATTRIBUTE2 in VARCHAR2 DEFAULT NULL,
P_ATTRIBUTE3 in VARCHAR2 DEFAULT NULL,
P_ATTRIBUTE4 in VARCHAR2 DEFAULT NULL,
P_ATTRIBUTE5 in VARCHAR2 DEFAULT NULL,
P_ATTRIBUTE6 in VARCHAR2 DEFAULT NULL,
P_ATTRIBUTE7 in VARCHAR2 DEFAULT NULL,
P_ATTRIBUTE8 in VARCHAR2 DEFAULT NULL,
P_ATTRIBUTE9 in VARCHAR2 DEFAULT NULL,
P_ATTRIBUTE10 in VARCHAR2 DEFAULT NULL,
P_ATTRIBUTE11 in VARCHAR2 DEFAULT NULL,
P_ATTRIBUTE12 in VARCHAR2 DEFAULT NULL,
P_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
P_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
P_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL
) return number is
l_ret number;
l_updated_by number;
l_updated_by := fnd_global.user_id;
update CS_KB_SET_USED_HISTS set
USED_TYPE = P_USED_TYPE,
LAST_UPDATE_DATE = l_date,
LAST_UPDATED_BY = l_updated_by,
LAST_UPDATE_LOGIN = l_login,
ATTRIBUTE_CATEGORY = P_ATTRIBUTE_CATEGORY,
ATTRIBUTE1 = P_ATTRIBUTE1,
ATTRIBUTE2 = P_ATTRIBUTE2,
ATTRIBUTE3 = P_ATTRIBUTE3,
ATTRIBUTE4 = P_ATTRIBUTE4,
ATTRIBUTE5 = P_ATTRIBUTE5,
ATTRIBUTE6 = P_ATTRIBUTE6,
ATTRIBUTE7 = P_ATTRIBUTE7,
ATTRIBUTE8 = P_ATTRIBUTE8,
ATTRIBUTE9 = P_ATTRIBUTE9,
ATTRIBUTE10 = P_ATTRIBUTE10,
ATTRIBUTE11 = P_ATTRIBUTE11,
ATTRIBUTE12 = P_ATTRIBUTE12,
ATTRIBUTE13 = P_ATTRIBUTE13,
ATTRIBUTE14 = P_ATTRIBUTE14,
ATTRIBUTE15 = P_ATTRIBUTE15
where SET_ID = P_SET_ID AND HISTORY_ID = P_HISTORY_ID;
end Update_Set_Used_History;
function Delete_Set_Used_History (
P_SET_ID in NUMBER,
P_HISTORY_ID in NUMBER
) return number is
begin
if (P_SET_ID is null OR P_HISTORY_ID is null) then return ERROR_STATUS; end if;
delete from CS_KB_SET_USED_HISTS
where SET_ID = P_SET_ID AND HISTORY_ID = P_HISTORY_ID;
end Delete_Set_Used_History;