Obsolete a Validation Supporting Document

Use this API to remove a validation supporting document.

Name

CDR_PUB_VL_VALIDATION.RemoveValDocument

Signature

PROCEDURE REMOVEVALDOCUMENT(
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 obsoleted are required: DOCUMENT_ID, COMPANY_ID, DOCUMENT_VER, 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';