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.
Parent topic: Create and Modify Security Policies