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 codes and I want 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);
l_segment1                  varchar2(200);
l_inventory_item_id         number;