create procedure [dbo].[MssWebCreateOrderTask]
    @inOrderId int,
    @inSysUserId int,
    @inProfileId int,
    @inRolloutId int,
    @inIdentifier varchar(64),
    @inDescription varchar(60),
    @inCoordinatorTypeId int,
    @inAssignedUserId int,
    @inDependencyDateId int,
    @inDependencyTaskId int,
    @inDueDays int,
    @inDueType int,
    @inDueDate Datetime,
    @inTaskPriorityFid int,
    @inOpenUserFlag bit,
    @inIsActive bit,
    @inIsFreeTask bit
as
begin
set nocount on;
    declare @newTaskId int;
    declare @outToDoId int

    exec spInsertTask
    @inProfileId ,
    @inDescription,
    @inCoordinatorTypeId,
    @inDependencyDateId,
    @inDependencyTaskId,
    @inDueDays,
    @inDueType,
    @inIsActive,
    @inIsFreeTask ,
    @inDueDate,
    @inTaskPriorityFid,
    @newTaskId output;

    exec spInsertToDo
    @inRolloutId,
    @inProfileId,
    @newTaskId,
    @inSysUserId,
    @inAssignedUserId,
    @inOrderId,
    @inOpenUserFlag,
    @inIdentifier,
    @outToDoId output;

    select @outToDoId
end
GO
GRANT EXECUTE ON  [dbo].[MssWebCreateOrderTask] TO [MssExec]
GO