The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Update_Document (
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2,
p_commit IN VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
P_DOCUMENT_ID IN NUMBER,
P_PSIG_XML IN CLOB DEFAULT NULL,
P_PSIG_DOCUMENT IN CLOB DEFAULT NULL,
P_PSIG_DOCUMENTFORMAT IN VARCHAR2 DEFAULT NULL,
P_PSIG_REQUESTER IN VARCHAR2,
P_PSIG_SOURCE IN VARCHAR2 DEFAULT NULL,
P_EVENT_NAME IN VARCHAR2 DEFAULT NULL,
P_EVENT_KEY IN VARCHAR2 DEFAULT NULL,
p_wf_notif_ID IN NUMBER DEFAULT NULL )
IS
l_api_name CONSTANT VARCHAR2(50) := 'Update_Document';
edr_psig.updateDocument( P_DOCUMENT_ID => p_document_id,
P_PSIG_XML => p_psig_xml,
P_PSIG_DOCUMENT => p_psig_document,
P_PSIG_DOCUMENTFORMAT => p_psig_documentFormat,
P_PSIG_REQUESTER => p_psig_REQUESTER,
P_PSIG_SOURCE => p_psig_SOURCE,
P_EVENT_NAME => P_EVENT_NAME,
P_EVENT_KEY => P_EVENT_KEY,
p_WF_NID => p_wf_notif_id,
P_ERROR => l_error_code,
P_ERROR_MSG => l_error_mesg );
END Update_Document;
x_document_rec.LAST_UPDATE_DATE := l_docDetl_rec.LAST_UPDATE_DATE;
x_document_rec.LAST_UPDATED_BY := l_docDetl_rec.LAST_UPDATED_BY;
x_document_rec.LAST_UPDATE_LOGIN := l_docDetl_rec.LAST_UPDATE_LOGIN;
X_SIGNATUREDETAILS.LAST_UPDATE_DATE := l_SIGNATUREDETAILS.LAST_UPDATE_DATE;
X_SIGNATUREDETAILS.LAST_UPDATE_LOGIN := l_SIGNATUREDETAILS.LAST_UPDATE_LOGIN;
X_SIGNATUREDETAILS.LAST_UPDATED_BY := l_SIGNATUREDETAILS.LAST_UPDATED_BY;