USP_DATAFORMTEMPLATE_EDITLOAD_SPONSORSHIPCANCEL

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

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@TSLONG	bigint	INOUT	Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record.
@DONORNAME	nvarchar(100)	INOUT	Sponsor
@HEADER	nvarchar(100)	INOUT	Cancellation reason
@OPPORTUNITYNAME	nvarchar(100)	INOUT	Opportunity
@REASONID	uniqueidentifier	INOUT	Reason

Definition

Copy



                CREATE procedure USP_DATAFORMTEMPLATE_EDITLOAD_SPONSORSHIPCANCEL 
        (
        @ID uniqueidentifier,
        @DATALOADED bit = 0 output,
        @TSLONG bigint = 0 output,
        @DONORNAME nvarchar(100) = null output,
          @HEADER nvarchar(100) = null output,
        @OPPORTUNITYNAME nvarchar(100) = null output,
        @REASONID uniqueidentifier = null output
        )
        as
        set nocount on;

          set @DATALOADED = 0
          set @TSLONG = 0
        declare @CONSTITUENTID uniqueidentifier=null;
        declare @SPONSORSHIPOPPORTUNITYID uniqueidentifier=null;

        --Get constituent id and opportunity id from sponsorship

        select
               @DATALOADED = 1,
               @TSLONG = TSLONG,
           @CONSTITUENTID = CONSTITUENTID,
           @SPONSORSHIPOPPORTUNITYID = SPONSORSHIPOPPORTUNITYID
        from
           dbo.SPONSORSHIP
        where
           ID = @ID
        and
           STATUSCODE = 1
        and not exists(select 'x'
                       from dbo.SPONSORSHIP PENDING
                       where PENDING.SPONSORSHIPCOMMITMENTID = SPONSORSHIP.SPONSORSHIPCOMMITMENTID
                       and PENDING.STATUSCODE = 0)

        -- Find out if project or child

        select
           --@SPONSORSHIPOPPORTUNITYTYPE = SP.SPONSORSHIPOPPORTUNITYTYPE,

           @OPPORTUNITYNAME =
           case SG.SPONSORSHIPOPPORTUNITYTYPECODE
              when  1
              then  SC.NAME
              else  SPR.NAME
           end 
        from
           SPONSORSHIPOPPORTUNITY SO
           inner join SPONSORSHIPOPPORTUNITYGROUP SG on SG.ID = SO.SPONSORSHIPOPPORTUNITYGROUPID
           left join SPONSORSHIPOPPORTUNITYCHILD SC on SO.ID = SC.ID
           left join SPONSORSHIPOPPORTUNITYPROJECT SPR on SO.ID = SPR.ID
        where 
           SO.ID = @SPONSORSHIPOPPORTUNITYID

        --Get name of constituent

        select
           @DONORNAME = NF.NAME
        from
           dbo.UFN_CONSTITUENT_DISPLAYNAME(@CONSTITUENTID) NF

       return 0;