DBA Data[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;