MOBILE_API/DB/SPs/PROC_POWERCALL.sql

USE [FastMoneyPro_Remit]
GO
/****** Object:  StoredProcedure [dbo].[PROC_POWERCALL]    Script Date: 7/4/2019 11:35:48 AM ******/
DROP PROCEDURE [dbo].[PROC_POWERCALL]
GO
/****** Object:  StoredProcedure [dbo].[PROC_POWERCALL]    Script Date: 7/4/2019 11:35:48 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-----------------------------------------------------------------------------------  
-- PROCEDURE NAME : PROC_POWERCALL  
-- DEV  DATE : 2019.03.18  
-- DEVELOPER  : ���Ѽ�  
-- DESC   :   
-- RETURN VALUE :   
-- SAMPLE  :   
-----------------------------------------------------------------------------------  
CREATE    PROCEDURE [dbo].[PROC_POWERCALL]  
(   
 @flag			VARCHAR(20),  
 @P_CUSTOMERID  BIGINT  = NULL,  
 @P_TRANID		BIGINT  = NULL,  
 @P_SENDMONEY	MONEY	= NULL  
)  
AS  
  
SET  NOCOUNT ON  
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED  
----------------------------------------------------------------------------------  
-- Procedure Start  
----------------------------------------------------------------------------------  
DECLARE @V_PARTNER_CODE VARCHAR(20) = 'POWERCALL'  
DECLARE @V_REFEREL_CODE VARCHAR(20) = ''  
 
IF @flag = 'INSERT'  
BEGIN  
	SELECT @V_REFEREL_CODE = referelCode FROM CUSTOMERMASTER(NOLOCK) WHERE CUSTOMERID = @P_CUSTOMERID  
	IF @V_REFEREL_CODE = 'POWERCALL'  
	BEGIN    
		INSERT INTO REMIT_WITH_PARTNER(PARTNER_CODE,  CUSTOMERID,  TRANID, SEND_MONEY, SEND_DATE )      
		VALUES(@V_PARTNER_CODE, @P_CUSTOMERID, @P_TRANID, @P_SENDMONEY,GETDATE())  
       
		--EXEC PROC_ERRORHANDLER 0, 'Success!', @P_CUSTOMERID;  
	END   
	--EXEC PROC_ERRORHANDLER 1, 'No Data found!', @P_CUSTOMERID;  
END   
----------------------------------------------------------------------------------  
-- Procedure End  
----------------------------------------------------------------------------------  
SET TRANSACTION ISOLATION LEVEL READ COMMITTED  
SET  NOCOUNT OFF  
  
GO