IF EXISTS (SELECT * From sysobjects Where id = object_id('$(@SPID)$') AND sysstat & 0xf = 4)
    DROP PROCEDURE $(@SPID)$
GO
/*********************************************************************************************************************
    설   명: [저장] 1마스터 2시트 화면의 첫번째 시트 체크 SP입니다.  
    SP Name: $(@SPID)$
    작성일 : $(@CurrDate)$, $(@DevUserName)$
    수정일 : 
********************************************************************************************************************/
CREATE PROCEDURE $(@SPID)$ 
    @ServiceSeq     INT     = 0,  
    @WorkingTag     NVARCHAR(10)= '',  
    @CompanySeq     INT     = 1,  
    @LanguageSeq    INT     = 1,  
    @UserSeq        INT     = 0,  
    @PgmSeq         INT     = 0,  
    @IsTransaction  BIT     = 0   

AS    

    DECLARE @MessageType  INT,
            @Status       INT,
            @Results      NVARCHAR(250)  , 
            @Count	  INT,
            @Seq	  INT
        

    --------------------------------------------------------------------------------------
    -- 데이터 유무 체크 : UPDATE, DELETE 시 데이터 존해하지 않으면 에러처리
    --------------------------------------------------------------------------------------
     IF NOT EXISTS (SELECT 1 
                      FROM $(@InTableName)$ AS A 
                            JOIN $(@G_SS1)$ AS B WITH(NOLOCK) ON $(#JKCC_columns)$
                     WHERE A.WorkingTag IN ('U', 'D'))
     BEGIN
         EXEC dbo._SCOMMessage @MessageType OUTPUT,
                               @Status      OUTPUT,
                               @Results     OUTPUT,
                               7                  , -- 자료가 등록되어 있지 않습니다.(SELECT * FROM _TCAMessageLanguage WHERE MessageSeq = 7)
                               @LanguageSeq       , 
                               '',''   -- SELECT * FROM _TCADictionary WHERE Word like '%%'        

         UPDATE $(@OutTableName)$
            SET Result        = @Results,
                MessageType   = @MessageType,
                Status        = @Status
          WHERE WorkingTag IN ('U','D')
    END               

 
    -------------------------------------------  
    -- 순번 생성 
    -------------------------------------------      
  
    SELECT @Count = COUNT(1) FROM $(@OutTableName)$ WHERE WorkingTag = 'A' AND Status = 0    


    IF @Count > 0    
    BEGIN      
        -- 키값생성코드부분 시작      
	SELECT @Seq = ISNULL(MAX(B.$(@G_Key2.Last)$), 0)
        	        FROM $(@OutTableName)$ AS A   
                	JOIN $(@G_SS1)$ AS B ON $(#JMCC_columns))$  
    
        -- Temp Talbe 에 생성된 키값 UPDATE    
        UPDATE $(@OutTableName)$    
           SET $(@G_Key2.Last)$   = @Seq + A.DataSeq   
          FROM $(@OutTableName)$ AS A   
         WHERE A.WorkingTag = 'A'    
           AND A.Status = 0    
    END  

    -------------------------------------------  
    -- 내부코드 0값일시 에러 발생
    -------------------------------------------      
    EXEC dbo._SCOMMessage @MessageType OUTPUT,    
                          @Status      OUTPUT,    
                          @Results     OUTPUT,    
                          1055               , -- 처리작업중 에러가 발생했습니다. 다시 처리하십시요!(SELECT * FROM _TCAMessageLanguage WHERE LanguageSeq = 1 and MessageSeq = 1055)    
                          @LanguageSeq       

    UPDATE $(@OutTableName)$
       SET Result        = @Results     ,    
           MessageType   = @MessageType ,    
           Status        = @Status    
      FROM $(@OutTableName)$
     WHERE Status = 0
       AND $(#WKCD_columns)$


    RETURN