USP_DATAFORMTEMPLATE_EDITLOAD_PROSPECTRESEARCHREQUEST

The load procedure used by the edit dataform template "Prospect Research Request Edit Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@TSLONG	bigint	INOUT	Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record.
@STATUSCODE	tinyint	INOUT	Status
@RECORDTYPECODE	tinyint	INOUT	Record type
@CONSTITUENTS	xml	INOUT	Prospects to research
@EVENTID	uniqueidentifier	INOUT	Event to include in request
@RESEARCHGROUPID	uniqueidentifier	INOUT	Research group to include in request
@PROSPECTRESEARCHREQUESTPRIORITYCODEID	uniqueidentifier	INOUT	Priority
@DUEDATE	date	INOUT	Due date
@PROSPECTRESEARCHREQUESTTYPECODEID	uniqueidentifier	INOUT	Research type
@PROSPECTRESEARCHREQUESTREASONCODEID	uniqueidentifier	INOUT	Request reason
@REQUESTEDBYID	uniqueidentifier	INOUT	Requested by
@SUBMITTEDBYID	uniqueidentifier	INOUT	Submitted by
@NOTES	nvarchar(max)	INOUT	Notes
@COPYTOLINKEDREQUESTS	bit	INOUT	Update research request information on open individual requests
@SITES	xml	INOUT	Sites

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_PROSPECTRESEARCHREQUEST
(
  @ID uniqueidentifier,
  @DATALOADED bit = 0 output,
  @TSLONG bigint = 0 output,
  @STATUSCODE tinyint = null output,
  @RECORDTYPECODE tinyint = null output,
  @CONSTITUENTS xml = null output,
  @EVENTID uniqueidentifier = null output,
  @RESEARCHGROUPID uniqueidentifier = null output,
  @PROSPECTRESEARCHREQUESTPRIORITYCODEID uniqueidentifier = null output,
  @DUEDATE date = null output,
  @PROSPECTRESEARCHREQUESTTYPECODEID uniqueidentifier = null output,
  @PROSPECTRESEARCHREQUESTREASONCODEID uniqueidentifier = null output,
  @REQUESTEDBYID uniqueidentifier = null output,
  @SUBMITTEDBYID uniqueidentifier = null output,
  @NOTES nvarchar(max) = null output,
  @COPYTOLINKEDREQUESTS bit = null output,
  @SITES xml = null output
)
as
  set nocount on;

  -- be sure to set these, in case the select returns no rows

  set @DATALOADED = 0;
  set @TSLONG = 0;

  select
    @DATALOADED = 1,
    @TSLONG = TSLONG,
    @STATUSCODE = STATUSCODE,
    @RECORDTYPECODE = RECORDTYPECODE,
    @CONSTITUENTS = dbo.UFN_PROSPECTRESEARCHREQUEST_GETCONSTITUENTS_TOITEMLISTXML(@ID),
    @EVENTID = EVENTID,
    @RESEARCHGROUPID = RESEARCHGROUPID,
    @PROSPECTRESEARCHREQUESTPRIORITYCODEID = PROSPECTRESEARCHREQUESTPRIORITYCODEID,
    @DUEDATE = DUEDATE,
    @PROSPECTRESEARCHREQUESTTYPECODEID = PROSPECTRESEARCHREQUESTTYPECODEID,
    @PROSPECTRESEARCHREQUESTREASONCODEID = PROSPECTRESEARCHREQUESTREASONCODEID,
    @REQUESTEDBYID = REQUESTEDBYID,
    @SUBMITTEDBYID = SUBMITTEDBYID,
    @NOTES = NOTES,
    @COPYTOLINKEDREQUESTS = 1,
    @SITES = dbo.UFN_PROSPECTRESEARCHREQUEST_GETSITES_TOITEMLISTXML(PROSPECTRESEARCHREQUEST.ID)
  from dbo.PROSPECTRESEARCHREQUEST
  where ID = @ID;

  if @STATUSCODE = 6 begin
    raiserror('Canceled requests cannot be edited.', 13, 1);
    return 1;
  end

  return 0;