USP_DATAFORMTEMPLATE_PRELOAD_NAMINGOPPORTUNITYREVENUEORCONSTITUENTRECOGNITION

The load procedure used by the edit dataform template "Naming Opportunity Revenue Or Constituent Recognition Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@NAMINGOPPORTUNITYID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@QUANTITYAVAILABLE	int	INOUT	Quantity available
@BASECURRENCYID	uniqueidentifier	INOUT	Base currency

Definition

Copy


              CREATE procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_NAMINGOPPORTUNITYREVENUEORCONSTITUENTRECOGNITION
              (
                  @NAMINGOPPORTUNITYID uniqueidentifier,
                  @QUANTITYAVAILABLE int = null output,
                  @BASECURRENCYID uniqueidentifier = null output
              )
              as
              set nocount on;

                  select 
                      @QUANTITYAVAILABLE = NAMINGOPPORTUNITY.REMAINING,
                      @BASECURRENCYID = NAMINGOPPORTUNITY.BASECURRENCYID
                  from dbo.NAMINGOPPORTUNITY
                  where NAMINGOPPORTUNITY.ID = @NAMINGOPPORTUNITYID    

                  return 0;