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.