USP_DATAFORMTEMPLATE_EDITLOAD_GIFTAIDREFRESHPROCESS

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@TSLONG	bigint	INOUT
@NAME	nvarchar(100)	INOUT
@DESCRIPTION	nvarchar(255)	INOUT
@RECORDTYPEID	uniqueidentifier	INOUT
@IDSETREGISTERID	uniqueidentifier	INOUT
@CURRENTAPPUSERID	uniqueidentifier	IN
@SITEREQUIRED	bit	INOUT
@SITEID	uniqueidentifier	INOUT

Definition

Copy



create procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_GIFTAIDREFRESHPROCESS
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @TSLONG bigint = 0 output,
    @NAME nvarchar(100) = null output,
    @DESCRIPTION nvarchar(255) = null output,
    @RECORDTYPEID uniqueidentifier = null output,
    @IDSETREGISTERID uniqueidentifier = null output,
    @CURRENTAPPUSERID uniqueidentifier = null,
    @SITEREQUIRED bit = null output,
    @SITEID uniqueidentifier = null output
)
as

    set nocount on;

    set @DATALOADED = 0;
    set @TSLONG = 0;

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

    select
        @DATALOADED = 1,
        @TSLONG = GIFTAIDREFRESHPROCESS.TSLONG,
        @NAME = GIFTAIDREFRESHPROCESS.NAME,
        @DESCRIPTION = GIFTAIDREFRESHPROCESS.DESCRIPTION,
        @IDSETREGISTERID = GIFTAIDREFRESHPROCESS.IDSETREGISTERID,
        @SITEREQUIRED = dbo.UFN_SITEREQUIREDFORUSER(@CURRENTAPPUSERID),
        @SITEID = BUSINESSPROCESSINSTANCE.SITEID
    from 
        dbo.GIFTAIDREFRESHPROCESS
        left join dbo.BUSINESSPROCESSINSTANCE on  BUSINESSPROCESSINSTANCE.BUSINESSPROCESSPARAMETERSETID = GIFTAIDREFRESHPROCESS.ID
            and BUSINESSPROCESSINSTANCE.BUSINESSPROCESSCATALOGID = '9c973934-79a3-4a74-9ea5-fc432cfa7e9d'
    where 
        GIFTAIDREFRESHPROCESS.ID = @ID;

    return 0;