USP_DATAFORMTEMPLATE_ADDSAVE_WEALTHSECURITYTRANSACTIONS

The save procedure used by the add dataform template "WealthPoint Securities Transaction Add Form 2".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@SECURITYID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@WPSECURITIESTRANSACTIONS	xml	IN

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADDSAVE_WEALTHSECURITYTRANSACTIONS(
                        @ID uniqueidentifier output,
                        @CHANGEAGENTID uniqueidentifier = null,
                        @SECURITYID uniqueidentifier,
                        @WPSECURITIESTRANSACTIONS xml = null
                    ) as begin

                        set nocount on;

                        set @ID = @SECURITYID;

                        if @CHANGEAGENTID is null  
                            exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

                        exec dbo.USP_WPSECURITIES_TRANSACTIONS_ADDFROMXML @ID, @WPSECURITIESTRANSACTIONS, @CHANGEAGENTID;

                        return 0;
                    end