USP_DATAFORMTEMPLATE_PRELOAD_ADD_PAYMENTBYCONSTITUENT

The load procedure used by the edit dataform template "Payment Add by Constituent Form"

Parameters

Parameter	Parameter Type	Mode	Description
@CONTEXTCONSTITUENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@CONSTITUENTID	uniqueidentifier	INOUT	Constituent
@REVENUESTREAMS	xml	INOUT	Revenue streams
@GIVENANONYMOUSLY	bit	INOUT	Gift is anonymous
@SINGLEDESIGNATIONID	uniqueidentifier	INOUT	Designation

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_ADD_PAYMENTBYCONSTITUENT
(
  @CONTEXTCONSTITUENTID uniqueidentifier,
  @CONSTITUENTID uniqueidentifier = null output,
  @REVENUESTREAMS xml = null output,
  @GIVENANONYMOUSLY bit = null output,
  @SINGLEDESIGNATIONID uniqueidentifier = null output
)
as
set nocount on;

select 
  @CONSTITUENTID = ID,
  @GIVENANONYMOUSLY = GIVESANONYMOUSLY
from dbo.CONSTITUENT 
where ID = @CONTEXTCONSTITUENTID;

set @REVENUESTREAMS = dbo.UFN_CONSTITUENT_GETREVENUESTREAMS_TOITEMLISTXML(@CONSTITUENTID);

return 0;