Modify a Codelist

Use this API to modify the name and description of a codelist. Codelists modified with this API can be verified through public view 'DME_PUB_CODELIST_V'.

Note:

To add code-value pairs, see Add Values to a Codelist.

Name

DME_PUB_CODE_LISTS.ModifyCodeList

Signature

PROCEDURE MODIFYCODELIST
(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 parameter:

P_NAMING (Mandatory). This is a parameter of type CDR_NAMING_VERSION_OBJ_TYPE. Enter values for the codelist whose code-value pairs you are modifying and the new attribute values, such as Name and Description. To get naming version attribute values see Get a Naming Version Object.