how to call procedure fron one to another

See more:

SQL-Server-2005

SQL-Server

Hello Team,
This is my one stored procedure as follow:

ALTER PROCEDURE [dbo].[UpdateCustomerLoanOCR]
@CUSTOMERLOANOCRID int,
@UPDATEDBY int,
@UPDATEDON datetime
AS
BEGIN
update CUSTOMERLOANOCR WITH (ROWLOCK)
set
processed = 1,
UpdatedBy = @UPDATEDBY,
UpdatedOn  = @UPDATEDON
where  id = @CUSTOMERLOANOCRID


End

This is my second Stored Procedure as follows

CREATE PROCEDURE InsertRecordInAuditCustomerLoanData
@CustomerLoanDataID INT
AS
BEGIN
Insert into AUDIT_CUSTOMERLOANDATA (CUSTOMERLOANDATAID,BATCHID,FILELOGID,[FILENAME],RECORDNO,FIRSTNAME,MIDDLENAME, LASTNAME ,MOTHERNAME,FULLADDRESS ,MOBILENO1 ,EMAILID ,
          DOB, LOAN1INTRATE ,LOAN1AMT ,LOAN2INTRATE ,LOAN2AMT ,DATEOFEMI ,
          RELEASEDATE, HOUSETYPE ,SALARY ,CUSTOMERLOANOCRID ,CUSTOMERADDR1 ,
          CUSTOMERADDR2 ,LANDMARK ,STATE ,CITY ,PINCODE  ,
          ADDRVERIFY ,PHOTOVERIFY ,GENDER ,LANDLINENO ,MOBILENO2 ,COMPANYNAME,CREATEDBY,
CREATEDON,QCTOVERIFYREMARKS,ISD1,ISD2,STD1,QCPROCESSED)
   Select ID,BATCHID,FILELOGID,[FILENAME],RECORDNO,FIRSTNAME,MIDDLENAME, LASTNAME ,MOTHERNAME,FULLADDRESS ,MOBILENO1 ,EMAILID ,
          DOB, LOAN1INTRATE ,LOAN1AMT ,LOAN2INTRATE ,LOAN2AMT ,DATEOFEMI ,
          RELEASEDATE, HOUSETYPE ,SALARY ,CUSTOMERLOANOCRID ,CUSTOMERADDR1 ,
          CUSTOMERADDR2 ,LANDMARK ,STATE ,CITY ,PINCODE  ,
          ADDRVERIFY ,PHOTOVERIFY ,GENDER ,LANDLINENO ,MOBILENO2 ,COMPANYNAME,CREATEDBY,
CREATEDON,QCTOVERIFYREMARKS,ISD1,ISD2,STD1,QCPROCESSED
from CUSTOMERLOANDATA (nolock)
where id = @CustomerLoanDataID

select @CustomerLoanDataID

end

this is my third Stored Procedure

ALTER PROCEDURE [dbo].[AddCustomerLoanData] 
@BATCHID int,
@FILELOGID int,
@FILENAME varchar(max),
@RECORDNO int,
@FIRSTNAME varchar(25),
@MIDDLENAME varchar(25),
@LASTNAME varchar(25),
@MOTHERNAME varchar(25),
@FULLADDRESS varchar(max) ,
@MOBILENO varchar(15),
@EMAILID varchar(50),
@DOB datetime = NULL,
@LOAN1INTRATE decimal(18,2),
@LOAN1AMT decimal(18,2),
@LOAN2INTRATE decimal(18,2),
@LOAN2AMT decimal(18,2),
@DATEOFEMI datetime= NULL ,
@RELEASEDATE datetime= NULL,
@HOUSETYPE varchar(15),
@SALARY decimal(18,2),
@CUSTOMERLOANOCRID int,
@CUSTOMERADDR1 varchar(100),
@CUSTOMERADDR2 varchar(100),
@LANDMARK varchar(50),
@STATE varchar(20),
@CITY varchar(20),
@PINCODE varchar(7),
@ADDRVERIFY varchar(3),
@PHOTOVERIFY varchar(3),
@GENDER varchar(6),
@LANDLINENO varchar(15),
@MOBILENO2 varchar(15),
@COMPANYNAME varchar(50),
@CREATEDBY int,
@CREATEDON datetime,
@QCTOVERIFYREMARKS varchar(max),
@ISD1 varchar(5),
@ISD2 varchar(5),
@STD1 varchar(5),
@ID INT OUT
AS
BEGIN

	
insert into 
   CUSTOMERLOANDATA (BATCHID,FILELOGID,[FILENAME],RECORDNO,FIRSTNAME,MIDDLENAME, LASTNAME ,MOTHERNAME,FULLADDRESS ,MOBILENO1 ,EMAILID ,
                                  DOB, LOAN1INTRATE ,LOAN1AMT ,LOAN2INTRATE ,LOAN2AMT ,DATEOFEMI ,
                                  RELEASEDATE, HOUSETYPE ,SALARY ,CUSTOMERLOANOCRID ,CUSTOMERADDR1 ,
                                  CUSTOMERADDR2 ,LANDMARK ,STATE ,CITY ,PINCODE  ,
                                 ADDRVERIFY ,PHOTOVERIFY ,GENDER ,LANDLINENO ,MOBILENO2 ,COMPANYNAME,CREATEDBY, CREATEDON,QCTOVERIFYREMARKS,
                                     ISD1,ISD2,STD1)
             values(@BATCHID, @FILELOGID, @FILENAME, @RECORDNO, @FIRSTNAME, @MIDDLENAME, @LASTNAME, @MOTHERNAME ,@FULLADDRESS , @MOBILENO ,@EMAILID ,
								  @DOB ,@LOAN1INTRATE ,@LOAN1AMT ,@LOAN2INTRATE ,@LOAN2AMT ,@DATEOFEMI  ,
								  @RELEASEDATE ,@HOUSETYPE ,@SALARY ,@CUSTOMERLOANOCRID ,@CUSTOMERADDR1 ,
								  @CUSTOMERADDR2 ,@LANDMARK ,@STATE ,@CITY ,@PINCODE, 
								  @ADDRVERIFY ,@PHOTOVERIFY,@GENDER ,@LANDLINENO ,@MOBILENO2 ,@COMPANYNAME, @CREATEDBY ,@CREATEDON,@QCTOVERIFYREMARKS,
                                     @ISD1,@ISD2,@STD1 )
SET @ID = @@IDENTITY;

exec UpdateCustomerLoanOCR
exec InsertRecordInAuditCustomerLoanData

End

I want to call first and second Stored Procedure in Third procedure.As i call the first and second Stored Procedure in Third procedure but it gives me error the Procedure or function 'UpdateCustomerLoanOCR' expects parameter '@UPDATEDBY', which was not supplied.As there are three parameters are present in UpdateCustomerLoanOCR and one parameter is present in InsertRecordInAuditCustomerLoanData.Please kindly tell me how should i get this solve.Is this is the right way to call procedure from one to another?

Thanks
Harshal