USP_RECORDOPERATION_FLAGGEDPROSPECT_FLAG

Executes the "Prospect: Flag" record operation.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	Input parameter indicating the ID of the record being updated.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the update.

Definition

Copy



                    CREATE procedure dbo.USP_RECORDOPERATION_FLAGGEDPROSPECT_FLAG (
                        @ID uniqueidentifier,
                        @CURRENTAPPUSERID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier = null
                    ) as begin
                        set nocount on;
                        if @CHANGEAGENTID is null  
                            exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

                        if not exists(select 1 from dbo.FLAGGEDPROSPECT where PROSPECTID=@ID and APPUSERID=@CURRENTAPPUSERID)
                            insert into dbo.FLAGGEDPROSPECT (
                                PROSPECTID,
                                APPUSERID,
                                ADDEDBYID,
                                CHANGEDBYID
                            ) values (
                                @ID,
                                @CURRENTAPPUSERID,
                                @CHANGEAGENTID,
                                @CHANGEAGENTID
                            )

                        return 0
                    end