Remove a Codelist

Use this API to remove a codelist. After this API is executed, public view 'DME_PUB_CODELIST_V' will not display the codelist.

Name

DME_PUB_CODE_LISTS.RemoveCodeList

Signature

PROCEDURE REMOVECODELIST
  (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,    P_NAMING           IN OUT NOCOPY cdr_naming_version_obj_type,    X_RETURN_STATUS OUT NOCOPY VARCHAR2,    X_MSG_COUNT OUT NOCOPY     NUMBER,    X_MSG_DATA OUT NOCOPY      VARCHAR2
);

Parameters

This API has standard parameters (see Standard Parameters) as well as the following parameters:

• P_NAMING (Mandatory). This is a parameter of type CDR_NAMING_VERSION_OBJ_TYPE. Enter values for the codelist from which the code-value pairs have to be removed.