APPS.EDR_EVIDENCESTORE_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 205

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';

Line: 239

    	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 );

Line: 277

END Update_Document;

Line: 821

	x_document_rec.LAST_UPDATE_DATE := l_docDetl_rec.LAST_UPDATE_DATE;

Line: 822

	x_document_rec.LAST_UPDATED_BY 	:= l_docDetl_rec.LAST_UPDATED_BY;

Line: 823

	x_document_rec.LAST_UPDATE_LOGIN := l_docDetl_rec.LAST_UPDATE_LOGIN;

Line: 920

           X_SIGNATUREDETAILS.LAST_UPDATE_DATE := l_SIGNATUREDETAILS.LAST_UPDATE_DATE;

Line: 921

           X_SIGNATUREDETAILS.LAST_UPDATE_LOGIN := l_SIGNATUREDETAILS.LAST_UPDATE_LOGIN;

Line: 922

           X_SIGNATUREDETAILS.LAST_UPDATED_BY := l_SIGNATUREDETAILS.LAST_UPDATED_BY;