[Home] [Help]
PACKAGE: APPS.GL_EXCH_RATES_SYNC_PKG
Source
1 PACKAGE GL_EXCH_RATES_SYNC_PKG AUTHID CURRENT_USER AS
2 /*$Header: glexrass.pls 120.0.12010000.2 2008/09/19 14:11:13 kmotepal noship $*/
3 /*==================================================================================+
4 | Copyright (c) 2001-2002 Oracle Corporation |
5 | Redwood Shores, CA, USA |
6 | All rights reserved. |
7 +===================================================================================+
8 | FILENAME |
9 | glexrass.pls |
10 | |
11 | PACKAGE NAME |
12 | GL_EXCH_RATES_SYNC_PKG |
13 | |
14 | DESCRIPTION |
15 | This is a GL Daily Rates Synchronization which is used to fetch GL Daily |
16 | Rates with in a gieven date range. |
17 | Also this Program used to fetch the Cross Rates for the entered Currencies. |
18 | |
19 | |
20 | Package specification for the Exchange Rates Synchronization Program. |
21 | |
22 | SUB PROGRAMS |
23 | ------------ |
24 | PROCEDURE get_cur_conv_rates |
25 | |
26 | PARAMETER DESCRIPTION |
27 | --------------------- |
28 | errbuf OUT NOCOPY Default out parameter to capture error message |
29 | retcode OUT NOCOPY Default out parameter to capture error code |
30 | p_from_currency IN from_currency from GL_DAILY_RATES table. |
31 | p_to_currency IN to_currency from GL_DAILY_RATES table. |
32 | p_from_date IN conversion_date from GL_DAILY_RATES table. |
33 | p_to_date IN conversion_date from GL_DAILY_RATES table. |
34 | p_conversion_rate_type IN conversion_type from GL_DAILY_RATES table. |
35 | p_cur_conv_rates OUT NOCOPY GL_CUR_CONV_RATE_OBJ_TBL Object type |
36 | |
37 | |
38 | HISTORY |
39 | 04-AUG-08 Vamshidhar G Created |
40 | |
41 +===================================================================================*/
42
43 PROCEDURE get_cur_conv_rates
44 (errbuf OUT NOCOPY VARCHAR2,
45 retcode OUT NOCOPY NUMBER,
46 p_from_currency IN VARCHAR2 DEFAULT NULL,
47 p_to_currency IN VARCHAR2 DEFAULT NULL,
48 p_from_date IN DATE,
49 p_to_date IN DATE DEFAULT SYSDATE,
50 p_conversion_rate_type IN VARCHAR2 DEFAULT NULL,
51 p_cur_conv_rates OUT NOCOPY GL_CUR_CONV_RATE_OBJ_TBL);
52
53 END GL_EXCH_RATES_SYNC_PKG;