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;