1 PACKAGE arpcurr AS
2 /* $Header: ARPLCURS.pls 120.4.12010000.1 2008/07/24 16:50:09 appldev ship $ */
3
4 FunctionalCurrency fnd_currencies.currency_code%TYPE;
5 --
6 FUNCTION CurrRound( p_amount IN NUMBER , p_currency_code IN VARCHAR2 := FunctionalCurrency ) RETURN NUMBER;
7 FUNCTION ReconcileAcctdAmounts( p_ExchangeRate IN NUMBER,
8 p_ReconcileAmount IN NUMBER,
9 p_ReconcileAcctdAmount IN NUMBER,
10 p_ChildAmount IN NUMBER,
11 p_RunningTotalAmount IN OUT NOCOPY NUMBER,
12 p_RunningTotalAcctdAmount IN OUT NOCOPY NUMBER ) RETURN NUMBER;
13
14
15 PROCEDURE GetCurrencyDetails( p_currency_code IN VARCHAR2,
16 p_precision OUT NOCOPY NUMBER,
17 p_mau OUT NOCOPY NUMBER );
18 --
19
20
21 FUNCTION functional_amount(amount IN NUMBER,
22 currency_code IN VARCHAR2,
23 exchange_rate IN NUMBER,
24 precision IN NUMBER,
25 min_acc_unit IN NUMBER) RETURN NUMBER ;
26
27
28 Function GetFunctCurr(p_set_of_books_id IN Number) RETURN VARCHAR2;
29 --
30 Function GetConvType(p_conv_type IN varchar2) RETURN VARCHAR2;
31 --
32
33 TYPE getrate_seg_type IS
34 TABLE OF varchar2(100)
35 INDEX BY BINARY_INTEGER;
36
37 TYPE getrate_id_type IS
38 TABLE OF NUMBER
39 INDEX BY BINARY_INTEGER;
40
41 pg_getrate_hash_seg_cache getrate_seg_type;
42 pg_getrate_line_seg_cache getrate_seg_type;
43 pg_getrate_hash_id_cache getrate_id_type;
44 pg_getrate_line_id_cache getrate_id_type;
45
46 /* Bug 3810649 */
47 pg_init_seg_cache getrate_seg_type;
48
49 tab_size NUMBER := 0;
50
51 Function GetRate(p_from_curr_code IN varchar2,p_to_curr_code IN varchar2,p_conversion_date DATE,p_conversion_type IN varchar2) RETURN NUMBER;
52 --
53 Function RateExists(p_set_of_books_id IN NUMBER,p_from_curr_code IN varchar2,p_conversion_date DATE,p_conversion_type IN varchar2) RETURN VARCHAR2;
54 --
55 Function IsFixedRate(p_rec_curr_code IN varchar2,
56 p_funct_curr_code IN varchar2,
57 p_rec_conversion_date DATE,
58 p_trx_curr_code IN varchar2 Default NULL,
59 p_trx_conversion_date DATE Default NULL) RETURN VARCHAR2;
60 --
61 PROCEDURE flush_cached_rates;
62
63 PROCEDURE init;
64
65 END arpcurr;
[Home] [Help]