Get Codelist Details for a Given Column
Use this API to get the codelist details for a given column.
Name
DME_PUB_CODE_LISTS. getCodeListDetail
Signature
PROCEDURE GETCODELISTDETAIL (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, X_RETURN_STATUS OUT NOCOPY VARCHAR2 , X_MSG_COUNT OUT NOCOPY NUMBER, X_MSG_DATA OUT NOCOPY VARCHAR2, PI_COLCOMPANYID IN cdr_naming_versions.company_id%type, PI_COLOBJID IN cdr_naming_versions.obj_id%type, PI_COLOBJVER IN cdr_naming_versions.obj_ver%type, PO_CODELISTID OUT NOCOPY cdr_naming_versions.obj_id%type, PO_CODELISTVER OUT NOCOPY cdr_naming_versions.obj_Ver%type );
Parameters
This API has standard parameters (see Standard Parameters) as well as the following parameters:
- PI_COLCOMPANYID (Mandatory). COMPANY_ID of a Column.
- PI_COLOBJID (Mandatory). Object Identifier of a Column
- PI_COLOBJVER (Mandatory). Object Version of a Column
- PO_CODELISTID This is out parameter. It returns the Object Id of associated codelist.
- PO_CODELISTVER This is out parameter. It returns the Object Version of associated codelist.
Parent topic: Create and Modify Codelists