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;