USP_DATAFORMTEMPLATE_EDITSAVE_SPONSORSHIPCANCELTRANSFER

The save procedure used by the edit dataform template "Cancel Pending Sponsorship Transfer 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_SPONSORSHIPCANCELTRANSFER
          (    
          @ID uniqueidentifier,
          @CHANGEAGENTID uniqueidentifier = null,
          @REASONID uniqueidentifier
          )
          as 

            begin try
    declare @FROMSPONSORSHIPID uniqueidentifier
    declare @TOSPONSORSHIPID uniqueidentifier

    exec dbo.USP_GETPENDINGTRANSFERSPONSORSHIPS
        @ID,
        @FROMSPONSORSHIPID output,
        @TOSPONSORSHIPID output

    if @FROMSPONSORSHIPID is not null and
       @TOSPONSORSHIPID is not null
         exec dbo.USP_SPONSORSHIP_CANCELTRANSFER
             @FROMSPONSORSHIPID,
             @TOSPONSORSHIPID,
             @REASONID,
             @CHANGEAGENTID
    else
    begin
      raiserror('BBERR_NOPENDINGTRANSFER', 13, 1);
      return 1
    end
            end try
            begin catch
              exec dbo.USP_RAISE_ERROR;
              return 1;
            end catch          
          return 0;