USP_DATAFORMTEMPLATE_ADD_FINDERNUMBERMEMBER

The save procedure used by the add dataform template "Acquisition List Member Temporary Add Form".

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.
@FINDERNUMBER bigint IN
@REVENUEBATCH bit IN
@CURRENTAPPUSERID uniqueidentifier IN

Definition

Copy

                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_FINDERNUMBERMEMBER
                    (
                        @ID uniqueidentifier = null output,
                        @CHANGEAGENTID uniqueidentifier = null,
                        @FINDERNUMBER bigint,
            @REVENUEBATCH bit = 0,
            @CURRENTAPPUSERID uniqueidentifier = null
                    )
                    as
                        set nocount on;

                        begin try
                            exec dbo.USP_FINDERNUMBER_ADDMEMBER @ID output,@CHANGEAGENTID,@FINDERNUMBER, @REVENUEBATCH,@CURRENTAPPUSERID;
                        end try

                        begin catch
                            exec dbo.USP_RAISE_ERROR
                            return 1;
                        end catch

                        return 0;