USP_DATAFORMTEMPLATE_EDIT_ORGANIZATIONHIERARCHYPOSITIONEDIT
USP_DATAFORMTEMPLATE_EDIT_ORGANIZATIONHIERARCHYPOSITIONEDIT
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. |
@NAME | nvarchar(50) | IN | Position title |
@SITEID | uniqueidentifier | IN | Site |
@CURRENTAPPUSERID | uniqueidentifier | IN |
Definition
Copy
CREATE procedure USP_DATAFORMTEMPLATE_EDIT_ORGANIZATIONHIERARCHYPOSITIONEDIT
(
@ID uniqueidentifier,
@CHANGEAGENTID uniqueidentifier = null,
@NAME nvarchar(50),
@SITEID uniqueidentifier,
@CURRENTAPPUSERID uniqueidentifier = null
)
as
set nocount on;
declare @BUSINESSUNITCODEID uniqueidentifier;
exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_ORGANIZATIONHIERARCHYPOSITIONEDIT
@ID = @ID,
@CURRENTAPPUSERID = @CURRENTAPPUSERID,
@BUSINESSUNITCODEID = @BUSINESSUNITCODEID output
exec dbo.USP_DATAFORMTEMPLATE_EDIT_ORGANIZATIONHIERARCHYPOSITIONEDIT_2
@ID,
@CHANGEAGENTID,
@NAME,
@SITEID,
@BUSINESSUNITCODEID
return 0;