USP_DATAFORMTEMPLATE_VIEW_DISBURSEMENTPROCESSSIGNATURE

The load procedure used by the view dataform template "Disbursement Process Signature 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.
@SIGNATURE1OPTIONCODE	tinyint	INOUT	SIGNATURE1OPTIONCODE
@SIGNATURE2OPTIONCODE	tinyint	INOUT	SIGNATURE2OPTIONCODE
@SIGNATURE1USERNAME	nvarchar(100)	INOUT	SIGNATURE1USERNAME
@SIGNATURE2USERNAME	nvarchar(100)	INOUT	SIGNATURE2USERNAME
@SIGNATURE1OPTION	nvarchar(100)	INOUT	SIGNATURE1OPTION
@SIGNATURE2OPTION	nvarchar(100)	INOUT	SIGNATURE2OPTION
@SIGNATURE1COLLECTION	xml	INOUT	SIGNATURE1COLLECTION
@SIGNATURE2COLLECTION	xml	INOUT	SIGNATURE2COLLECTION

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_DISBURSEMENTPROCESSSIGNATURE
(
    @ID uniqueidentifier
    ,@DATALOADED bit = 0 output
  ,@SIGNATURE1OPTIONCODE tinyint = null output
  ,@SIGNATURE2OPTIONCODE tinyint = null output
    ,@SIGNATURE1USERNAME nvarchar(100) = null output
    ,@SIGNATURE2USERNAME nvarchar(100) = null output
  ,@SIGNATURE1OPTION nvarchar(100) = null output
  ,@SIGNATURE2OPTION nvarchar(100) = null output
  ,@SIGNATURE1COLLECTION xml = null output
  ,@SIGNATURE2COLLECTION xml = null output
)
as
    set nocount on;

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

    set @DATALOADED = 0;

    -- populate the output parameters, which correspond to fields on the form.  Note that

    -- we set @DATALOADED = 1 to indicate that the load was successful.  Otherwise, the system

    -- will display a "no data loaded" message.

    select @DATALOADED = 1
        ,@SIGNATURE1OPTIONCODE = T.SIGNATURE1OPTIONCODE
        ,@SIGNATURE2OPTIONCODE = T.SIGNATURE2OPTIONCODE
        ,@SIGNATURE1USERNAME = dbo.UFN_SIGNATURE_USERNAME(S1.SIGNERCODE, S1.NAME, S1.APPUSERID)
        ,@SIGNATURE2USERNAME = dbo.UFN_SIGNATURE_USERNAME(S2.SIGNERCODE, S2.NAME, S2.APPUSERID)
        ,@SIGNATURE1OPTION = T.SIGNATURE1OPTION
        ,@SIGNATURE2OPTION = T.SIGNATURE2OPTION
        ,@SIGNATURE1COLLECTION = dbo.UFN_DISBURSEMENTPROCESS_VIEWSIGNATURES_TOITEMLISTXML(T.ID, 0)
        ,@SIGNATURE2COLLECTION = dbo.UFN_DISBURSEMENTPROCESS_VIEWSIGNATURES_TOITEMLISTXML(T.ID, 1)
    from dbo.DISBURSEMENTPROCESS T
        left outer join dbo.BANKACCOUNTAUTHORIZEDSIGNATURE B1 on B1.ID = T.SIGNATURE1ID
        left outer join dbo.BANKACCOUNTAUTHORIZEDSIGNATURE B2 on B2.ID = T.SIGNATURE2ID
        left outer join dbo.SIGNATURE S1 on S1.ID = B1.SIGNATUREID
        left outer join dbo.SIGNATURE S2 on S2.ID = B2.SIGNATUREID
    where T.ID = @ID

    return 0;