USP_DATAFORMTEMPLATE_EDIT_OPPORTUNITYSOLICITOR
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | |
| @OPPORTUNITYSOLICITORS | xml | IN | |
| @CHANGEAGENTID | uniqueidentifier | IN |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_OPPORTUNITYSOLICITOR
(
@ID uniqueidentifier,
@OPPORTUNITYSOLICITORS xml,
@CHANGEAGENTID uniqueidentifier = null
)
as
set nocount on;
if @CHANGEAGENTID is null
exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;
declare @CURRENTDATE datetime = getdate();
exec dbo.USP_OPPORTUNITYSOLICITOR_UPDATEFROMXML @ID, @OPPORTUNITYSOLICITORS, @CHANGEAGENTID, @CURRENTDATE;
return 0;