[Home] [Help]
PACKAGE: APPS.CE_FORECAST_HEADERS_PKG
Source
1 PACKAGE CE_FORECAST_HEADERS_PKG AS
2 /* $Header: cefhdrs.pls 120.1 2002/11/12 21:23:52 bhchung ship $ */
3 --
4 -- Package
5 -- CE_FORECAST_HEADERS_PKG
6 -- Purpose
7 -- To group all the procedures/functions for table handling of the
8 -- ce_forecast_headers table.
9 -- History
10 -- 07.10.96 C. Kawamoto Created
11 --
12
13 G_spec_revision VARCHAR2(1000) := '$Revision: 120.1 $';
14
15 FUNCTION spec_revision RETURN VARCHAR2;
16
17 FUNCTION body_revision RETURN VARCHAR2;
18
19 --
20 -- Procedure
21 -- Check_Unique
22 -- Purpose
23 -- Checks the uniqueness of the forecast inserted.
24 -- History
25 -- 07.10.96 C. Kawamoto Created
26 -- Example
27 -- CE_FORECAST_HEADERS_PKG.Check_Unique(...);
28 -- Notes
29 --
30 PROCEDURE Check_Unique(
31 X_rowid VARCHAR2,
32 X_name VARCHAR2);
33
34 --
35 -- Procedure
36 -- insert_row
37 -- Purpose
38 -- To insert new row to ce_forecast_headers.
39 -- History
40 -- 07.10.96 C. Kawamoto Created
41 -- Example
42 -- CE_FORECAST_HEADERS_PKG.Insert_Row(...)
43 -- Notes
44 --
45
46 PROCEDURE Insert_Row(
47 X_rowid IN OUT NOCOPY VARCHAR2,
48 X_forecast_header_id IN OUT NOCOPY NUMBER,
49 X_name VARCHAR2,
50 X_description VARCHAR2,
51 X_aging_type VARCHAR2,
52 X_overdue_transactions VARCHAR2,
53 X_cutoff_period NUMBER,
54 X_transaction_calendar_id NUMBER,
55 X_start_project_id NUMBER,
56 X_end_project_id NUMBER,
57 X_treasury_template VARCHAR2,
58 X_created_by NUMBER,
59 X_creation_date DATE,
60 X_last_updated_by NUMBER,
61 X_last_update_date DATE,
62 X_last_update_login NUMBER,
63 X_attribute_category VARCHAR2,
64 X_attribute1 VARCHAR2,
65 X_attribute2 VARCHAR2,
66 X_attribute3 VARCHAR2,
67 X_attribute4 VARCHAR2,
68 X_attribute5 VARCHAR2,
69 X_attribute6 VARCHAR2,
70 X_attribute7 VARCHAR2,
71 X_attribute8 VARCHAR2,
72 X_attribute9 VARCHAR2,
73 X_attribute10 VARCHAR2,
74 X_attribute11 VARCHAR2,
75 X_attribute12 VARCHAR2,
76 X_attribute13 VARCHAR2,
77 X_attribute14 VARCHAR2,
78 X_attribute15 VARCHAR2);
79
80 --
81 -- Procedure
82 -- lock_row
83 -- Purpose
84 -- To lock a row from ce_forecast_headers.
85 -- History
86 -- 07.10.96 C. Kawamoto Created
87 -- Example
88 -- CE_FORECAST_HEADERS_PKG.Lock_Row(...)
89 -- Notes
90 --
91
92
93 PROCEDURE Lock_Row(
94 X_rowid VARCHAR2,
95 X_forecast_header_id NUMBER,
96 X_name VARCHAR2,
97 X_description VARCHAR2,
98 X_aging_type VARCHAR2,
99 X_overdue_transactions VARCHAR2,
100 X_cutoff_period NUMBER,
101 X_transaction_calendar_id NUMBER,
102 X_start_project_id NUMBER,
103 X_end_project_id NUMBER,
104 X_created_by NUMBER,
105 X_creation_date DATE,
106 X_last_updated_by NUMBER,
107 X_last_update_date DATE,
108 X_last_update_login NUMBER,
109 X_attribute_category VARCHAR2,
110 X_attribute1 VARCHAR2,
111 X_attribute2 VARCHAR2,
112 X_attribute3 VARCHAR2,
113 X_attribute4 VARCHAR2,
114 X_attribute5 VARCHAR2,
115 X_attribute6 VARCHAR2,
116 X_attribute7 VARCHAR2,
117 X_attribute8 VARCHAR2,
118 X_attribute9 VARCHAR2,
119 X_attribute10 VARCHAR2,
120 X_attribute11 VARCHAR2,
121 X_attribute12 VARCHAR2,
122 X_attribute13 VARCHAR2,
123 X_attribute14 VARCHAR2,
124 X_attribute15 VARCHAR2);
125
126 --
127 -- Procedure
128 -- Update_Row
129 -- Purpose
130 -- To update ce_forecast_headers with changes made.
131 -- History
132 -- 07.10.96 C. Kawamoto Created
133 -- Example
134 -- CE_FORECAST_HEADERS_PKG.Update_Row(...)
135 -- Notes
136 --
137 PROCEDURE Update_Row(
138 X_rowid VARCHAR2,
139 X_forecast_header_id NUMBER,
140 X_name VARCHAR2,
141 X_description VARCHAR2,
142 X_aging_type VARCHAR2,
143 X_overdue_transactions VARCHAR2,
144 X_cutoff_period NUMBER,
145 X_transaction_calendar_id NUMBER,
146 X_start_project_id NUMBER,
147 X_end_project_id NUMBER,
148 X_created_by NUMBER,
149 X_creation_date DATE,
150 X_last_updated_by NUMBER,
151 X_last_update_date DATE,
152 X_last_update_login NUMBER,
153 X_attribute_category VARCHAR2,
154 X_attribute1 VARCHAR2,
155 X_attribute2 VARCHAR2,
156 X_attribute3 VARCHAR2,
157 X_attribute4 VARCHAR2,
158 X_attribute5 VARCHAR2,
159 X_attribute6 VARCHAR2,
160 X_attribute7 VARCHAR2,
161 X_attribute8 VARCHAR2,
162 X_attribute9 VARCHAR2,
163 X_attribute10 VARCHAR2,
164 X_attribute11 VARCHAR2,
165 X_attribute12 VARCHAR2,
166 X_attribute13 VARCHAR2,
167 X_attribute14 VARCHAR2,
168 X_attribute15 VARCHAR2);
169
170 --
171 -- Procedure
172 -- Delete_Row
173 -- Purpose
174 -- To delete a row from ce_forecast_headers.
175 -- History
176 -- 07.10.96 C. Kawamoto Created
177 -- Example
178 -- CE_FORECAST_HEADERS_PKG.Delete_Row(...)
179 -- Notes
180 --
181 PROCEDURE Delete_Row(X_rowid VARCHAR2);
182
183 --
184 -- Procedure
185 -- Delete_Forecasts
186 -- Purpose
187 -- To delete all forecasts and cells belonging the forecast template
188 -- History
189 -- 07.10.96 C. Kawamoto Created
190 -- Example
191 -- CE_FORECAST_HEADERS_PKG.Delete_Forecasts(...)
192 -- Notes
193 --
194 PROCEDURE Delete_Forecasts(X_rowid VARCHAR2);
195
196 END CE_FORECAST_HEADERS_PKG;