Remove All Group Roles from a User Group

Use this API to remove all Roles from the User Group.

Name

CDR_PUB_SECURITY_PKG.RemoveAllGrpRoles

Signature

PROCEDURE REMOVEALLGRPROLES( 
  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_USERGRPID  IN    NUMBER, 
  PI_COMPANY_ID  IN    NUMBER 
); 

Parameters

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

• PI_USERGRPID (Mandatory) Enter the numeric ID to identify the User Group. This parameter is of type Number and corresponds to the CDR_UG_ROLES.USER_GROUP_ID%TYPE column.
• PI_COMPANY_ID (Mandatory) Enter the Company Id.