Get a Lookup Meaning

Use this API to get the Lookup Meaning for a Lookup Type and Code

Name

CDR_PUB_DF_NAMING_UTIL.GetLookupMeaning

Signature

PROCEDURE GETLOOKUPMEANING( 
  P_API_VERSION  IN    NUMBER, 
  P_INIT_MSG_LIST  IN    VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, 
  P_COMMIT  IN    VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, 
  P_VALIDATION_LEVEL  IN    NUMBER := CDR_PUB_DEF_CONSTANTS.G_VALID_LEVEL_FULL, 
  X_RETURN_STATUS  OUT    VARCHAR2, 
  X_MSG_COUNT  OUT    NUMBER, 
  X_MSG_DATA  OUT    VARCHAR2, 
  PI_LOOKUPTYPE  IN    VARCHAR2, 
  PI_LOOKUPCODE  IN    VARCHAR2, 
  PO_LOOKUPMEANING  OUT    VARCHAR2 
); 

Parameters

This API has standard parameters (see Standard Parameters) and the following parameters:

  • PI_LOOKUPTYPE (Mandatory) Enter the Lookup Type
  • PI_LOOKUPCODE (Mandatory) Enter the Lookup Code
  • PO_LOOKUPMEANING This is an output parameter. It returns the Lookup Meaning.