Create procedure [dbo].[KSBCL_USP_GetData]
(
	@Ps_RequestXML varchar (max) = null,
	@Ps_USERNAME	varchar(200) = null,
	@Ps_PASSWORD	varchar(200) = null,
	@Ps_AGENCY	varchar(200) = null,
	@Ps_SUBSCRIBER	varchar(200) = null,
	
	@Ps_TRAVELAGENT_CODE	varchar(200) = null,
	@Ps_CURRENCY_CODE	varchar(200) = null,
	@Ps_DEPOSIT_AMOUNT	varchar(200) = null,
	@Ps_TRANSACTION_DATE	varchar(200) = null,
	@Ps_BANK_NAME	varchar(200) = null,
	@Ps_BRANCH_NAME	varchar(200) = null,
	@Ps_BANKREFERENCE_NUMBER	varchar(200) = null
)
as
begin
	SET NOCOUNT ON;   
	--//Add Here
	--//1.Logic for Validations
	--//2.Logic for Generating Response
	
    select '<?xml version=''1.0'' encoding=''utf-16''?><BANKDEPOSIT><TRAVELAGENT><REQSTATUS>SUCCESSFUL</REQSTATUS><BANKREFERENCENUMBER>'+ @Ps_BANKREFERENCE_NUMBER +'</BANKREFERENCENUMBER></TRAVELAGENT></BANKDEPOSIT>' as 'ResponseXML'
  
  
	SET NOCOUNT OFF;   
end