USP_DATAFORMTEMPLATE_VIEW_ACKNOWLEDGEMENT

The load procedure used by the view dataform template "Acknowledgement 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.
@SOLICITCODES	xml	INOUT	Solicit codes
@NAMEFORMATPARAMETEROPTION	nvarchar(100)	INOUT	Name format
@ADDRESSPROCESSINGOPTION	nvarchar(100)	INOUT	Address processing
@FREQUENCY	int	INOUT	FREQUENCY
@SCHEDULEMODIFIED	bit	INOUT	SCHEDULEMODIFIED

Definition

Copy



create procedure dbo.USP_DATAFORMTEMPLATE_VIEW_ACKNOWLEDGEMENT
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @SOLICITCODES xml = null output,
    @NAMEFORMATPARAMETEROPTION nvarchar(100) = null output,
    @ADDRESSPROCESSINGOPTION nvarchar(100)= null output,
    @FREQUENCY int = null output,  
    @SCHEDULEMODIFIED bit = null output
)
as
    set nocount on;

    set @DATALOADED = 0;    

  select 
    @DATALOADED = 1,
    @SOLICITCODES = dbo.UFN_SIMPLEACKNOWLEDGEMENT_GETSOLICITCODES_TOITEMLISTXML(MKTSEGMENTATION.ID),
    @NAMEFORMATPARAMETEROPTION = coalesce(NAMEFORMATPARAMETER.NAME,'No name formatting option selected'),
        @ADDRESSPROCESSINGOPTION = coalesce(ADDRESSPROCESSINGOPTION.NAME,'No address processing option selected'),
    @FREQUENCY = 0,
    @SCHEDULEMODIFIED = 0
    /*
    ,            
        @FREQUENCY = isnull((select top 1 sysschedules.freq_type --weekly = 8 daily = 1
                                                from msdb.dbo.sysschedules 
                                                inner join msdb.dbo.sysjobschedules on sysschedules.schedule_id = sysjobschedules.schedule_id
                                                inner join msdb.dbo.sysjobsteps on sysjobschedules.job_id = sysjobsteps.job_id
                                                inner join msdb.dbo.sysjobs on sysjobschedules.job_id = sysjobs.job_id
                                                inner join msdb.dbo.sysproxies on sysjobsteps.proxy_id = sysproxies.proxy_id
                                                where sysjobsteps.subsystem = 'ActiveScripting'
                                                    and sysproxies.name = 'Blackbaud ActiveX Proxy - ' + db_name()
                                                    and sysjobsteps.step_name = 'Business process invoke'
                                                    and (null is null or sysjobsteps.command like '%DatabaseName=' + null + '&%')
                                                    and sysjobsteps.command like '%' + @MKTACKNOWLEDGEMENTMAILINGPROCESSID + '%'),0),
        @SCHEDULEMODIFIED = dbo.UFN_ACKANDRECEIPTING_SCHEDULEMODIFIED(@MKTACKNOWLEDGEMENTMAILINGPROCESSID),
    */
    from 
    dbo.MKTSEGMENTATION
        left join dbo.NAMEFORMATPARAMETER on NAMEFORMATPARAMETER.ID = MKTSEGMENTATION.NAMEFORMATPARAMETERID
        left join dbo.ADDRESSPROCESSINGOPTION on ADDRESSPROCESSINGOPTION.ID = MKTSEGMENTATION.ADDRESSPROCESSINGOPTIONID
    where 
    MKTSEGMENTATION.ID = @ID;

    return 0;