USP_RECORDOPERATION_TRIBUTELETTERCODEMARKINACTIVE

Executes the "Tribute Letter: Mark Inactive" record operation.

Parameters

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

Definition

Copy



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

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

                        if exists (
                            select 1 from dbo.TRIBUTEACKNOWLEDGEMENTPROCESS 
                            where TRIBUTEACKNOWLEDGEMENTPROCESS.TRIBUTELETTERCODEID = @ID)

                            begin
                                raiserror('BBERR_TRIBUTELETTERINUSE', 13, 1);
                            end
                        else                            
                            begin
                                update
                                    dbo.TRIBUTELETTERCODE
                                set
                                    ISACTIVE = 0,
                                    CHANGEDBYID = @CHANGEAGENTID,
                                    DATECHANGED = getdate()
                                where
                                    TRIBUTELETTERCODE.ID = @ID;
                            end
                        return 0;