USP_DATAFORMTEMPLATE_EDIT_PROSPECTRESEARCHREQUEST

Compatibility procedure for USP_DATAFORMTEMPLATE_EDIT_PROSPECTRESEARCHREQUEST_2

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@STATUSCODE	tinyint	IN	Status
@PROSPECTRESEARCHREQUESTPRIORITYCODEID	uniqueidentifier	IN	Priority
@DUEDATE	date	IN	Due date
@PROSPECTRESEARCHREQUESTTYPECODEID	uniqueidentifier	IN	Research type
@PROSPECTRESEARCHREQUESTREASONCODEID	uniqueidentifier	IN	Request reason
@REQUESTEDBYID	uniqueidentifier	IN	Requested by
@SUBMITTEDBYID	uniqueidentifier	IN	Submitted by
@NOTES	nvarchar(max)	IN	Notes
@COPYTOLINKEDREQUESTS	bit	IN	Update research request information on open individual requests
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_PROSPECTRESEARCHREQUEST 
            (
                @ID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier = null,
                @STATUSCODE tinyint,
                @PROSPECTRESEARCHREQUESTPRIORITYCODEID uniqueidentifier,
                @DUEDATE date,
                @PROSPECTRESEARCHREQUESTTYPECODEID uniqueidentifier,
                @PROSPECTRESEARCHREQUESTREASONCODEID uniqueidentifier,
                @REQUESTEDBYID uniqueidentifier,
                @SUBMITTEDBYID uniqueidentifier,
                @NOTES nvarchar(max),
                @COPYTOLINKEDREQUESTS bit,
                @CURRENTAPPUSERID uniqueidentifier
            )
            as
            set nocount on;

            declare @SITES xml;
            set @SITES = null;

            exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_PROSPECTRESEARCHREQUEST
                @ID = @ID, 
                @SITES = @SITES output;

            exec dbo.USP_DATAFORMTEMPLATE_EDIT_PROSPECTRESEARCHREQUEST_2
                @ID,
                @CHANGEAGENTID,
                @STATUSCODE,
                @PROSPECTRESEARCHREQUESTPRIORITYCODEID,
                @DUEDATE,
                @PROSPECTRESEARCHREQUESTTYPECODEID,
                @PROSPECTRESEARCHREQUESTREASONCODEID,
                @REQUESTEDBYID,
                @SUBMITTEDBYID,
                @NOTES,
                @COPYTOLINKEDREQUESTS,
                @CURRENTAPPUSERID,
                @SITES;