USP_RECORDOPERATION_PROSPECTRESEARCHTEMPLATE_DELETE

Executes the "Prospect Research Report Template: Delete" record operation.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	Input parameter indicating the ID of the record being deleted.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the delete.

Definition

Copy



                    CREATE procedure dbo.USP_RECORDOPERATION_PROSPECTRESEARCHTEMPLATE_DELETE (
                        @ID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier = null
                    ) as begin
                        --check deletion rules, if any


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

            declare @contextCache varbinary(128);
                --cache current context information

                set @contextCache = CONTEXT_INFO();
                set CONTEXT_INFO @CHANGEAGENTID;

            delete from dbo.PROSPECTRESEARCHTEMPLATEDEFAULT where PROSPECTRESEARCHTEMPLATEID = @ID;

                        exec dbo.USP_PROSPECTRESEARCHTEMPLATE_DELETEBYID_WITHCHANGEAGENTID @ID, @CHANGEAGENTID

            --reset CONTEXT_INFO to previous value

                if not @contextCache is null
                    set CONTEXT_INFO @contextCache;

                        return 0;
                    end