Remove Values from a Codelist
Use this API to remove code value pairs to a codelist. After this API is executed, public view 'DME_PUB_CODELIST_V' will not display the codelist values.
Name
DME_PUB_CODE_LISTS.AddCodeListValues
Signature
PROCEDURE REMOVECODELISTVALUES (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. Whole naming object needs to be populated for the object which needs code values to be added to it. API 'CDR_PUB_DEF_FACTORY_SUPPORT.GETNAMINGOBJECT' can be used to populate naming object.
- 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