[Home] [Help]
PACKAGE: APPS.GMF_GLCOMMON_DB
Source
1 PACKAGE GMF_GLCOMMON_DB AUTHID CURRENT_USER AS
2 /* $Header: gmfglcos.pls 115.1 2002/11/11 00:38:06 rseshadr ship $ */
3 PROCEDURE proc_get_closest_rate(
4 x_from_currency_code VARCHAR2,
5 x_to_currency_code VARCHAR2,
6 x_exchange_rate_date DATE,
7 x_rate_type_code VARCHAR2 DEFAULT NULL,
8 x_exchange_rate OUT NOCOPY NUMBER,
9 x_mul_div_sign OUT NOCOPY NUMBER,
10 error_status IN OUT NOCOPY NUMBER);
11
12 PROCEDURE proc_is_fixed_rate(
13 x_from_currency VARCHAR2,
14 x_to_currency VARCHAR2,
15 x_effective_date DATE ,
16 x_fixed_check OUT NOCOPY VARCHAR2,
17 error_status IN OUT NOCOPY NUMBER);
18
19 FUNCTION get_closest_rate (
20 x_from_currency_code VARCHAR2,
21 x_to_currency_code VARCHAR2,
22 x_exchange_rate_date DATE,
23 x_rate_type_code VARCHAR2 DEFAULT NULL,
24 x_mul_div_sign OUT NOCOPY NUMBER,
25 error_status IN OUT NOCOPY NUMBER) RETURN NUMBER;
26
27 PROCEDURE get_info(
28 x_currency VARCHAR2,
29 x_eff_date DATE,
30 x_exchange_rate IN OUT NOCOPY NUMBER,
31 x_mau IN OUT NOCOPY NUMBER,
32 x_currency_type IN OUT NOCOPY VARCHAR2,
33 error_status IN OUT NOCOPY NUMBER );
34
35 FUNCTION is_fixed_rate (
36 x_from_currency VARCHAR2,
37 x_to_currency VARCHAR2,
38 x_effective_date DATE ,
39 error_status IN OUT NOCOPY NUMBER) RETURN VARCHAR2;
40
41 NO_RATE EXCEPTION;
42 INVALID_CURRENCY EXCEPTION;
43 END GMF_GLCOMMON_DB;