Update a Validation Supporting Document
You can use this API to upload a new document, change attributes such as its description, or both.
Name
CDR_PUB_VL_VALIDATION.UpdateValDocument
Signature
PROCEDURE UPDATEVALDOCUMENT( P_API_VERSION IN NUMBER ,P_INIT_MSG_LIST IN VARCHAR2 DEFAULT CDR_PUB_DEF_CONSTANTS.G_FALSE ,P_COMMIT IN VARCHAR2 DEFAULT CDR_PUB_DEF_CONSTANTS.G_FALSE ,P_VALIDATION_LEVEL IN NUMBER DEFAULT CDR_PUB_DEF_CONSTANTS.G_VALID_LEVEL_FULL ,X_RETURN_STATUS OUT NOCOPY VARCHAR2 ,X_MSG_COUNT OUT NOCOPY NUMBER ,X_MSG_DATA OUT NOCOPY VARCHAR2 , PI_VALDOCOBJ IN CDR_VAL_DOC_BLOB_OBJ_TYPE );
Parameters
This API has standard parameters (see Standard Parameters) and the following parameter:
PI_VALDOCOBJ (Mandatory) This is a parameter of type CDR_VAL_DOC_BLOB_OBJ_TYPE. The following attributes of the document to be updated are required: DOCUMENT_ID, COMPANY_ID, OBJ_ID, OBJ_VER, DOCUMENT_NAME, DOC_STATUS_RC, DOCUMENT_VER, DESCRIPTION, CHANGE_REASON, FILE_ID, FILE_NAME, OS_FILE_PATH,FILE_BLOB, FILE_CONTENT_TYPE, OBJECT_VERSION_NUMBER.
To get the OBJECT_VERSION_NUMBER, enter the following query:
select Max(OBJECT_VERSION_NUMBER) from cdr_vl_val_docs_v where OBJ_ID = <objid> and OBJ_VER = <objver> and DOC_STATUS_RC = '$VALINFOSTATUS$ACTIVE';
Parent topic: Create and Modify Validation Supporting Documents