PACKAGE: APPS.CE_FORECAST_REMOTE_SOURCES

Source

1 PACKAGE CE_FORECAST_REMOTE_SOURCES AS
2 /*  $Header: cefremts.pls 120.3 2003/12/05 19:09:57 sspoonen ship $ */
3 
4 TYPE AgingRec is record
5         ( column_id 	NUMBER,
6           start_date    DATE,
7           end_date      DATE);
8 
9 TYPE AgingTab is Table of AgingRec INDEX BY BINARY_INTEGER;
10 
11 TYPE ConversionRec IS RECORD
12   ( from_currency_code	VARCHAR2(30),
13     conversion_rate  	NUMBER);
14 
15 TYPE ConversionTab IS TABLE OF ConversionRec INDEX BY BINARY_INTEGER;
16 
17 TYPE AmountRec IS RECORD
18   ( currency_code	VARCHAR2(30),
19     trx_date		DATE,
20     bank_account_id	NUMBER,
21     forecast_amount	NUMBER,
22     trx_amount		NUMBER,
23     forecast_column_id	NUMBER);
24 
25 TYPE AmountTab is TABLE OF AmountRec INDEX BY BINARY_INTEGER;
26 
27 FUNCTION Populate_Remote_Amounts
28   ( forecast_id			NUMBER,
29     source_view			VARCHAR2,
30     db_link			VARCHAR2,
31     forecast_row_id		NUMBER,
32     aging_table			AgingTab,
33     conversion_table		ConversionTab,
34     rp_forecast_currency    	VARCHAR2,
35     rp_exchange_date        	DATE,
36     rp_exchange_type        	VARCHAR2,
37     rp_exchange_rate        	NUMBER,
38     rp_src_curr_type        	VARCHAR2,
39     rp_src_currency         	VARCHAR2,
40     rp_amount_threshold		NUMBER,
41     lead_time			NUMBER,
42     criteria1			VARCHAR2,
43     criteria2			VARCHAR2,
44     criteria3			VARCHAR2,
45     criteria4			VARCHAR2,
46     criteria5			VARCHAR2,
47     criteria6			VARCHAR2,
48     criteria7			VARCHAR2,
49     criteria8			VARCHAR2,
50     criteria9			VARCHAR2,
51     criteria10			VARCHAR2,
52     criteria11			VARCHAR2,
53     criteria12			VARCHAR2,
54     criteria13			VARCHAR2,
55     criteria14			VARCHAR2,
56     criteria15			VARCHAR2,
57     amount_table		IN OUT NOCOPY AmountTab) RETURN NUMBER;
58 
59 END CE_FORECAST_REMOTE_SOURCES;
60