solution will need to use the Daily Rates table for the date of the invoice as its exchange rate.

Dear experts,

Please find the below mentioned code and we want to add the  code solution will need to use the Daily Rates table for the date of the invoice as its exchange rate.

declare

debug                         varchar2(1) := 'Y'; -- This is a (Y/N) switch to control output messages
l_interface_lines             number;     
l_error_message1              varchar2(200);
l_error_message2              varchar2(200);
l_error_code                  number  := 1; -- This is an error code to indicate which sql failed.
l_line_number                 number  := 1;

l_amount                    number;
l_inv_item_id               number;
l_exchange_rate             number;                     
l_currency_code             varchar2(10);                                 
l_inv_description           varchar2(200);