1 PACKAGE IEX_CURRENCY_PVT AUTHID CURRENT_USER AS
2 /* $Header: iexvcurs.pls 120.1 2005/05/31 14:16:15 lkkumar noship $ */
3 G_functional_CURRENCY fnd_currencies.currency_code%TYPE;
4 G_SET_OF_BOOKS_ID NUMBER(15);
5 G_PKG_NAME CONSTANT VARCHAR2(30) :='IEX_CURRENCY_PVT';
6 G_FILE_NAME CONSTANT VARCHAR2(12) :='iexvcurs.pls';
7
8 G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
9 G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
10 G_PROGRAM_ID NUMBER := FND_GLOBAL.Conc_Program_Id;
11 G_USER_ID NUMBER := FND_GLOBAL.User_Id;
12 G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
13
14 /*===========================================================================+
15 | PROCEDURE |
16 | Get_Currency_Details |
17 | |
18 | DESCRIPTION |
19 | Get Currency Details Information |
20 | |
21 | SCOPE - PRIVATE |
22 | |
23 | ARGUMENTS : IN: |
24 | p_currency_code : Currency Code |
25 | OUT: |
26 | x_precision : Precision |
27 | x_mau : Minimum Accountable Unit |
28 | IN/ OUT: |
29 | |
30 | RETURNS : NONE |
31 | |
32 | NOTES |
33 | |
34 | MODIFICATION HISTORY |
35 | jypark 23-NOV-99 Created |
36 | |
37 +===========================================================================*/
38 PROCEDURE Get_Currency_Details(
39 p_api_version IN NUMBER DEFAULT FND_API.G_MISS_NUM,
40 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
41 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
42 p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,
43 p_currency_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
44 x_precision OUT NOCOPY NUMBER,
45 x_mau OUT NOCOPY NUMBER,
46 x_return_status OUT NOCOPY VARCHAR2,
47 x_msg_count OUT NOCOPY NUMBER,
48 x_msg_data OUT NOCOPY VARCHAR2
49 );
50
51 /*===========================================================================+
52 | PROCEDURE |
53 | Get_Curr_Round_Amount |
54 | |
55 | DESCRIPTION |
56 | This PROCEDURE return Currency Rounded Amount |
57 | |
58 | |
59 | SCOPE - PRIVATE |
60 | |
61 | |
62 | ARGUMENTS : IN: |
63 | p_amount : Amount |
64 | p_currency_code : Currency Code |
65 | OUT: |
66 | x_rounded_amount : Rounded currency amount |
67 | IN/ OUT: |
68 | |
69 | NOTES |
70 | |
71 | MODIFICATION HISTORY |
72 | jypark 23-NOV-99 Created |
73 | |
74 +===========================================================================*/
75 PROCEDURE Get_Curr_Round_Amount (
76 p_api_version IN NUMBER DEFAULT FND_API.G_MISS_NUM,
77 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
78 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
79 p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,
80 p_amount IN NUMBER DEFAULT FND_API.G_MISS_NUM,
81 p_currency_code IN VARCHAR2 DEFAULT g_functional_currency,
82 x_rounded_amount OUT NOCOPY NUMBER,
83 x_return_status OUT NOCOPY VARCHAR2,
84 x_msg_count OUT NOCOPY NUMBER,
85 x_msg_data OUT NOCOPY VARCHAR2
86 );
87
88 /*===========================================================================+
89 | PROCEDURE |
90 | Get_Functional_Amount |
91 | |
92 | DESCRIPTION |
93 | This PROCEDURE returns the functional amount for a given foreign amount.|
94 | The functional amount is rounded to the correct precision. |
95 | |
96 | |
97 | SCOPE - PRIVATE |
98 | |
99 | ARGUMENTS : IN: |
100 | p_amount - the original foreign amount |
101 | p_exchange_rate - to use when converting to functional |
102 | amount |
103 | one of: |
104 | p_currency_code - of the functional amount |
105 | p_precision - of the functional amount |
106 | p_minimum_accountable_unit - of the functional amount |
107 | OUT: |
108 | x_functional_amount - |
109 | l_amount * l_exchange_rate to correct rounding |
110 | for currency |
111 | |
112 | IN/ OUT: |
113 | |
114 | NOTES |
115 | EXCEPTIONS RAISED |
116 | Oracle Error If Currency Code, Precision and minimum accountable |
117 | are all NULL |
118 | |
119 | Oracle Error If can not find information for Currency Code |
120 | supplied |
121 | |
122 | MODIFICATION HISTORY |
123 | jypark 23-NOV-99 Created |
124 | |
125 +===========================================================================*/
126 PROCEDURE Get_functional_Amount(
127 p_api_version IN NUMBER DEFAULT FND_API.G_MISS_NUM,
128 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
129 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
130 p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,
131 p_amount IN NUMBER DEFAULT FND_API.G_MISS_NUM,
132 p_currency_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
133 p_exchange_rate IN NUMBER DEFAULT FND_API.G_MISS_NUM,
134 p_precision IN NUMBER DEFAULT FND_API.G_MISS_NUM,
135 p_min_acc_unit IN NUMBER DEFAULT FND_API.G_MISS_NUM,
136 x_functional_amount OUT NOCOPY NUMBER,
137 x_return_status OUT NOCOPY VARCHAR2,
138 x_msg_count OUT NOCOPY NUMBER,
139 x_msg_data OUT NOCOPY VARCHAR2
140 );
141
142 /*===========================================================================+
143 | PROCEDURE |
144 | Get_Func_Amt_Rate |
145 | |
146 | DESCRIPTION |
147 | This PROCEDURE returns the functional amount for a given foreign amount.|
148 | The functional amount is rounded to the correct precision. |
149 | |
150 | |
151 | SCOPE - PRIVATE |
152 | |
153 | ARGUMENTS : IN: |
154 | p_amount_original - the original foreign amount |
155 | p_exchange_rate - to use when converting to functional |
156 | amount |
157 | OUT: |
158 | x_amount_functional - |
159 | l_amount * l_exchange_rate to correct rounding |
160 | for currency |
161 | |
162 | IN/ OUT: |
163 | NOTES |
164 | EXCEPTIONS RAISED |
165 | |
166 | MODIFICATION HISTORY |
167 | jypark 01-MAR-2000 Created |
168 | |
169 +===========================================================================*/
170
171 PROCEDURE Get_Func_Amt_Rate(
172 p_api_version IN NUMBER DEFAULT FND_API.G_MISS_NUM,
173 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
174 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
175 p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,
176 p_amount_original IN NUMBER DEFAULT FND_API.G_MISS_NUM,
177 p_exchange_rate IN NUMBER DEFAULT FND_API.G_MISS_NUM,
178 x_amount_functional OUT NOCOPY NUMBER,
179 x_return_status OUT NOCOPY VARCHAR2,
180 x_msg_count OUT NOCOPY NUMBER,
181 x_msg_data OUT NOCOPY VARCHAR2
182 );
183
184 /*===========================================================================+
185 | PROCEDURE |
186 | Get_Func_Amt_Curr |
187 | |
188 | DESCRIPTION |
189 | This PROCEDURE returns the functional amount for a given foreign amount |
190 | and foreign currency and exchange date. |
191 | The functional amount is rounded to the correct precision. |
192 | |
193 | |
194 | SCOPE - PRIVATE |
195 | |
196 | ARGUMENTS : IN: |
197 | p_amount_original - the original foreign amount |
198 | p_currency_original - of the functional amount |
199 | amount |
200 | p_exchange_date - to use when converting to functional |
201 | OUT: |
202 | x_amount_functional - |
203 | l_amount * l_exchange_rate to correct rounding |
204 | for currency |
205 | |
206 | IN/ OUT: |
207 | NOTES |
208 | EXCEPTIONS RAISED |
209 | |
210 | Oracle Error If can not find information for Currency Code |
211 | supplied |
212 | |
213 | MODIFICATION HISTORY |
214 | jypark 01-MAR-2000 Created |
215 | |
216 +===========================================================================*/
217
218 PROCEDURE Get_Func_Amt_Curr(
219 p_api_version IN NUMBER DEFAULT FND_API.G_MISS_NUM,
220 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
221 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
222 p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,
223 p_amount_original IN NUMBER DEFAULT FND_API.G_MISS_NUM,
224 p_currency_original IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
225 p_exchange_date IN DATE DEFAULT FND_API.G_MISS_DATE,
226 x_amount_functional OUT NOCOPY NUMBER,
227 x_return_status OUT NOCOPY VARCHAR2,
228 x_msg_count OUT NOCOPY NUMBER,
229 x_msg_data OUT NOCOPY VARCHAR2
230 );
231
232
233 /*===========================================================================+
234 | PROCEDURE |
235 | Get_Convert_Amount_Curr |
236 | |
237 | DESCRIPTION |
238 | This PROCEDURE takes from and to currencies, conversion date, |
239 | conversion type and amount and returns the amount converted into the |
240 | appropriate currency. |
241 | |
242 | |
243 | SCOPE - PRIVATE |
244 | |
245 | |
246 | ARGUMENTS : IN: |
247 | p_from_currency - From currency |
248 | p_to_currency - To currency |
249 | p_conversion_date - Conversion date |
250 | p_conversion_type - Conversion type |
251 | p_amount_original - the original foreign amount |
252 | OUT: |
253 | x_amount_converted - |
254 | the amount converted into the appropriate currency. |
255 | |
256 | IN/ OUT: |
257 | NOTES |
258 | |
259 | MODIFICATION HISTORY |
260 | jypark 23-NOV-99 Created |
261 | |
262 +===========================================================================*/
263 PROCEDURE Get_Convert_Amount_Curr(
264 p_api_version IN NUMBER DEFAULT FND_API.G_MISS_NUM,
265 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
266 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
267 p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,
268 p_from_currency IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
269 p_to_currency IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
270 p_conversion_date IN DATE DEFAULT FND_API.G_MISS_DATE,
271 p_conversion_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
272 p_amount_original IN NUMBER DEFAULT FND_API.G_MISS_NUM,
273 x_amount_converted OUT NOCOPY NUMBER,
274 x_return_status OUT NOCOPY VARCHAR2,
275 x_msg_count OUT NOCOPY NUMBER,
276 x_msg_data OUT NOCOPY VARCHAR2
277 );
278
279 /*===========================================================================+
280 | PROCEDURE |
281 | Get_Convert_Amount_Sob |
282 | |
283 | DESCRIPTION |
284 | This PROCEDURE takes from and to currencies, conversion date, |
285 | conversion type and amount and returns the amount converted into the |
286 | appropriate currency. |
287 | |
288 | |
289 | |
290 | |
291 | SCOPE - PRIVATE |
292 | |
293 | |
294 | ARGUMENTS : IN: |
295 | p_set_of_books_id - Set of books id |
296 | p_from_currency - From currency |
297 | p_conversion_date - Conversion date |
298 | p_conversion_type - Conversion type |
299 | p_amount - the original foreign amount |
300 | OUT: |
301 | x_amount_converted - |
302 | the amount converted into the appropriate currency. |
303 | |
304 | IN/ OUT: |
305 | |
306 | NOTES |
307 | |
308 | MODIFICATION HISTORY |
309 | jypark 23-NOV-99 Created |
310 | |
311 +===========================================================================*/
312 PROCEDURE get_convert_amount_sob(
313 p_api_version IN NUMBER DEFAULT FND_API.G_MISS_NUM,
314 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
315 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
316 p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,
317 p_set_of_books_id IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
318 p_from_currency IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
319 p_conversion_date IN DATE DEFAULT FND_API.G_MISS_DATE,
320 p_conversion_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
321 p_amount_original IN NUMBER DEFAULT FND_API.G_MISS_NUM,
322 x_amount_converted OUT NOCOPY NUMBER,
323 x_return_status OUT NOCOPY VARCHAR2,
324 x_msg_count OUT NOCOPY NUMBER,
325 x_msg_data OUT NOCOPY VARCHAR2
326 );
327
328 /*===========================================================================+
329 | PROCEDURE |
333 | This PROCEDURE return functional currency of set of books |
330 | Get_Funct_Curr |
331 | |
332 | DESCRIPTION |
334 | |
335 | |
336 | |
337 | |
338 | SCOPE - PRIVATE |
339 | |
340 | |
341 | ARGUMENTS : IN: |
342 | |
343 | OUT: |
344 | x_functional_currency - Functional currency |
345 | IN/ OUT: |
346 | |
347 | NOTES |
348 | |
349 | MODIFICATION HISTORY |
350 | jypark 23-NOV-99 Created |
351 | |
352 +===========================================================================*/
353 PROCEDURE Get_Funct_Curr(
354 p_api_version IN NUMBER DEFAULT FND_API.G_MISS_NUM,
355 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
356 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
357 p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,
358 x_functional_currency OUT NOCOPY VARCHAR2,
359 x_return_status OUT NOCOPY VARCHAR2,
360 x_msg_count OUT NOCOPY NUMBER,
361 x_msg_data OUT NOCOPY VARCHAR2
362 );
363 /*===========================================================================+
364 | PROCEDURE |
365 | Get_Format_Mask |
366 | |
367 | DESCRIPTION |
368 | This Procedure returns Format Mask For Currency |
369 | |
370 | SCOPE - PRIVATE |
371 | |
372 | ARGUMENTS : IN: |
373 | p_currency_code : Currency Code |
374 | p_field_length : Field Length |
375 | OUT: |
376 | x_format mask : Format Mask |
377 | |
378 | NOTES |
379 | |
380 | MODIFICATION HISTORY |
381 | jypark 23-NOV-99 Created |
382 | |
383 +===========================================================================*/
384 PROCEDURE Get_Format_Mask(
385 p_api_version IN NUMBER DEFAULT FND_API.G_MISS_NUM,
386 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
387 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
388 p_validation_level IN NUMBER DEFAULT FND_API.G_MISS_NUM,
389 p_currency_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
390 p_field_length IN NUMBER DEFAULT FND_API.G_MISS_NUM,
391 x_format_mask OUT NOCOPY VARCHAR2,
392 x_return_status OUT NOCOPY VARCHAR2,
393 x_msg_count OUT NOCOPY NUMBER,
394 x_msg_data OUT NOCOPY VARCHAR2
395 );
396 /*===========================================================================+
397 | PROCEDURE |
398 | Get_Currency_Count |
399 | |
400 | DESCRIPTION |
401 | This Procedure returns count of functional currency to |
402 which the mo profile has access. |
403 | |
404 | SCOPE - PRIVATE |
405 | |
406 | ARGUMENTS : IN: |
407 | NULL |
408 | RETURN : |
409 | Number |
410 | |
411 | NOTES |
412 | |
413 | MODIFICATION HISTORY |
414 | lkkumar 31-May-2005 Created |
415 | |
416 +===========================================================================*/
417 FUNCTION Get_Currency_Count Return Number;
418
419 END IEX_CURRENCY_PVT;
|
|
|