DBA Data[Home] [Help]

PACKAGE: APPS.POA_CURRENCY_PKG

Source


1 PACKAGE POA_CURRENCY_PKG AS
2 /* $Header: POACURS.pls 120.0 2005/06/01 13:41:54 appldev noship $ */
3 
4 g_missing_cur BOOLEAN := FALSE;
5 
6 
7   FUNCTION get_global_currency RETURN VARCHAR2;
8 
9   FUNCTION get_global_rate (x_trx_currency_code     VARCHAR2,
10                           x_exchange_date         DATE,
11                           x_exchange_rate_type    VARCHAR2 DEFAULT NULL)
12            RETURN NUMBER;
13   PRAGMA RESTRICT_REFERENCES (get_global_rate, WNDS);
14 
15   FUNCTION get_global_currency_rate (p_rate_type      VARCHAR2,
16                                      p_currency_code  VARCHAR2,
17                                      p_rate_date      DATE,
18                                      p_rate           NUMBER)  RETURN NUMBER;
19   PRAGMA RESTRICT_REFERENCES (get_global_currency_rate, WNDS);
20 
21 -- Added p_global_cur_type parameter for Secondary Global Currency
22   FUNCTION get_display_currency(p_currency_code                IN VARCHAR2,
23                                 p_selected_operating_unit      IN VARCHAR2,
24                                 p_global_cur_type              IN VARCHAR2
25                                                                     DEFAULT 'P'
26                                 ) RETURN VARCHAR2;
27 
28   FUNCTION get_dbi_global_rate (p_rate_type VARCHAR2,
29 				p_currency_code VARCHAR2,
30 				p_rate_date DATE,
31                                 p_txn_cur_code VARCHAR2) RETURN NUMBER parallel_enable;
32 
33   FUNCTION get_dbi_sglobal_rate (p_rate_type VARCHAR2,
34 				p_currency_code VARCHAR2,
35 				p_rate_date DATE,
36                                 p_txn_cur_code VARCHAR2) RETURN NUMBER parallel_enable;
37 
38 -- Functions for Secondary Global Currency
39   FUNCTION get_secondary_global_currency RETURN VARCHAR2;
40 
41   FUNCTION display_secondary_currency_yn RETURN BOOLEAN;
42 
43 END POA_CURRENCY_PKG;