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');
Parent topic: Create and Modify Codelists