USP_DATAFORMTEMPLATE_EDIT_COMMUNICATIONEFFORTBUSINESSUNITS
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | |
| @CHANGEAGENTID | uniqueidentifier | IN | |
| @BUSINESSUNITS | xml | IN |
Definition
Copy
CREATE procedure dbo.[USP_DATAFORMTEMPLATE_EDIT_COMMUNICATIONEFFORTBUSINESSUNITS]
(
@ID uniqueidentifier,
@CHANGEAGENTID uniqueidentifier = null,
@BUSINESSUNITS xml
)
as
set nocount on;
begin try
if @CHANGEAGENTID is null
exec dbo.[USP_CHANGEAGENT_GETORCREATECHANGEAGENT] @CHANGEAGENTID output;
exec dbo.[USP_MKTSEGMENTATIONBUSINESSUNIT_GETBUSINESSUNITS_UPDATEFROMXML] @ID, @BUSINESSUNITS, @CHANGEAGENTID;
end try
begin catch
exec dbo.[USP_RAISE_ERROR];
return 1;
end catch
return 0;