Get a User Name

Use this API to retrieve the current user name.

Name

CDR_PUB_DEF_FACTORY_SUPPORT.GetUserName

Signature

FUNCTION GETUSERNAME( 
  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, 
  PI_USERID  IN    NUMBER 
) RETURN VARCHAR2;

Return

Type VARCHAR2

Description VARCHAR2.

Parameters

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

PI_USERID (Mandatory) Enter the User ID. Use CDR_PUB_DEF_FACTORY_SUPPORT.GETUSERID to get the ID of the current user.