USP_DATAFORMTEMPLATE_EDITSAVE_SPONSORSHIPCANCEL

The save procedure used by the edit dataform template "Cancel Sponsorship Edit Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@REASONID	uniqueidentifier	IN	Reason

Definition

Copy



                    CREATE procedure USP_DATAFORMTEMPLATE_EDITSAVE_SPONSORSHIPCANCEL
          (    
          @ID uniqueidentifier,
          @CHANGEAGENTID uniqueidentifier = null,
          @REASONID uniqueidentifier
          )
          as
            declare @CURRENTDATEEARLIESTTIME date;
            set @CURRENTDATEEARLIESTTIME = getdate();          

            begin try
             exec dbo.USP_SPONSORSHIP_CLOSECOMMITMENT 
             @ID,
             @CURRENTDATEEARLIESTTIME,
             2,
             @REASONID,
             null,
             null,
             @CHANGEAGENTID
            end try
            begin catch
              exec dbo.USP_RAISE_ERROR;
              return 1;
            end catch          
          return 0;