Assign Roles to a Subtype Operation

Use this API to assign a role to an operation for a subtype of an object.

Name

CDR_PUB_SECURITY_PKG.AssignRolesToSubtypeOperation

Signature

PROCEDURE ASSIGNROLESTOSUBTYPEOPERATION( 
  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, 
  PIO_ROLESTOOPR  IN OUT    CDR_SUBTYPE_OPR_ROLES_COLL 
); 

Parameters

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

• PIO_ROLESTOOPR (Mandatory) This is a collection of CDR_SUBTYPE_OPR_ROLE_OBJ_TYPE.
• PI_REPLACEALL This parameter allows you to choose either replace the role(s) already assigned with a new list of roles or to add new assignments to the existing ones. If you do not specify a value for this parameter, the existing assignments are replaced by default.
  • Set to T to unassign all currently assigned roles when the new role is assigned.
  • Set to F to retain all currently assigned roles when the new role is assigned.