USP_DATAFORMTEMPLATE_EDIT_SOLICITORCREDITRULES

The save procedure used by the edit dataform template "Solicitor Credit Rules Edit Data Form".

Parameters

Parameter Parameter Type Mode Description
@CHANGEAGENTID uniqueidentifier IN Input parameter indicating the ID of the change agent invoking the procedure.
@PRIMARYMANAGERPERCENT decimal(5, 2) IN Primary manager credit percent
@SECONDARYMANAGERPERCENT decimal(5, 2) IN Secondary manager credit percent
@SECONDARYSOLICITORPERCENT decimal(5, 2) IN Secondary solicitor credit percent
@APPLYTOPLEDGES bit IN Pledge
@APPLYTODONATIONS bit IN Donation
@APPLYTOPLANNEDGIFTS bit IN Planned gift
@APPLYTOGRANTAWARDS bit IN Grant award

Definition

Copy


CREATE procedure USP_DATAFORMTEMPLATE_EDIT_SOLICITORCREDITRULES
(
    @CHANGEAGENTID uniqueidentifier,
    @PRIMARYMANAGERPERCENT decimal(5,2),
    @SECONDARYMANAGERPERCENT decimal(5,2),
    @SECONDARYSOLICITORPERCENT decimal(5,2),
    @APPLYTOPLEDGES bit,
    @APPLYTODONATIONS bit,
    @APPLYTOPLANNEDGIFTS bit,
    @APPLYTOGRANTAWARDS bit
)

as
  set nocount on;

    declare @APPLYTOMATCHINGGIFTCLAIMS bit;

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_SOLICITORCREDITRULES
        @APPLYTOMATCHINGGIFTCLAIMS = @APPLYTOMATCHINGGIFTCLAIMS output

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_SOLICITORCREDITRULES_2
        @CHANGEAGENTID,
        @PRIMARYMANAGERPERCENT,
        @SECONDARYMANAGERPERCENT,
        @SECONDARYSOLICITORPERCENT,
        @APPLYTOPLEDGES,
        @APPLYTODONATIONS,
        @APPLYTOPLANNEDGIFTS,
        @APPLYTOGRANTAWARDS,
        @APPLYTOMATCHINGGIFTCLAIMS

  return 0;