[Home] [Help]
PACKAGE: APPS.CE_FORECASTS_PKG
Source
1 PACKAGE CE_FORECASTS_PKG AUTHID CURRENT_USER AS
2 /* $Header: cefcasts.pls 120.1 2002/11/12 21:34:45 bhchung ship $ */
3
4 G_factor NUMBER DEFAULT 1;
5 G_spec_revision VARCHAR2(1000) := '$Revision: 120.1 $';
6
7 FUNCTION spec_revision RETURN VARCHAR2;
8
9 FUNCTION body_revision RETURN VARCHAR2;
10
11 PROCEDURE set_factor(X_factor NUMBER);
12
13 FUNCTION get_factor RETURN NUMBER;
14 PRAGMA RESTRICT_REFERENCES(get_factor, WNDS, WNPS);
15
16 PROCEDURE create_empty_forecast(X_rowid IN OUT NOCOPY VARCHAR2,
17 X_forecast_id IN OUT NOCOPY NUMBER,
18 X_forecast_header_id NUMBER,
19 X_forecast_name VARCHAR2,
20 X_forecast_dsp VARCHAR2,
21 X_start_date DATE,
22 X_period_set_name VARCHAR2,
23 X_start_period VARCHAR2,
24 X_forecast_currency VARCHAR2,
25 X_currency_type VARCHAR2,
26 X_source_currency VARCHAR2,
27 X_exchange_rate_type VARCHAR2,
28 X_exchange_date DATE,
29 X_exchange_rate NUMBER,
30 X_amount_threshold NUMBER,
31 X_project_id NUMBER,
32 X_created_by NUMBER,
33 X_creation_date DATE,
34 X_last_updated_by NUMBER,
35 X_last_update_date DATE,
36 X_last_update_login NUMBER);
37
38 PROCEDURE add_column( X_new_forecast VARCHAR2,
39 X_forecast_column_id IN OUT NOCOPY NUMBER,
40 X_forecast_header_id IN OUT NOCOPY NUMBER,
41 X_column_number NUMBER,
42 X_days_from NUMBER,
43 X_days_to NUMBER,
44 X_created_by NUMBER,
45 X_creation_date DATE,
46 X_last_updated_by NUMBER,
47 X_last_update_date DATE,
48 X_last_update_login NUMBER,
49 X_forecast_id NUMBER DEFAULT NULL,
50 X_name VARCHAR2 DEFAULT NULL);
51
52 PROCEDURE add_row( X_new_forecast VARCHAR2,
53 X_forecast_row_id IN OUT NOCOPY NUMBER,
54 X_forecast_header_id IN OUT NOCOPY NUMBER,
55 X_row_number NUMBER,
56 X_trx_type VARCHAR2,
57 X_created_by NUMBER,
58 X_creation_date DATE,
59 X_last_updated_by NUMBER,
60 X_last_update_date DATE,
61 X_last_update_login NUMBER,
62 X_forecast_id NUMBER DEFAULT NULL,
63 X_name VARCHAR2 DEFAULT NULL,
64 X_description VARCHAR2 DEFAULT NULL);
65
66 PROCEDURE fill_cells( X_header_id NUMBER,
67 X_col_or_row VARCHAR2, -- 'ROW'/'COLUMN'
68 X_new_id NUMBER, -- the id of the new column/row
69 X_created_by NUMBER,
70 X_creation_date DATE,
71 X_last_updated_by NUMBER,
72 X_last_update_date DATE,
73 X_last_update_login NUMBER);
74
75 PROCEDURE rearrange_column_number( X_forecast_header_id NUMBER );
76
77 PROCEDURE duplicate_template_header(
78 X_forecast_header_id IN OUT NOCOPY NUMBER,
79 X_created_by NUMBER,
80 X_creation_date DATE,
81 X_last_updated_by NUMBER,
82 X_last_update_date DATE,
83 X_last_update_login NUMBER,
84 X_forecast_id NUMBER,
85 X_name VARCHAR2);
86
87 PROCEDURE recalc_glc(X_hid IN NUMBER);
88 END CE_FORECASTS_PKG;