Create a Codelist
Use this API to create a codelist under a library domain. Codelists created with this API can be verified through public view 'DME_PUB_CODELIST_V'. For values refer 'DME_PUB_CODELIST_VALUES_V'.
Name
DME_PUB_CODE_LISTS.CreateCodeList
Signature
PROCEDURE CREATECODELIST
(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. For OBJECT_TYPE_RC enter
'
$OBJTYPES$CODELIST'
. - P_CODELISTCOLL (Optional). 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