USP_DATAFORMTEMPLATE_VIEW_PRENOTIFICATIONPROCESS

The load procedure used by the view dataform template "Prenotification Process View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@NAME	nvarchar(100)	INOUT	Name
@DESCRIPTION	nvarchar(255)	INOUT	Description
@IDSETREGISTERNAME	nvarchar(60)	INOUT	Selected accounts
@DATE	datetime	INOUT	Financial processing date
@SPONSORINGINSTITUTION	nvarchar(100)	INOUT	Sponsoring institution
@IMMEDIATEDESTINATIONNAME	nvarchar(23)	INOUT	Immediate destination
@CREATECREDITOFFSETTRANSACTION	bit	INOUT	Create credit offset transaction
@CREATEOUTPUTIDSET	bit	INOUT	Create output selection
@OUTPUTIDSETNAME	nvarchar(100)	INOUT	Output selection name
@OVERWRITEOUTPUTIDSET	bit	INOUT	Overwrite existing selection
@BUSINESSPROCESSCATALOGID	uniqueidentifier	INOUT	BUSINESSPROCESSCATALOGID
@PARAMETERSID	uniqueidentifier	INOUT	PARAMETERSID
@BANKACCOUNT	nvarchar(100)	INOUT	Bank account

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_PRENOTIFICATIONPROCESS
                (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @NAME nvarchar(100)= null output,
                    @DESCRIPTION nvarchar(255)= null output,
                    @IDSETREGISTERNAME nvarchar(60) = null output,
                    @DATE datetime = null output,
                    @SPONSORINGINSTITUTION nvarchar(100) = null output,
                    @IMMEDIATEDESTINATIONNAME nvarchar(23) = null output,
                    @CREATECREDITOFFSETTRANSACTION bit = null output,
                    @CREATEOUTPUTIDSET bit = null output,
                    @OUTPUTIDSETNAME nvarchar(100) = null output,
                    @OVERWRITEOUTPUTIDSET bit = null output,
                    @BUSINESSPROCESSCATALOGID uniqueidentifier = null output,
                    @PARAMETERSID uniqueidentifier = null output,
                    @BANKACCOUNT nvarchar(100) = null output
                )
                as
                set nocount on;

                set @DATALOADED = 0;

                select
                    @DATALOADED = 1,
                    @NAME = PRENOTIFICATIONPROCESS.NAME,
                    @DESCRIPTION = PRENOTIFICATIONPROCESS.DESCRIPTION,
                    @IDSETREGISTERNAME = dbo.UFN_IDSET_GETNAME(PRENOTIFICATIONPROCESS.IDSETREGISTERID),
                    @DATE = case PRENOTIFICATIONPROCESS.DATETYPECODE
                        when 0 then getdate()
                        else PRENOTIFICATIONPROCESS.DATE
                    end,
                    @SPONSORINGINSTITUTION = FINANCIALINSTITUTION.DESCRIPTION,
                    @BANKACCOUNT = BANKACCOUNT.ACCOUNTNAME,
                    @IMMEDIATEDESTINATIONNAME = PRENOTIFICATIONPROCESS.IMMEDIATEDESTINATIONNAME,
                    @CREATECREDITOFFSETTRANSACTION = PRENOTIFICATIONPROCESS.CREATECREDITOFFSETTRANSACTION,
                    @CREATEOUTPUTIDSET = PRENOTIFICATIONPROCESS.CREATEOUTPUTIDSET,
                    @OUTPUTIDSETNAME = PRENOTIFICATIONPROCESS.OUTPUTIDSETNAME,
                    @OVERWRITEOUTPUTIDSET = PRENOTIFICATIONPROCESS.OVERWRITEOUTPUTIDSET,
                    @BUSINESSPROCESSCATALOGID = 'F327E3A6-06F8-4816-BE25-BC004E73C802',
                    @PARAMETERSID = @ID                        
                from
                    dbo.PRENOTIFICATIONPROCESS
                left outer join
                    dbo.FINANCIALINSTITUTION on PRENOTIFICATIONPROCESS.SPONSORINGINSTITUTIONID = FINANCIALINSTITUTION.ID
                left outer join
                    dbo.BANKACCOUNT on PRENOTIFICATIONPROCESS.BANKACCOUNTID = BANKACCOUNT.ID
                where
                    PRENOTIFICATIONPROCESS.ID = @ID;

                return 0;