1 PACKAGE OKI_DBI_CURRENCY_PVT AS
2 /* $Header: OKIRICUS.pls 120.0 2005/05/25 17:58:41 appldev noship $ */
3
4 g_chr_id NUMBER ;
5 g_conversion_date DATE ;
6 g_trx_func_rate NUMBER ;
7 g_func_global_rate NUMBER ;
8 g_func_sglobal_rate NUMBER ;
9 g_trx_rate_type VARCHAR2(30) ;
10
11 FUNCTION get_conversion_date
12 ( p_chr_id IN NUMBER
13 , p_curr_code IN VARCHAR2
14 , p_func_curr_code IN VARCHAR2
15 , p_creation_date IN DATE
16 ) RETURN DATE PARALLEL_ENABLE;
17
18 FUNCTION get_conversion_date
19 ( p_chr_id IN NUMBER
20 , p_curr_code IN VARCHAR2
21 , p_func_curr_code IN VARCHAR2
22 , p_creation_date IN DATE
23 , p_conversion_date IN DATE
24 , p_conversion_type IN VARCHAR2
25 , p_trx_func_rate in NUMBER
26 ) RETURN DATE PARALLEL_ENABLE;
27
28 FUNCTION get_dbi_global_rate
29 ( p_chr_id IN NUMBER
30 , p_curr_code IN VARCHAR2
31 , p_func_curr_code IN VARCHAR2
32 , p_creation_date IN DATE
33 , p_conversion_date IN DATE
34 , p_conversion_type IN VARCHAR2
35 , p_trx_func_rate in NUMBER
36 ) RETURN NUMBER PARALLEL_ENABLE ;
37
38 FUNCTION get_dbi_sglobal_rate
39 ( p_chr_id IN NUMBER
40 , p_curr_code IN VARCHAR2
41 , p_func_curr_code IN VARCHAR2
42 , p_creation_date IN DATE
43 , p_conversion_date IN DATE
44 , p_conversion_type IN VARCHAR2
45 , p_trx_func_rate in NUMBER
46 ) RETURN NUMBER PARALLEL_ENABLE;
47
48 FUNCTION get_trx_func_rate
49 ( p_chr_id IN NUMBER
50 , p_curr_code IN VARCHAR2
51 , p_func_curr_code IN VARCHAR2
52 , p_creation_date IN DATE
53 , p_conversion_date IN DATE
54 , p_conversion_type IN VARCHAR2
55 , p_trx_func_rate in NUMBER
56 ) RETURN NUMBER PARALLEL_ENABLE;
57
58 FUNCTION get_trx_rate_type
59 ( p_chr_id IN NUMBER
60 , p_curr_code IN VARCHAR2
61 , p_func_curr_code IN VARCHAR2
62 , p_creation_date IN DATE
63 , p_conversion_date IN DATE
64 , p_conversion_type IN VARCHAR2
65 , p_trx_func_rate in NUMBER
66 ) RETURN VARCHAR2 PARALLEL_ENABLE ;
67
68 Function get_conversion_rate ( p_chr_id IN NUMBER
69 , p_curr_code IN VARCHAR2
70 , p_func_curr_code IN VARCHAR2
71 , p_creation_date IN DATE
72 , p_conv_date IN DATE
73 , p_conv_type IN VARCHAR2
74 , p_trx_func_rate in NUMBER
75 ) RETURN DATE PARALLEL_ENABLE;
76
77 FUNCTION get_dbi_global_rate_init
78 ( p_chr_id IN NUMBER
79 , p_curr_code IN VARCHAR2
80 , p_func_curr_code IN VARCHAR2
81 , p_creation_date IN DATE
82 , p_conv_date IN DATE
83 , p_conv_type IN VARCHAR2
84 , p_trx_func_rate in NUMBER
85 ) RETURN NUMBER PARALLEL_ENABLE;
86
87
88 FUNCTION get_dbi_sglobal_rate_init
89 ( p_chr_id IN NUMBER
90 , p_curr_code IN VARCHAR2
91 , p_func_curr_code IN VARCHAR2
92 , p_creation_date IN DATE
93 , p_conv_date IN DATE
94 , p_conv_type IN VARCHAR2
95 , p_trx_func_rate in NUMBER
96 ) RETURN NUMBER PARALLEL_ENABLE;
97
98 FUNCTION get_trx_func_rate_init
99 ( p_chr_id IN NUMBER
100 , p_curr_code IN VARCHAR2
101 , p_func_curr_code IN VARCHAR2
102 , p_creation_date IN DATE
103 , p_conv_date IN DATE
104 , p_conv_type IN VARCHAR2
105 , p_trx_func_rate in NUMBER
106 ) RETURN NUMBER PARALLEL_ENABLE;
107
108 FUNCTION get_trx_rate_type_init
109 ( p_chr_id IN NUMBER
110 , p_curr_code IN VARCHAR2
111 , p_func_curr_code IN VARCHAR2
112 , p_creation_date IN DATE
113 , p_conv_date IN DATE
114 , p_conv_type IN VARCHAR2
115 , p_trx_func_rate in NUMBER
116 ) RETURN VARCHAR2 PARALLEL_ENABLE;
117
118 FUNCTION get_annualization_factor(p_start_date DATE,
119 p_end_date DATE ) RETURN NUMBER PARALLEL_ENABLE ;
120
121 END OKI_DBI_CURRENCY_PVT ;