The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE INSERT_ROW (
X_SEARCH_TYPE IN VARCHAR2,
X_LEVEL_ID IN NUMBER,
X_LEVEL_VALUE IN NUMBER,
X_SEARCH_TITLE IN VARCHAR2,
X_VO_NAME IN VARCHAR2,
X_SEARCH_TYPE_ID IN NUMBER,
X_OWNER IN VARCHAR2
)
IS
BEGIN
INSERT INTO CSM_AD_SEARCH_TITLE_VIEW
(ID,
SEARCH_TYPE,
LEVEL_ID,
LEVEL_VALUE,
SEARCH_TITLE,
VO_NAME,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
SEARCH_TYPE_ID)
VALUES
( CSM_AD_SEARCH_TITLE_VIEW_S.NEXTVAL,
X_SEARCH_TYPE,
X_LEVEL_ID,
X_LEVEL_VALUE,
X_SEARCH_TITLE,
X_VO_NAME,
SYSDATE,
DECODE(X_OWNER,'SEED',1,0),
SYSDATE,
DECODE(X_OWNER,'SEED',1,0),
X_SEARCH_TYPE_ID
);
END INSERT_ROW;
PROCEDURE UPDATE_ROW (
X_SEARCH_TYPE IN VARCHAR2,
X_LEVEL_ID IN NUMBER,
X_LEVEL_VALUE IN NUMBER,
X_SEARCH_TITLE IN VARCHAR2,
X_VO_NAME IN VARCHAR2,
X_SEARCH_TYPE_ID IN NUMBER,
X_OWNER IN VARCHAR2
)
IS
BEGIN
UPDATE CSM_AD_SEARCH_TITLE_VIEW
SET
SEARCH_TITLE = X_SEARCH_TITLE,
VO_NAME = X_VO_NAME,
SEARCH_TYPE_ID = X_SEARCH_TYPE_ID,
LAST_UPDATE_DATE = SYSDATE,
LAST_UPDATED_BY = DECODE(X_OWNER,'SEED',1,0)
WHERE SEARCH_TYPE = X_SEARCH_TYPE;
END UPDATE_ROW;
SELECT 1
FROM CSM_AD_SEARCH_TITLE_VIEW
WHERE SEARCH_TYPE=X_SEARCH_TYPE;
INSERT_ROW (
X_SEARCH_TYPE,
X_LEVEL_ID,
X_LEVEL_VALUE,
X_SEARCH_TITLE,
X_VO_NAME,
X_SEARCH_TYPE_ID,
X_OWNER
);
UPDATE_ROW (
X_SEARCH_TYPE,
X_LEVEL_ID,
X_LEVEL_VALUE,
X_SEARCH_TITLE,
X_VO_NAME,
X_SEARCH_TYPE_ID,
X_OWNER
);