1 PACKAGE hri_oltp_view_currency AS
2 /* $Header: hriovcrn.pkh 120.1 2006/10/09 15:24:47 jtitmas noship $ */
3
4 /******************************************************************************/
5 /* Function to convert an amount from one currency to another, given a */
6 /* specified conversion rate type */
7 /******************************************************************************/
8 FUNCTION convert_currency_amount(p_from_currency IN VARCHAR2
9 ,p_to_currency IN VARCHAR2
10 ,p_conversion_date IN DATE
11 ,p_amount IN NUMBER
12 ,p_rate_type IN VARCHAR2)
13 RETURN NUMBER;
14
15 FUNCTION convert_to_primary_crnc(p_from_currency IN VARCHAR2
16 ,p_amount IN NUMBER)
17 RETURN NUMBER;
18
19 FUNCTION convert_to_secondary_crnc(p_from_currency IN VARCHAR2
20 ,p_amount IN NUMBER)
21 RETURN NUMBER;
22
23 END hri_oltp_view_currency;