1 PACKAGE po_currency_sv AS
2 /* $Header: POXDOCUS.pls 120.0 2005/06/01 18:54:43 appldev noship $*/
3 /*===========================================================================
4 FUNCTION NAME: val_currency()
5
6 DESCRIPTION: This function checks whether a given Currency
7 is still valid.
8
9
10 PARAMETERS: X_currency_code IN VARCHAR2
11
12 RETURN TYPE: BOOLEAN
13
14 DESIGN REFERENCES:
15
16 ALGORITHM:
17
18 NOTES:
19
20 OPEN ISSUES:
21
22 CLOSED ISSUES:
23
24 CHANGE HISTORY: Created 09-JUL-1995 LBROADBE
25 Changed to 14-AUG-1995 LBROADBE
26 Function
27 ===========================================================================*/
28 FUNCTION val_currency(X_currency_code IN VARCHAR2) return BOOLEAN;
29
30 /*===========================================================================
31 PROCEDURE NAME: get_rate
32
33 DESCRIPTION: Get the dispaly_rate, and conversion_rate
34 from gl_daily_conversion_rates. The inverse rate
35 is returned based on client side business
36 rules (criteria).
37
38
39 PARAMETERS: x_set_of_books_id IN NUMBER
40 x_currency_code IN VARCHAR2
41 x_rate_type IN VARCHAR2
42 x_rate_date IN DATE
43 x_inverse_rate_display_flag IN VARCHAR2
44 x_display_rate IN OUT NUMBER
45 x_rate IN OUT NUMBER
46
47
48 DESIGN REFERENCES: ../POXPOREL.doc
49 ../currency.dd
50
51 ALGORITHM: decode(:x_inverse_rate_display_flag,
52 'Y', 1/conversion_rate,
53 conversion_rate) --- gets the inverse rate
54
55 NOTES: get_default_rate = get_rate (get_default_rate
56 is referenced in POXRQERQ.doc)
57
58 OPEN ISSUES:
59
60 CLOSED ISSUES:
61
62 CHANGE HISTORY: ALOCATEL Last Change on 5/12
63 ===========================================================================*/
64
65 PROCEDURE get_rate(x_set_of_books_id IN NUMBER,
66 x_currency_code IN VARCHAR2,
67 x_rate_type IN VARCHAR2,
68 x_rate_date IN DATE,
69 x_inverse_rate_display_flag IN VARCHAR2,
70 x_rate IN OUT NOCOPY NUMBER,
71 x_display_rate IN OUT NOCOPY NUMBER);
72
73
74 /*===========================================================================
75 PROCEDURE NAME: get_rate
76
77 DESCRIPTION: Get the dispaly_rate, and conversion_rate
78 from gl_daily_conversion_rates. The inverse rate
79 is returned based on client side business
80 rules (criteria).
81
82
83 PARAMETERS: x_set_of_books_id IN NUMBER
84 x_currency_code IN VARCHAR2
85 x_rate_type IN VARCHAR2
86 x_rate_date IN DATE
87 x_inverse_rate_display_flag IN VARCHAR2
88 x_display_rate IN OUT NUMBER
89 x_rate IN OUT NUMBER
90
91
92 DESIGN REFERENCES: ../POXPOREL.doc
93 ../currency.dd
94
95 ALGORITHM: decode(:x_inverse_rate_display_flag,
96 'Y', 1/conversion_rate,
97 conversion_rate) --- gets the inverse rate
98
99 NOTES: get_default_rate = get_rate (get_default_rate
100 is referenced in POXRQERQ.doc)
101
102 OPEN ISSUES:
103
104 CLOSED ISSUES:
105
106 CHANGE HISTORY: ALOCATEL Last Change on 5/12
107 ===========================================================================*/
108
109 PROCEDURE test_get_rate(x_set_of_books_id IN NUMBER,
110 x_currency_code IN VARCHAR2,
111 x_rate_type IN VARCHAR2,
112 x_rate_date IN DATE,
113 x_inverse_rate_display_flag IN VARCHAR2);
114
115
116
117 /*===========================================================================
118 PROCEDURE NAME: get_rate_type_disp
119
120 DESCRIPTION: Get the displayed rate type given a
121 rate type.
122
123
124 PARAMETERS: x_rate_type IN VARCHAR2
125 x_rate_type_disp IN OUT VARCHAR2
126
127
128 DESIGN REFERENCES: POXRQERQ.doc
129
130 ALGORITHM:
131
132 NOTES:
133
134 OPEN ISSUES:
135
136 CLOSED ISSUES:
137
138 CHANGE HISTORY: Ramana Y. Mulpury 06/27
139 ===========================================================================*/
140
141 PROCEDURE get_rate_type_disp (x_rate_type IN VARCHAR2,
142 x_rate_type_disp IN OUT NOCOPY VARCHAR2);
143
144 /*===========================================================================
145 PROCEDURE NAME: validate_currency_info
146
147 DESCRIPTION: Validates the components of the currency record
148 and returns error status and error messages based
149 on a set of business rules.
150
151 PARAMETERS: p_cur_record IN OUT RCV_SHIPMENT_HEADER_SV.CurRecType
152
153 DESIGN REFERENCES:
154
155 ALGORITHM:
156
157 NOTES:
158
159 OPEN ISSUES:
160
161 CLOSED ISSUES:
162
163 CHANGE HISTORY: Raj Bhakta 11/01/96 Created
164 ===========================================================================*/
165
166 PROCEDURE validate_currency_info (
167 p_cur_record IN OUT NOCOPY RCV_SHIPMENT_HEADER_SV.CurRecType);
168
169 --<Shared Proc FPJ START>
170 PROCEDURE get_functional_currency_code(
171 p_org_id IN NUMBER,
172 x_functional_currency_code OUT NOCOPY VARCHAR2);
173
174 FUNCTION rate_exists(
175 p_from_currency VARCHAR2,
176 p_to_currency VARCHAR2,
177 p_conversion_date DATE,
178 p_conversion_type VARCHAR2 DEFAULT NULL) RETURN VARCHAR2;
179
180 PROCEDURE get_rate(p_from_currency IN VARCHAR2,
181 p_to_currency IN VARCHAR2,
182 p_rate_type IN VARCHAR2,
183 p_rate_date IN DATE,
184 p_inverse_rate_display_flag IN VARCHAR2,
185 x_rate OUT NOCOPY NUMBER,
186 x_display_rate OUT NOCOPY NUMBER,
187 x_return_status OUT NOCOPY VARCHAR2,
188 x_error_message_name OUT NOCOPY VARCHAR2);
189 --<Shared Proc FPJ END>
190
191 -- bug3294883
192 FUNCTION get_currency_precision ( p_currency IN VARCHAR2 ) RETURN NUMBER;
193
194 --<HTMLAC START>
195 FUNCTION get_cross_ou_rate ( p_from_ou_id IN NUMBER, p_to_ou_id IN NUMBER )
196 RETURN NUMBER;
197 --<HTMLAC END>
198
199 END po_currency_sv;