The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE INSERT_ROW (
X_ROWID IN OUT NOCOPY VARCHAR2,
P_TABLESPACE_TYPE IN VARCHAR2,
P_TABLESPACE IN VARCHAR2,
P_CUSTOM_FLAG IN VARCHAR2 DEFAULT NULL,
P_CREATION_DATE IN DATE DEFAULT NULL,
P_CREATED_BY IN NUMBER DEFAULT NULL,
P_LAST_UPDATE_DATE IN DATE DEFAULT NULL,
P_LAST_UPDATED_BY IN NUMBER DEFAULT NULL,
P_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL)
IS
cursor C is select ROWID from FND_TABLESPACES
where TABLESPACE_TYPE = P_TABLESPACE_TYPE ;
insert into FND_TABLESPACES (
TABLESPACE_TYPE,
TABLESPACE,
CUSTOM_FLAG ,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN
) values (
P_TABLESPACE_TYPE,
P_TABLESPACE,
P_CUSTOM_FLAG ,
P_CREATION_DATE,
P_CREATED_BY,
P_LAST_UPDATE_DATE,
P_LAST_UPDATED_BY,
P_LAST_UPDATE_LOGIN
);
END INSERT_ROW;
PROCEDURE UPDATE_ROW (
P_TABLESPACE_TYPE in VARCHAR2,
P_TABLESPACE in VARCHAR2,
P_CUSTOM_FLAG in VARCHAR2 DEFAULT NULL,
P_LAST_UPDATE_DATE in DATE DEFAULT NULL,
P_LAST_UPDATED_BY in NUMBER DEFAULT NULL,
P_LAST_UPDATE_LOGIN in NUMBER DEFAULT NULL
)
IS
BEGIN
update FND_TABLESPACES set
TABLESPACE = decode(P_TABLESPACE, null, TABLESPACE, P_TABLESPACE),
CUSTOM_FLAG = decode(P_CUSTOM_FLAG, null, CUSTOM_FLAG, P_CUSTOM_FLAG),
LAST_UPDATE_DATE = decode(P_LAST_UPDATE_DATE, null, sysdate, P_LAST_UPDATE_DATE),
LAST_UPDATED_BY = decode(P_LAST_UPDATED_BY, null, -1, P_LAST_UPDATED_BY),
LAST_UPDATE_LOGIN = decode(P_LAST_UPDATE_LOGIN, null, -1, P_LAST_UPDATE_LOGIN)
where TABLESPACE_TYPE = P_TABLESPACE_TYPE;
END UPDATE_ROW;
PROCEDURE DELETE_ROW (
P_TABLESPACE_TYPE in VARCHAR2)
IS
BEGIN
delete from FND_TABLESPACES
where TABLESPACE_TYPE = P_TABLESPACE_TYPE ;
END DELETE_ROW;