PACKAGE BODY: APPS.EDW_POA_CURR_CONV

Source

1 PACKAGE BODY EDW_POA_CURR_CONV as
2 /*$Header: poacurrb.pls 115.2 2003/01/09 23:38:11 rvickrey ship $ */
3 
4 l_conversion_rate number := 1;
5 
6 function convert_currency(
7                          p_from_currency varchar2,
8                          p_to_currency varchar2,
9                          p_rate_date date,
10                          p_rate_type varchar2
11                          ) return number is
12 
13  begin
14 
15    begin
16      l_conversion_rate := gl_currency_api.get_rate(p_from_currency,p_to_currency,p_rate_date,p_rate_type);
17 
18    exception
19     when others then
20       l_conversion_rate := 1;
21    end;
22 
23  return l_conversion_rate;
24 
25  end convert_currency;
26 
27 END EDW_POA_CURR_CONV;
28