USP_DATAFORMTEMPLATE_VIEW_PLEDGEREMINDERADDITIONALPARAMETERS

The load procedure used by the view dataform template "Pledge Reminder Process Additional Parameters 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.
@INDUSESEASONALADDRESS	bit	INOUT	INDUSESEASONALADDRESS
@ORGMAILINGPREFERENCE	tinyint	INOUT	ORGMAILINGPREFERENCE
@INDALTADDRESS1TYPECODEID	uniqueidentifier	INOUT	INDALTADDRESS1TYPECODEID
@INDALTADDRESS1ISPRIMARY	bit	INOUT	INDALTADDRESS1ISPRIMARY
@INDALTADDRESS2TYPECODEID	uniqueidentifier	INOUT	INDALTADDRESS2TYPECODEID
@INDALTADDRESS2ISPRIMARY	bit	INOUT	INDALTADDRESS2ISPRIMARY
@ORGALTADDRESS1TYPECODEID	uniqueidentifier	INOUT	ORGALTADDRESS1TYPECODEID
@ORGALTADDRESS1ISPRIMARY	bit	INOUT	ORGALTADDRESS1ISPRIMARY
@ORGALTADDRESS2TYPECODEID	uniqueidentifier	INOUT	ORGALTADDRESS2TYPECODEID
@ORGALTADDRESS2ISPRIMARY	bit	INOUT	ORGALTADDRESS2ISPRIMARY
@INDINCLUDEWITHNOADDRESS	bit	INOUT	INDINCLUDEWITHNOADDRESS
@ORGINCLUDEWITHNOADDRESS	bit	INOUT	ORGINCLUDEWITHNOADDRESS
@ORGINCLUDEWITHNOCONTACT	bit	INOUT	ORGINCLUDEWITHNOCONTACT
@ORGSENDTOALLCONTACTS	bit	INOUT	ORGSENDTOALLCONTACTS
@INDUSECONSTITUENTPREFS	bit	INOUT	INDUSECONSTITUENTPREFS
@ORGUSECONSTITUENTPREFS	bit	INOUT	ORGUSECONSTITUENTPREFS
@GROUPALTADDRESS1TYPECODEID	uniqueidentifier	INOUT	GROUPALTADDRESS1TYPECODEID
@GROUPALTADDRESS1ISPRIMARY	bit	INOUT	GROUPALTADDRESS1ISPRIMARY
@GROUPALTADDRESS2TYPECODEID	uniqueidentifier	INOUT	GROUPALTADDRESS2TYPECODEID
@GROUPALTADDRESS2ISPRIMARY	bit	INOUT	GROUPALTADDRESS2ISPRIMARY
@GROUPINCLUDEWITHNOADDRESS	bit	INOUT	GROUPINCLUDEWITHNOADDRESS
@GROUPUSECONSTITUENTPREFS	bit	INOUT	GROUPUSECONSTITUENTPREFS
@INDIVIDUALADDRESSEES	xml	INOUT	INDIVIDUALADDRESSEES
@ADDRESSEEFUNCTIONID	uniqueidentifier	INOUT	ADDRESSEEFUNCTIONID
@INDIVIDUALSALUTATIONS	xml	INOUT	INDIVIDUALSALUTATIONS
@SALUTATIONFUNCTIONID	uniqueidentifier	INOUT	SALUTATIONFUNCTIONID
@ORGADDRESSEES	xml	INOUT	ORGADDRESSEES
@CONTACTADDRESSEEFUNCTIONID	uniqueidentifier	INOUT	CONTACTADDRESSEEFUNCTIONID
@ORGSALUTATIONCODE	tinyint	INOUT	ORGSALUTATIONCODE
@ORGSALUTATIONS	xml	INOUT	ORGSALUTATIONS
@CONTACTSALUTATIONFUNCTIONID	uniqueidentifier	INOUT	CONTACTSALUTATIONFUNCTIONID
@CONTACTSALUTATIONOPTIONCODE	tinyint	INOUT	CONTACTSALUTATIONOPTIONCODE
@CUSTOMNAME	nvarchar(100)	INOUT	CUSTOMNAME
@GROUPADDRESSEES	xml	INOUT	GROUPADDRESSEES
@GROUPADDRESSEEFUNCTIONID	uniqueidentifier	INOUT	GROUPADDRESSEEFUNCTIONID
@GROUPSALUTATIONCODE	tinyint	INOUT	GROUPSALUTATIONCODE
@GROUPSALUTATIONS	xml	INOUT	GROUPSALUTATIONS
@GROUPSALUTATIONFUNCTIONID	uniqueidentifier	INOUT	GROUPSALUTATIONFUNCTIONID
@GROUPNOCONTACTOPTIONCODE	tinyint	INOUT	GROUPNOCONTACTOPTIONCODE
@GROUPNOCONTACTCUSTOMNAME	nvarchar(100)	INOUT	GROUPNOCONTACTCUSTOMNAME
@JOINTRULETYPECODE	tinyint	INOUT	JOINTRULETYPECODE
@JOINTSELECTIONID	uniqueidentifier	INOUT	JOINTSELECTIONID
@JOINTSELECTIONBOTHRULETYPECODE	tinyint	INOUT	JOINTSELECTIONBOTHRULETYPECODE
@JOINTSELECTIONNEITHERRULETYPECODE	tinyint	INOUT	JOINTSELECTIONNEITHERRULETYPECODE
@NAMEFORMATPARAMETERID	uniqueidentifier	INOUT	NAMEFORMATPARAMETERID
@ADDRESSPROCESSINGOPTIONID	uniqueidentifier	INOUT	ADDRESSPROCESSINGOPTIONID

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_PLEDGEREMINDERADDITIONALPARAMETERS
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @INDUSESEASONALADDRESS bit = null output,    
    @ORGMAILINGPREFERENCE tinyint = null output,    
    @INDALTADDRESS1TYPECODEID uniqueidentifier = null output,    
    @INDALTADDRESS1ISPRIMARY bit = null output,    
    @INDALTADDRESS2TYPECODEID uniqueidentifier = null output,    
    @INDALTADDRESS2ISPRIMARY bit = null output,    
    @ORGALTADDRESS1TYPECODEID uniqueidentifier = null output,    
    @ORGALTADDRESS1ISPRIMARY bit = null output,    
    @ORGALTADDRESS2TYPECODEID uniqueidentifier = null output,    
    @ORGALTADDRESS2ISPRIMARY bit = null output,    
    @INDINCLUDEWITHNOADDRESS bit = null output,    
    @ORGINCLUDEWITHNOADDRESS bit = null output,    
    @ORGINCLUDEWITHNOCONTACT bit = null output,    
    @ORGSENDTOALLCONTACTS bit = null output,    
    @INDUSECONSTITUENTPREFS bit = null output,    
    @ORGUSECONSTITUENTPREFS bit = null output,    
    @GROUPALTADDRESS1TYPECODEID uniqueidentifier = null output,    
    @GROUPALTADDRESS1ISPRIMARY bit = null output,    
    @GROUPALTADDRESS2TYPECODEID uniqueidentifier = null output,    
    @GROUPALTADDRESS2ISPRIMARY bit = null output,    
    @GROUPINCLUDEWITHNOADDRESS bit = null output,    
    @GROUPUSECONSTITUENTPREFS bit = null output,    
    @INDIVIDUALADDRESSEES xml = null output,    
    @ADDRESSEEFUNCTIONID uniqueidentifier = null output,    
    @INDIVIDUALSALUTATIONS xml = null output,    
    @SALUTATIONFUNCTIONID uniqueidentifier = null output,    
    @ORGADDRESSEES xml = null output,    
    @CONTACTADDRESSEEFUNCTIONID uniqueidentifier = null output,    
    @ORGSALUTATIONCODE tinyint = null output,
    @ORGSALUTATIONS xml = null output,    
    @CONTACTSALUTATIONFUNCTIONID uniqueidentifier = null output,    
    @CONTACTSALUTATIONOPTIONCODE tinyint = null output,    
    @CUSTOMNAME nvarchar(100) = null output,    
    @GROUPADDRESSEES xml = null output,    
    @GROUPADDRESSEEFUNCTIONID uniqueidentifier = null output,    
    @GROUPSALUTATIONCODE tinyint = null output,
    @GROUPSALUTATIONS xml = null output,    
    @GROUPSALUTATIONFUNCTIONID uniqueidentifier = null output,    
    @GROUPNOCONTACTOPTIONCODE tinyint = null output,    
    @GROUPNOCONTACTCUSTOMNAME nvarchar(100) = null output,    
    @JOINTRULETYPECODE As tinyint = null output,    
    @JOINTSELECTIONID As uniqueidentifier = null output,    
    @JOINTSELECTIONBOTHRULETYPECODE As tinyint = null output,    
    @JOINTSELECTIONNEITHERRULETYPECODE As tinyint = null output,
    @NAMEFORMATPARAMETERID As uniqueidentifier = null output,    
    @ADDRESSPROCESSINGOPTIONID As uniqueidentifier = null output
)
as
    set nocount on;

    -- be sure to set this, in case the select returns no rows

    set @DATALOADED = 1;    

    select
        @ADDRESSPROCESSINGOPTIONID=PLEDGEREMINDERPROCESS.CUSTOMPARAMETERDATAFORMITEM.query('declare namespace bbafx="bb_appfx_dataforms";bbafx:DataFormItem/bbafx:Values/bbafx:fv[fn:lower-case(@ID)=fn:lower-case("ADDRESSPROCESSINGOPTIONID")]/bbafx:Value').value('declare namespace bbafx="bb_appfx_dataforms";(bbafx:Value)[1]', 'nvarchar(36)'),
        @NAMEFORMATPARAMETERID=PLEDGEREMINDERPROCESS.CUSTOMPARAMETERDATAFORMITEM.query('declare namespace bbafx="bb_appfx_dataforms";bbafx:DataFormItem/bbafx:Values/bbafx:fv[fn:lower-case(@ID)=fn:lower-case("NAMEFORMATPARAMETERID")]/bbafx:Value').value('declare namespace bbafx="bb_appfx_dataforms";(bbafx:Value)[1]', 'nvarchar(36)')    
    from dbo.PLEDGEREMINDERPROCESS
    where PLEDGEREMINDERPROCESS.ID = @ID;

    select
        @NAMEFORMATPARAMETERID = ID,
        @INDIVIDUALADDRESSEES = dbo.UFN_NAMEFORMATPARAMETER_GETINDADDRESSEES_TOITEMLISTXML(ID),
        @ADDRESSEEFUNCTIONID  = ADDRESSEEFUNCTIONID,
        @INDIVIDUALSALUTATIONS = dbo.UFN_NAMEFORMATPARAMETER_GETINDSALUTATIONS_TOITEMLISTXML(ID),
        @SALUTATIONFUNCTIONID  = SALUTATIONFUNCTIONID,

        @ORGADDRESSEES = dbo.UFN_NAMEFORMATPARAMETER_GETORGADDRESSEES_TOITEMLISTXML(ID),
        @CONTACTADDRESSEEFUNCTIONID  = CONTACTADDRESSEEFUNCTIONID,
        @ORGSALUTATIONCODE = ORGSALUTATIONCODE,
        @ORGSALUTATIONS = dbo.UFN_NAMEFORMATPARAMETER_GETORGSALUTATIONS_TOITEMLISTXML(ID),
        @CONTACTSALUTATIONFUNCTIONID  = CONTACTSALUTATIONFUNCTIONID,
        @CONTACTSALUTATIONOPTIONCODE  = CONTACTSALUTATIONOPTIONCODE,
        @CUSTOMNAME = CUSTOMNAME,

        @GROUPADDRESSEES = dbo.UFN_NAMEFORMATPARAMETER_GETGRPADDRESSEES_TOITEMLISTXML(ID),
        @GROUPADDRESSEEFUNCTIONID  = GROUPADDRESSEEFUNCTIONID,
        @GROUPSALUTATIONCODE = GROUPSALUTATIONCODE,
        @GROUPSALUTATIONS = dbo.UFN_NAMEFORMATPARAMETER_GETGRPSALUTATIONS_TOITEMLISTXML(ID),
        @GROUPSALUTATIONFUNCTIONID  = GROUPSALUTATIONFUNCTIONID,
        @GROUPNOCONTACTOPTIONCODE  = GROUPNOCONTACTOPTIONCODE,
        @GROUPNOCONTACTCUSTOMNAME = GROUPNOCONTACTCUSTOMNAME,

        @JOINTRULETYPECODE = JOINTRULETYPECODE,
        @JOINTSELECTIONID = JOINTSELECTIONID,
        @JOINTSELECTIONBOTHRULETYPECODE = JOINTSELECTIONBOTHRULETYPECODE,
        @JOINTSELECTIONNEITHERRULETYPECODE = JOINTSELECTIONNEITHERRULETYPECODE
    from
        dbo.NAMEFORMATPARAMETER
    where (ID = @NAMEFORMATPARAMETERID) or (@NAMEFORMATPARAMETERID is null and ISDEFAULT = 1)

    select @ADDRESSPROCESSINGOPTIONID = ID,
       @INDUSESEASONALADDRESS=INDUSESEASONALADDRESS,  
       @ORGMAILINGPREFERENCE=ORGMAILINGPREFERENCE,  
       @INDALTADDRESS1TYPECODEID=INDALTADDRESS1TYPECODEID,  
       @INDALTADDRESS1ISPRIMARY=INDALTADDRESS1ISPRIMARY,  
       @INDALTADDRESS2TYPECODEID=INDALTADDRESS2TYPECODEID,  
       @INDALTADDRESS2ISPRIMARY=INDALTADDRESS2ISPRIMARY,  
       @ORGALTADDRESS1TYPECODEID=ORGALTADDRESS1TYPECODEID,  
       @ORGALTADDRESS1ISPRIMARY=ORGALTADDRESS1ISPRIMARY,  
       @ORGALTADDRESS2TYPECODEID=ORGALTADDRESS2TYPECODEID,  
       @ORGALTADDRESS2ISPRIMARY=ORGALTADDRESS2ISPRIMARY,  
       @INDINCLUDEWITHNOADDRESS=INDINCLUDEWITHNOADDRESS,  
       @ORGINCLUDEWITHNOADDRESS=ORGINCLUDEWITHNOADDRESS,  
       @ORGINCLUDEWITHNOCONTACT=ORGINCLUDEWITHNOCONTACT, 
       @ORGSENDTOALLCONTACTS=ORGSENDTOALLCONTACTS, 
       @INDUSECONSTITUENTPREFS=INDUSECONSTITUENTPREFS,  
       @ORGUSECONSTITUENTPREFS=ORGUSECONSTITUENTPREFS,  
       @GROUPALTADDRESS1TYPECODEID=GROUPALTADDRESS1TYPECODEID,  
       @GROUPALTADDRESS1ISPRIMARY=GROUPALTADDRESS1ISPRIMARY,  
       @GROUPALTADDRESS2TYPECODEID=GROUPALTADDRESS2TYPECODEID,  
       @GROUPALTADDRESS2ISPRIMARY=GROUPALTADDRESS2ISPRIMARY,  
       @GROUPINCLUDEWITHNOADDRESS=GROUPINCLUDEWITHNOADDRESS,  
       @GROUPUSECONSTITUENTPREFS=GROUPUSECONSTITUENTPREFS
      from dbo.ADDRESSPROCESSINGOPTION  
      where ID = @ADDRESSPROCESSINGOPTIONID or (@ADDRESSPROCESSINGOPTIONID is null and ISDEFAULT = 1); 

    return 0;