Add Values to a Codelist

Use this API to add code value pairs to a codelist. Codelist values created with this API can be verified through public view 'DME_PUB_CODELIST_VALUES_V'.

Note:

You can add new code-value pairs but you cannot modify existing ones using this API. You can do that in the user interface, or you can remove existing pairs (see Remove a Codelist) and add new ones using APIs.

Name

DME_PUB_CODE_LISTS.AddCodeListValues

Signature

PROCEDURE ADDCODELISTVALUES
  (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 ,    P_CODELISTCOLL     IN CDR_CODE_LIST_COLL ,    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 to which you are added code-value pairs.
• P_CODELISTCOLL (Mandatory). This is a parameter of type CDR_CODE_LIST_COLL. Collection of code value pairs. For example:

CDR_CODE_LIST_COLL(CDR_CODE_LIST_OBJ_TYPE('CDE1', 'VAL1'), CDR_CODE_LIST_OBJ_TYPE('CDE2', 'VAL2');