The following lines contain the word 'select', 'insert', 'update' or 'delete':
INSERT INTO QP_INTERFACE_ERRORS
(
ERROR_ID
,LAST_UPDATE_DATE
,LAST_UPDATED_BY
,CREATION_DATE
,CREATED_BY
,LAST_UPDATE_LOGIN
,REQUEST_ID
,PROGRAM_APPLICATION_ID
,PROGRAM_ID
,PROGRAM_UPDATE_DATE
,ENTITY_TYPE
,TABLE_NAME
,ORIG_SYS_HEADER_REF
,ORIG_SYS_LINE_REF
,ORIG_SYS_QUALIFIER_REF
,ORIG_SYS_PRICING_ATTR_REF
,ERROR_MESSAGE
)
VALUES
(
QP_INTERFACE_ERRORS_S.NEXTVAL
,sysdate
,FND_GLOBAL.USER_ID
,sysdate
,FND_GLOBAL.USER_ID
,FND_GLOBAL.CONC_LOGIN_ID
,G_MSG_REC.REQUEST_ID(I)
,660
,NULL
,NULL
,G_MSG_REC.entity_type(I)
,G_MSG_REC.table_name(I)
,G_MSG_REC.ORIG_SYS_HEADER_REF(I)
,G_MSG_REC.ORIG_SYS_LINE_REF(I)
,G_MSG_REC.ORIG_SYS_QUALIFIER_REF(I)
,G_MSG_REC.ORIG_SYS_PRICING_ATTR_REF(I)
,G_MSG_REC.error_message(I)
);
G_MSG_REC.entity_type.delete;
G_MSG_REC.request_id.delete;
G_MSG_REC.table_name.delete;
G_MSG_REC.orig_sys_header_ref.delete;
G_MSG_REC.orig_sys_line_ref.delete;
G_MSG_REC.orig_sys_qualifier_ref.delete;
G_MSG_REC.orig_sys_pricing_attr_ref.delete;
G_MSG_REC.error_message.delete;