USP_RECORDOPERATION_SOLICITCODECHANNELOPTOUTDELETE

CREATE procedure dbo.USP_RECORDOPERATION_SOLICITCODECHANNELOPTOUTDELETE
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier
)
as begin
    --check deletion rules, if any


    -- remove any links in the dbo.CONSTITUENTSOLICITCODE table

    update  dbo.CONSTITUENTSOLICITCODE
    set     SOLICITCODECHANNELOPTOUTID = null
    where   SOLICITCODECHANNELOPTOUTID = @ID;

    -- use the system generated delete routine to allow proper recording of the deleting agent

    exec USP_SOLICITCODECHANNELOPTOUT_DELETEBYID_WITHCHANGEAGENTID @ID, @CHANGEAGENTID;
    return 0;

end