USP_DATAFORMTEMPLATE_ADD_GIFTAIDREFRESHPROCESS_PRELOAD

Parameters

Parameter	Parameter Type	Mode
@CURRENTAPPUSERID	uniqueidentifier	IN
@RECORDTYPEID	uniqueidentifier	INOUT
@SITEREQUIRED	bit	INOUT
@SITEID	uniqueidentifier	INOUT

Definition

Copy



create procedure dbo.USP_DATAFORMTEMPLATE_ADD_GIFTAIDREFRESHPROCESS_PRELOAD
(
    @CURRENTAPPUSERID uniqueidentifier,
    @RECORDTYPEID uniqueidentifier = null output,
    @SITEREQUIRED bit = null output,
    @SITEID uniqueidentifier = null output
)
as
    set nocount on;

    select
        @RECORDTYPEID = ID
    from
        dbo.RECORDTYPE
    where
        upper(BASETABLENAME) = 'REVENUE';

    set @SITEREQUIRED = dbo.UFN_SITEREQUIREDFORUSER(@CURRENTAPPUSERID);
    set    @SITEID = dbo.UFN_APPUSER_DEFAULTSITEFORUSER(@CURRENTAPPUSERID);

    return 0;