IF OBJECT_ID(N'[KY_NetUpdateTemplateActions]',N'P')IS NOT NULL
  DROP PROCEDURE [KY_NetUpdateTemplateActions]
GO
CREATE PROCEDURE
       [KY_NetUpdateTemplateActions]
      (@ACTIONCODE              VARCHAR(15),
       @DESC                    VARCHAR(100),
       @WKTCODE                 VARCHAR(4),
       @ACTTYPE                 VARCHAR(1),
       @Actioncategory          VARCHAR(1),
       @STATUS                  VARCHAR(3),
       @PROCESSTYPE             VARCHAR(1),
       @PUBLISHER               VARCHAR(1),
       @UPDATEFIELD             VARCHAR(30),
       @UPDATEVALUE             VARCHAR(255),
       @HIGHLIGHTED             VARCHAR(1),
       @MILESTONETYPE           VARCHAR(12),
       @PRIORITY                VARCHAR(6),
       @NEXTACTIONOPTIONAL      VARCHAR(1),
       @BILLABLE                VARCHAR(1),
       @EMAIL                   VARCHAR(1),
       @BILLDESCRIPTION         VARCHAR(150),
       @AssignActionTo          VARCHAR(1),
       @ASSIGNHANDLER           VARCHAR(10),
       @AssignTeamActionTo      VARCHAR(1),
       @ASSIGNTEAM              VARCHAR(10),
       @ChargeValue             VARCHAR(9),
       @Arrangement             VARCHAR(3),
       @ChargeInterest          VARCHAR(1),
       @Description             VARCHAR(100),
       @AutoPopulate            VARCHAR(1),
       @RequiredAction          VARCHAR(1),
       @AuthorisationRequired   VARCHAR(1),
       @Authby                  VARCHAR(10),
       @ConfirmByPW             VARCHAR(1),
       @InsertStatus            VARCHAR(10),
       @Flag                    TINYINT,
       @HoldCasePlan			VARCHAR(1),
       @KYC						VARCHAR(1))  
AS
/*****************************************************************************

Stored Procedure Name: [KY_NetUpdateTemplateActions]
Description:   This procedure is used Insert the information for work flow Action Page.

 Last Updated: 30June2014 07:11 PM
               2014-12-16  sridharan     Added a flag parameter
               2015-02-12  pino          handler and team codes can be up
                                         to 10 characters
               2015JUN16   sridharan	Added a HoldcasePlan Parameter	
*****************************************************************************/
BEGIN
SET NOCOUNT ON

IF (@InsertStatus = 'True')
  BEGIN
    IF NOT EXISTS
      (SELECT TOP 1 1
         FROM [dbo].[TemplateActions] TAC
        WHERE TAC.[ACTIONCODE] = @ACTIONCODE)
      BEGIN
        INSERT
          INTO [dbo].[TemplateActions]
              ([ACTIONCODE],
               [DESC],
               [WKTCODE],
               [ACTTYPE],
               [actioncategory],
               [STATUS],
               [PROCESSTYPE],
               [PUBLISHER],
               [UPDATEFIELD],
               [UPDATEVALUE],
               [HIGHLIGHTED],
               [MILESTONETYPE],
               [PRIORITY],
               [NEXTACTIONOPTIONAL],
               [BILLABLE],
               [EMAIL],
               [BILLDESCRIPTION],
               [AssignActionTo],
               [ASSIGNHANDLER],
               [AssignTeamActionTo],
               [ASSIGNTEAM],
               [ChargeValue],
               [Arrangement],
               [ChargeInterest],
               [Description],
               [AutoPopulate],
               [RequiredAction],
               [AuthorisationRequired],
               [Authby],
               [ConfirmByPW],
               [Flag],
               [HoldCasePlan],
               [KYC])  
        VALUES(@ACTIONCODE,
               @DESC,
               @WKTCODE,
               @ACTTYPE,
               @Actioncategory,
               @STATUS,
               @PROCESSTYPE,
               @PUBLISHER,
               @UPDATEFIELD,
               @UPDATEVALUE,
               @HIGHLIGHTED,
               @MILESTONETYPE,
               @PRIORITY,
               @NEXTACTIONOPTIONAL,
               @BILLABLE,
               @EMAIL,
               @BILLDESCRIPTION,
               @AssignActionTo,
               @ASSIGNHANDLER,
               @AssignTeamActionTo,
               @ASSIGNTEAM,
               @ChargeValue,
               @Arrangement,
               @ChargeInterest,
               @Description,
               @AutoPopulate,
               @RequiredAction,
               @AuthorisationRequired,
               @Authby,
               @ConfirmByPW,
               @Flag,
               @HoldCasePlan,
               @KYC)  
		
		EXEC [dbo].[Ky_NetAssignTemplateAction] @WKTCODE, @ACTIONCODE

        SELECT 'True'
      END
    ELSE
      BEGIN
        SELECT 'False'
      END
  END
ELSE
  BEGIN
    UPDATE TAC
       SET TAC.[DESC]                    = @DESC,
           TAC.[WKTCODE]                 = @WKTCODE,
           TAC.[ACTTYPE]                 = @ACTTYPE,
           TAC.[actioncategory]          = @actioncategory,
           TAC.[STATUS]                  = @STATUS,
           TAC.[PROCESSTYPE]             = @PROCESSTYPE,
           TAC.[PUBLISHER]               = @PUBLISHER,
           TAC.[UPDATEFIELD]             = @UPDATEFIELD,
           TAC.[HIGHLIGHTED]             = @HIGHLIGHTED,
           TAC.[MILESTONETYPE]           = @MILESTONETYPE,
           TAC.[PRIORITY]                = @PRIORITY,
           TAC.[NEXTACTIONOPTIONAL]      = @NEXTACTIONOPTIONAL,
           TAC.[BILLABLE]                = @BILLABLE,
           TAC.[AssignActionTo]          = @AssignActionTo,
           TAC.[ASSIGNHANDLER]           = @ASSIGNHANDLER,
           TAC.[AssignTeamActionTo]      = @AssignTeamActionTo,
           TAC.[ASSIGNTEAM]              = @ASSIGNTEAM,
           TAC.[ChargeValue]             = @ChargeValue,
           TAC.[Arrangement]             = @Arrangement,
           TAC.[ChargeInterest]          = @ChargeInterest,
           TAC.[AutoPopulate]            = @AutoPopulate,
           TAC.[RequiredAction]          = @RequiredAction,
           TAC.[AuthorisationRequired]   = @AuthorisationRequired,
           TAC.[Authby]                  = @Authby,
           TAC.[ConfirmByPW]             = @ConfirmByPW,
           TAC.[Flag]                    = @Flag,
           TAC.HoldCasePlan              = @HoldCasePlan,
           TAC.[KYC]					 = @KYC   
      FROM [dbo].[TemplateActions] TAC
     WHERE TAC.[ACTIONCODE]              = @ACTIONCODE

    SELECT 'True'
  END



SET NOCOUNT OFF
END
GO