USP_PHONEFINDER_DELETE

Executes the "PhoneFinder: 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.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.

Definition

Copy



CREATE procedure dbo.USP_PHONEFINDER_DELETE
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier,
    @CURRENTAPPUSERID uniqueidentifier
)
as 
    set nocount on;

    if @CHANGEAGENTID is null
        exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

    begin try
        declare @SUBMITPROCESSID uniqueidentifier;
        declare @GETPROCESSID uniqueidentifier;
        declare @RESUBMITPROCESSID uniqueidentifier;

        select
            @SUBMITPROCESSID = PHONEFINDERSUBMITPROCESS.[ID],
            @GETPROCESSID = PHONEFINDERGETPROCESS.[ID],
            @RESUBMITPROCESSID = PHONEFINDERRESUBMITPROCESS.[ID]
        from
            dbo.PHONEFINDER
            left outer join dbo.PHONEFINDERSUBMITPROCESS on PHONEFINDERSUBMITPROCESS.[PHONEFINDERID] = PHONEFINDER.[ID]
            left outer join dbo.PHONEFINDERGETPROCESS on PHONEFINDERGETPROCESS.[PHONEFINDERID] = PHONEFINDER.[ID]
            left outer join dbo.PHONEFINDERRESUBMITPROCESS on PHONEFINDERRESUBMITPROCESS.[PHONEFINDERID] = PHONEFINDER.[ID]
        where
            PHONEFINDER.[ID] = @ID;

        exec dbo.USP_BUSINESSPROCESSINSTANCE_DELETE '7b8f15bb-9c5e-49e3-82d1-999b7b1a6843', @SUBMITPROCESSID, @CHANGEAGENTID;
        exec dbo.USP_BUSINESSPROCESSINSTANCE_DELETE '1b4e38e5-74ae-4743-b716-94800c008e66', @GETPROCESSID, @CHANGEAGENTID;
        exec dbo.USP_BUSINESSPROCESSINSTANCE_DELETE '44e99271-3171-4a34-993b-3b41f49138c1', @RESUBMITPROCESSID, @CHANGEAGENTID;

        exec dbo.USP_PHONEFINDER_DELETEBYID_WITHCHANGEAGENTID @ID, @CHANGEAGENTID;
    end try
    begin catch
        exec dbo.USP_RAISE_ERROR;
        return 1;
    end catch

    return 0;