The following lines contain the word 'select', 'insert', 'update' or 'delete':
X_LAST_UPDATED_BY in NUMBER,
X_LAST_UPDATE_LOGIN in NUMBER) is
begin
begin
fnd_oam_doc_category_pkg.UPDATE_ROW(
X_CATEGORY_KEY => X_CATEGORY_KEY,
X_CATEGORY_TYPE => X_CATEGORY_TYPE,
X_CATEGORY_NAME => X_CATEGORY_NAME,
X_CREATED_BY => X_CREATED_BY,
X_LAST_UPDATED_BY => X_LAST_UPDATED_BY,
X_LAST_UPDATE_LOGIN => X_LAST_UPDATE_LOGIN);
fnd_oam_doc_category_pkg.INSERT_ROW(
X_CATEGORY_KEY => X_CATEGORY_KEY,
X_CATEGORY_TYPE => X_CATEGORY_TYPE,
X_CATEGORY_NAME => X_CATEGORY_NAME,
X_CREATED_BY => X_CREATED_BY,
X_LAST_UPDATED_BY => X_LAST_UPDATED_BY,
X_LAST_UPDATE_LOGIN => X_LAST_UPDATE_LOGIN);
procedure UPDATE_ROW(
X_CATEGORY_KEY in VARCHAR2,
X_CATEGORY_TYPE in VARCHAR2,
X_CATEGORY_NAME in VARCHAR2,
X_CREATED_BY in NUMBER,
X_LAST_UPDATED_BY in NUMBER,
X_LAST_UPDATE_LOGIN in NUMBER) is
db_key varchar2(40);
select category_key into db_key from FND_OAM_DOC_CATEGORY
where category_key = X_CATEGORY_KEY
and category_type = X_CATEGORY_TYPE ;
update FND_OAM_DOC_CATEGORY SET
category_key = X_CATEGORY_KEY,
category_type = X_CATEGORY_TYPE ,
category_name = X_CATEGORY_NAME,
created_by = X_CREATED_BY,
creation_date = sysdate,
last_update_date = sysdate,
last_updated_by = X_LAST_UPDATED_BY,
last_update_login = X_LAST_UPDATE_LOGIN
where category_key = X_CATEGORY_KEY and category_type = X_CATEGORY_TYPE ;
end UPDATE_ROW;
procedure INSERT_ROW(
X_CATEGORY_KEY in VARCHAR2,
X_CATEGORY_TYPE in VARCHAR2,
X_CATEGORY_NAME in VARCHAR2,
X_CREATED_BY in NUMBER,
X_LAST_UPDATED_BY in NUMBER,
X_LAST_UPDATE_LOGIN in NUMBER) is
begin
insert into FND_OAM_DOC_CATEGORY(
category_key,
category_type,
category_name,
created_by,
creation_date,
last_update_date,
last_updated_by,
last_update_login
) values (
X_CATEGORY_KEY,
X_CATEGORY_TYPE,
X_CATEGORY_NAME,
X_CREATED_BY,
sysdate,
sysdate,
X_LAST_UPDATED_BY,
X_LAST_UPDATE_LOGIN);
end INSERT_ROW;