USP_DATAFORMTEMPLATE_VIEW_TRIBUTEACKNOWLEDGEMENTSADDITIONALPARAMETERS

The load procedure used by the view dataform template "Tribute acknowledgment 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_TRIBUTEACKNOWLEDGEMENTSADDITIONALPARAMETERS]
(
  @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=TRIBUTELETTERCODE.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=TRIBUTELETTERCODE.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.TRIBUTEACKNOWLEDGEMENTPROCESS
  inner join dbo.TRIBUTELETTERCODE
  on TRIBUTEACKNOWLEDGEMENTPROCESS.TRIBUTELETTERCODEID = TRIBUTELETTERCODE.ID
  where TRIBUTEACKNOWLEDGEMENTPROCESS.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;