Remove a Subtype

Use this API to delete a subtype that is not Active. If objects are assigned to the subtype, you cannot delete it even if it is Inactive.

Name

CDR_PUB_SECURITY_PKG.RemoveSubtype

Signature

PROCEDURE REMOVESUBTYPE( 
  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_SUBTYPEID  IN    CDR_OBJECT_SUBTYPES_B.OBJECT_SUBTYPE_ID%TYPE, 
  PI_COMPANYID  IN    CDR_OBJECT_SUBTYPES_B.COMPANY_ID%TYPE, 
  PI_OBJECTTYPERC  IN    CDR_OBJECT_SUBTYPES_B.OBJECT_TYPE_RC%TYPE 
); 

Parameters

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

• PI_SUBTYPEID (Mandatory) Enter the OBJECT_SUBTYPE_ID of the subtype you want to delete.
• PI_COMPANYID (Mandatory) Enter the COMPANY_ID associated with the OBJ_SUBTYPE_ID.
• PI_OBJECTTYPERC (Mandatory) Enter the OBJECT_TYPE_RC value for the object type associated with the subtype.