Remove a Workflow Activity
Use this API to remove one or more Workflow activities. Workflow activities include all executable objects: Load Sets, Programs, Data Marts, and Report Sets; and also Workflow structures: And, Or, Start, End_Success, End_Warning, End_Error, and Fork.
Name
CDR_PUB_DF_WORKFLOW.RemoveObjectsFromWorkflow
Signature
PROCEDURE REMOVEOBJECTSFROMWORKFLOW( 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_CDRCHILDOBJS IN CDR_BASE_OBJ_COLL );
Parameters
This API has standard parameters (see Standard Parameters) and the following parameter:
PI_CDRCHILDOBJS (Mandatory) This is a collection of CDR_BASE_OBJ_TYPEs.
For each Workflow activity that you want to remove, initialize a CDR_BASE_OBJ_TYPE and then extend the collection.
The following attributes are required for each Workflow activity: COMPANY_ID, OBJ_ID, OBJ_VER, NAMESPACE_OBJ_ID, NAMESPACE_OBJ_VER, OBJECT_VERSION_NUMBER.
Parent topic: Create and Modify Workflows