The following lines contain the word 'select', 'insert', 'update' or 'delete':
BNE_QUERIES_PKG.INSERT_ROW (
X_ROWID => X_ROWID,
X_APPLICATION_ID => P_APPLICATION_ID,
X_QUERY_CODE => P_QUERY_CODE,
X_OBJECT_VERSION_NUMBER => 1,
X_QUERY_CLASS => 'oracle.apps.bne.query.BneSimpleSQLQuery',
X_USER_NAME => P_USER_NAME,
X_CREATION_DATE => SYSDATE,
X_CREATED_BY => P_USER_ID,
X_LAST_UPDATE_DATE => SYSDATE,
X_LAST_UPDATED_BY => P_USER_ID,
X_LAST_UPDATE_LOGIN => 0);
BNE_SIMPLE_QUERY_PKG.INSERT_ROW (
X_ROWID => X_ROWID,
X_APPLICATION_ID => P_APPLICATION_ID,
X_QUERY_CODE => P_QUERY_CODE,
X_OBJECT_VERSION_NUMBER => 1,
X_ID_COL => P_ID_COL,
X_ID_COL_ALIAS => P_ID_COL_ALIAS,
X_MEANING_COL => P_MEANING_COL,
X_MEANING_COL_ALIAS => P_MEANING_COL_ALIAS,
X_DESCRIPTION_COL => P_DESCRIPTION_COL,
X_DESCRIPTION_COL_ALIAS => P_DESCRIPTION_COL_ALIAS,
X_ADDITIONAL_COLS => P_ADDITIONAL_COLS,
X_OBJECT_NAME => P_OBJECT_NAME,
X_ADDITIONAL_WHERE_CLAUSE => X_ADDITIONAL_WHERE_CLAUSE,
X_ORDER_BY_CLAUSE => P_ORDER_BY_CLAUSE,
X_CREATION_DATE => SYSDATE,
X_CREATED_BY => P_USER_ID,
X_LAST_UPDATE_DATE => SYSDATE,
X_LAST_UPDATED_BY => P_USER_ID,
X_LAST_UPDATE_LOGIN => 0);
BNE_RAW_QUERY_PKG.INSERT_ROW (
X_ROWID => X_ROWID,
X_APPLICATION_ID => P_APPLICATION_ID,
X_QUERY_CODE => P_QUERY_CODE,
X_SEQUENCE_NUM => X_LOOP_CNT,
X_OBJECT_VERSION_NUMBER => 1,
X_QUERY => X_ADDITIONAL_WHERE_CLAUSE,
X_CREATION_DATE => SYSDATE,
X_CREATED_BY => P_USER_ID,
X_LAST_UPDATE_DATE => SYSDATE,
X_LAST_UPDATED_BY => P_USER_ID,
X_LAST_UPDATE_LOGIN => 0);
BNE_QUERIES_PKG.INSERT_ROW (
X_ROWID => X_ROWID,
X_APPLICATION_ID => P_APPLICATION_ID,
X_QUERY_CODE => P_QUERY_CODE,
X_OBJECT_VERSION_NUMBER => 1,
X_QUERY_CLASS => 'oracle.apps.bne.query.BneRawSQLQuery',
X_USER_NAME => P_USER_NAME,
X_CREATION_DATE => SYSDATE,
X_CREATED_BY => P_USER_ID,
X_LAST_UPDATE_DATE => SYSDATE,
X_LAST_UPDATED_BY => P_USER_ID,
X_LAST_UPDATE_LOGIN => 0);
BNE_RAW_QUERY_PKG.INSERT_ROW (
X_ROWID => X_ROWID,
X_APPLICATION_ID => P_APPLICATION_ID,
X_QUERY_CODE => P_QUERY_CODE,
X_SEQUENCE_NUM => X_LOOP_CNT,
X_OBJECT_VERSION_NUMBER => 1,
X_QUERY => X_QUERY,
X_CREATION_DATE => SYSDATE,
X_CREATED_BY => P_USER_ID,
X_LAST_UPDATE_DATE => SYSDATE,
X_LAST_UPDATED_BY => P_USER_ID,
X_LAST_UPDATE_LOGIN => 0);
BNE_QUERIES_PKG.INSERT_ROW (
X_ROWID => X_ROWID,
X_APPLICATION_ID => P_APPLICATION_ID,
X_QUERY_CODE => P_QUERY_CODE,
X_OBJECT_VERSION_NUMBER => 1,
X_QUERY_CLASS => P_QUERY_CLASS,
X_USER_NAME => P_USER_NAME,
X_CREATION_DATE => SYSDATE,
X_CREATED_BY => P_USER_ID,
X_LAST_UPDATE_DATE => SYSDATE,
X_LAST_UPDATED_BY => P_USER_ID,
X_LAST_UPDATE_LOGIN => 0);
PROCEDURE DELETE_QUERY
(P_APPLICATION_ID IN NUMBER,
P_QUERY_CODE IN VARCHAR2
)
IS
BEGIN
VALIDATE_KEYS(P_APPLICATION_ID, P_QUERY_CODE);
DELETE FROM BNE_QUERIES_B WHERE APPLICATION_ID = P_APPLICATION_ID AND QUERY_CODE = P_QUERY_CODE;
DELETE FROM BNE_QUERIES_TL WHERE APPLICATION_ID = P_APPLICATION_ID AND QUERY_CODE = P_QUERY_CODE;
DELETE FROM BNE_SIMPLE_QUERY WHERE APPLICATION_ID = P_APPLICATION_ID AND QUERY_CODE = P_QUERY_CODE;
DELETE FROM BNE_RAW_QUERY WHERE APPLICATION_ID = P_APPLICATION_ID AND QUERY_CODE = P_QUERY_CODE;
END DELETE_QUERY;