USP_ADDRESSVALIDATION_DELETE

Executes the "Address Validation: 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_ADDRESSVALIDATION_DELETE
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier
)
as
    set nocount on;

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

    declare @PROCESSID uniqueidentifier;

    select @PROCESSID = AVP.ID
    from dbo.ADDRESSVALIDATION
    inner join dbo.ADDRESSVALIDATIONPROCESS AVP on ADDRESSVALIDATION.ID = AVP.ADDRESSVALIDATIONID
    where ADDRESSVALIDATION.ID = @ID;

    exec dbo.USP_BUSINESSPROCESS_PARAMETERSETCANBEDELETED 'ADDRESSVALIDATIONPROCESSSTATUS', @PROCESSID;

    exec dbo.USP_BUSINESSPROCESSINSTANCE_DELETE '3e0ecea2-194e-4260-a9d6-4fc21de8867c', @PROCESSID, @CHANGEAGENTID;

    exec dbo.USP_ADDRESSVALIDATION_DELETEBYID_WITHCHANGEAGENTID @ID, @CHANGEAGENTID;
    return 0;