USP_SPONSORSHIPTERMINATEPROCESS_DELETE

Executes the "Sponsorship Terminate Process: Delete" record operation.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	Input parameter indicating the ID of the record being deleted.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the delete.

Definition

Copy



        CREATE procedure dbo.USP_SPONSORSHIPTERMINATEPROCESS_DELETE
        (
            @ID uniqueidentifier,
            @CHANGEAGENTID uniqueidentifier)
        as 
            set nocount on;
            --check deletion rules, if any

           --exec dbo.USP_BUSINESSPROCESS_PARAMETERSETCANBEDELETED 'SPONSORSHIPTERMINATEPROCESS', @ID;

            exec dbo.USP_BUSINESSPROCESSINSTANCE_DELETE '69C2165C-F0D6-446D-9B59-5208E27FB71C', @ID, @CHANGEAGENTID;                
            exec dbo.USP_SPONSORSHIPTERMINATEPROCESS_DELETEBYID_WITHCHANGEAGENTID @ID, @CHANGEAGENTID;
            return 0;