1 PACKAGE gl_mc_currency_pkg AS
2 /*$Header: glmccurs.pls 120.7 2003/04/24 01:36:23 djogg ship $*/
3
4 -- Global variable which is used for AR trigger. This variable is used at
5 -- the MRC trigger on RA_CUST_TRX_LINE_GL_DIST_ALL. The trigger fires
6 -- only if the value is set to FALSE. At the time of running the AR MRC
7 -- upgrade utility we set the value to be TRUE. This ensures that the
8 -- trigger does not fire when we insert rounding lines during the upgrade
9 -- process.
10 g_ar_upgrade_mode BOOLEAN := FALSE; -- still need this???
11
12 -- The following global variables are defined to ensure that trigger
13 -- will know whether the records are inserted/updated due to upgrade
14 -- or it is a normal transaction.
15 g_ap_upgrade_mode BOOLEAN := FALSE; -- still need this???
16 g_po_upgrade_mode BOOLEAN := FALSE; -- still need this???
17 g_fa_upgrade_mode BOOLEAN := FALSE;
18 g_pa_upgrade_mode BOOLEAN := FALSE;
19
20 FUNCTION get_currency_code (
21 p_set_of_books_id IN NUMBER) RETURN VARCHAR2;
22
23 FUNCTION get_mrc_sob_type_code (
24 p_set_of_books_id IN NUMBER) RETURN VARCHAR2;
25
26 PROCEDURE get_rate(p_primary_set_of_books_id IN NUMBER,
27 p_reporting_set_of_books_id IN NUMBER,
28 p_trans_date IN DATE,
29 p_trans_currency_code IN VARCHAR2,
30 p_trans_conversion_type IN OUT NOCOPY VARCHAR2,
31 p_trans_conversion_date IN OUT NOCOPY DATE,
32 p_trans_conversion_rate IN OUT NOCOPY NUMBER,
33 p_application_id IN NUMBER,
34 p_org_id IN NUMBER,
35 p_fa_book_type_code IN VARCHAR2,
36 p_je_source_name IN VARCHAR2,
37 p_je_category_name IN VARCHAR2,
38 p_result_code IN OUT NOCOPY VARCHAR2,
39 p_denominator_rate OUT NOCOPY NUMBER,
40 p_numerator_rate OUT NOCOPY NUMBER );
41
42 PROCEDURE get_rate(p_primary_set_of_books_id IN NUMBER,
43 p_reporting_set_of_books_id IN NUMBER,
44 p_trans_date IN DATE,
45 p_trans_currency_code IN VARCHAR2,
46 p_trans_conversion_type IN OUT NOCOPY VARCHAR2,
47 p_trans_conversion_date IN OUT NOCOPY DATE,
48 p_trans_conversion_rate IN OUT NOCOPY NUMBER,
49 p_application_id IN NUMBER,
50 p_org_id IN NUMBER,
51 p_fa_book_type_code IN VARCHAR2,
52 p_je_source_name IN VARCHAR2,
53 p_je_category_name IN VARCHAR2,
54 p_result_code IN OUT NOCOPY VARCHAR2);
55
56 FUNCTION get_default_rate (
57 p_from_currency VARCHAR2,
58 p_to_currency VARCHAR2,
59 p_conversion_date DATE,
60 p_conversion_type VARCHAR2 DEFAULT NULL ) RETURN NUMBER;
61
62 PROCEDURE GetCurrencyDetails( p_currency_code IN VARCHAR2,
63 p_precision OUT NOCOPY NUMBER,
64 p_mau OUT NOCOPY NUMBER);
65
66 FUNCTION CurrRound(p_amount IN NUMBER, p_currency_code IN VARCHAR2) RETURN NUMBER;
67
68 END gl_mc_currency_pkg;