[Home] [Help]
PACKAGE: APPS.OZF_ACTFORECAST_PVT
Source
1 PACKAGE OZF_ACTFORECAST_PVT AUTHID CURRENT_USER AS
2 /* $Header: ozfvfcts.pls 120.2 2005/07/29 02:54:17 appldev ship $ */
3
4 --
5 -- Start of comments.
6 --
7 -- NAME
8 -- Ozf_ActForecast_Pvt
9 --
10 -- PURPOSE
11 -- This package is a private package used for defining constants, records,
12 -- types and procedures for activity forecasts API.
13 --
14 -- Procedures:
15 -- Create_ActForecast
16 -- Update_ActForecast
17 -- Lock_ActForecast
18 -- Delete_ActForecast
19 -- Validate_ActForecast
20 --
21 -- NOTES
22 --
23 --
24 -- HISTORY
25 -- 18/Apr/2000 tdonohoe Created.
26 -- 15/Jun/2000 tdonohoe Modified added column FORECAST_TYPE.
27 -- 25/APR/2002 kvattiku Added column PRICE_LIST_ID
28 -- 11/JUL/2005 inanaiah R12 changes for non-baseline basis
29 --
30 -- Start AMS_ACT_FORECASTS_ALL
31 --
32
33 TYPE act_forecast_rec_type
34 IS RECORD ( forecast_id number
35 ,forecast_type varchar2(30)
36 ,arc_act_fcast_used_by varchar2(30)
37 ,act_fcast_used_by_id number
38 ,creation_date date
39 ,created_from varchar2(30)
40 ,created_by number
41 ,last_update_date date
42 ,last_updated_by number
43 ,last_update_login number
44 ,program_application_id number
45 ,program_id number
46 ,program_update_date date
47 ,request_id number
48 ,object_version_number number
49 ,hierarchy varchar2(30)
50 ,hierarchy_level varchar2(30)
51 ,level_value varchar2(240)
52 ,forecast_calendar varchar2(30)
53 ,period_level varchar2(30)
54 ,forecast_period_id number
55 ,forecast_date date
56 ,forecast_uom_code varchar2(3)
57 ,forecast_quantity number
58 ,forward_buy_quantity number
59 ,forward_buy_period varchar2(20)
60 ,cumulation_period_choice varchar2(30)
61 ,base_quantity number
62 ,context varchar2(30)
63 ,attribute_category varchar2(30)
64 ,attribute1 varchar2(150)
65 ,attribute2 varchar2(150)
66 ,attribute3 varchar2(150)
67 ,attribute4 varchar2(150)
68 ,attribute5 varchar2(150)
69 ,attribute6 varchar2(150)
70 ,attribute7 varchar2(150)
71 ,attribute8 varchar2(150)
72 ,attribute9 varchar2(150)
73 ,attribute10 varchar2(150)
74 ,attribute11 varchar2(150)
75 ,attribute12 varchar2(150)
76 ,attribute13 varchar2(150)
77 ,attribute14 varchar2(150)
78 ,attribute15 varchar2(150)
79 ,org_id number
80 ,forecast_remaining_quantity number
81 ,forecast_remaining_percent number
82 ,base_quantity_type varchar2(30)
83 ,forecast_spread_type varchar2(30)
84 ,dimention1 varchar2(30)
85 ,dimention2 varchar2(30)
86 ,dimention3 varchar2(30)
87 ,last_scenario_id number
88 ,freeze_flag varchar2(1)
89 ,comments varchar2(2000)
90 ,price_list_id number
91 ,base_quantity_ref varchar2(30)
92 ,base_quantity_start_date date
93 ,base_quantity_end_date date
94 ,offer_code varchar2(30)
95 );
96 --
97 -- End AMS_ACT_FORECASTS_ALL
98 --
99 --
100 -- End of comments.
101
102
103 -- Start of comments
104 -- API Name Create_ActForecast
105 -- Type Private
106 -- Pre-reqs None.
107 -- Function Creates an Activity Forecast.
108 -- Parameters
109 -- IN p_api_version IN NUMBER Required
110 -- p_init_msg_list IN VARCHAR2 Optional
111 -- Default := FND_API.G_FALSE
112 -- p_commit IN VARCHAR2 Optional
113 -- Default := FND_API.G_FALSE
114 -- p_validation_level IN NUMBER Optional
115 -- Default := FND_API.G_VALID_LEVEL_FULL
116 -- p_act_forecast_rec IN act_forecast_rec_type Required
117 -- OUT NOCOPY x_return_status OUT NOCOPY VARCHAR2
118 -- x_msg_count OUT NOCOPY NUMBER
119 -- x_msg_data OUT NOCOPY VARCHAR2
120 -- Version Current version: 1.0
121 -- Previous version: 1.0
122 -- Initial version: 1.0
123 -- End of comments
124
125
126 PROCEDURE Create_ActForecast (
127 p_api_version IN NUMBER,
128 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
129 p_commit IN VARCHAR2 := FND_API.G_FALSE,
130 p_validation_level IN NUMBER := FND_API.G_Valid_Level_Full,
131
132 x_return_status OUT NOCOPY VARCHAR2,
133 x_msg_count OUT NOCOPY NUMBER,
134 x_msg_data OUT NOCOPY VARCHAR2,
135
136 p_act_forecast_rec IN act_forecast_rec_type,
137 x_forecast_id OUT NOCOPY NUMBER
138 );
139
140
141
142 -- Start of comments
143 -- API Name Update_ActForecast
144 -- Type Private
145 -- Pre-reqs None.
146 -- Function Updates the activity forecast.
147 -- Parameters
148 -- IN p_api_version IN NUMBER Required
149 -- p_init_msg_list IN VARCHAR2 Optional
150 -- Default := FND_API.G_FALSE
151 -- p_commit IN VARCHAR2 Optional
152 -- Default := FND_API.G_FALSE
153 -- p_validation_level IN NUMBER Optional
154 -- Default := FND_API.G_VALID_LEVEL_FULL
155 -- p_act_forecast_rec IN act_forecast_rec_type Required
156 -- OUT NOCOPY x_return_status OUT NOCOPY VARCHAR2
157 -- x_msg_count OUT NOCOPY NUMBER
158 -- x_msg_data OUT NOCOPY VARCHAR2
159 -- Version Current version: 1.0
160 -- Previous version: 1.0
161 -- Initial version: 1.0
162 -- End of comments
163
164 PROCEDURE Update_ActForecast (
165 p_api_version IN NUMBER,
166 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
167 p_commit IN VARCHAR2 := FND_API.G_FALSE,
168 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
169
170 x_return_status OUT NOCOPY VARCHAR2,
171 x_msg_count OUT NOCOPY NUMBER,
172 x_msg_data OUT NOCOPY VARCHAR2,
173
174 p_act_forecast_rec IN act_forecast_rec_type
175 );
176
177
178 -- Start of comments
179 -- API Name Delete_ActForecast
180 -- Type Private
181 -- Pre-reqs None.
182 -- Function Deletes the Activity Forecast.
183 -- Parameters
184 -- IN p_api_version IN NUMBER Required
185 -- p_init_msg_list IN VARCHAR2 Optional
186 -- Default := FND_API.G_FALSE
187 -- p_commit IN VARCHAR2 Optional
188 -- Default := FND_API.G_FALSE
189 -- p_forecast_id IN NUMBER Required
190 -- p_object_version_number IN NUMBER
191 -- OUT NOCOPY x_return_status OUT NOCOPY VARCHAR2
192 -- x_msg_count OUT NOCOPY NUMBER
193 -- x_msg_data OUT NOCOPY VARCHAR2
194 -- Version Current version: 1.0
195 -- Previous version: 1.0
196 -- Initial version: 1.0
197 -- End of comments
198
199 PROCEDURE Delete_ActForecast (
200 p_api_version IN NUMBER,
201 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
202 p_commit IN VARCHAR2 := FND_API.G_FALSE,
203
204 x_return_status OUT NOCOPY VARCHAR2,
205 x_msg_count OUT NOCOPY NUMBER,
206 x_msg_data OUT NOCOPY VARCHAR2,
207
208 p_forecast_id IN NUMBER ,
209 p_object_version_number IN NUMBER
210 );
211
212
213
214 -- Start of comments
215 -- API Name Lock_ActForecast
216 -- Type Private
217 -- Pre-reqs None.
218 -- Function Lock the given row in AMS_ACT_FORECASTS_ALL.
219 -- Parameters
220 -- IN p_api_version IN NUMBER Required
221 -- p_init_msg_list IN VARCHAR2 Optional
222 -- Default := FND_API.G_FALSE
223 -- p_commit IN VARCHAR2 Optional
224 -- Default := FND_API.G_FALSE
225 -- p_forecast_id IN NUMBER Required
226 -- p_object_version_number IN NUMBER Required
227 -- OUT NOCOPY x_return_status OUT NOCOPY VARCHAR2
228 -- x_msg_count OUT NOCOPY NUMBER
229 -- x_msg_data OUT NOCOPY VARCHAR2
230 -- Version Current version: 1.0
231 -- Previous version: 1.0
232 -- Initial version: 1.0
233 -- End of comments
234
235
236 PROCEDURE Lock_ActForecast (
237 p_api_version IN NUMBER,
238 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
239
240 x_return_status OUT NOCOPY VARCHAR2,
241 x_msg_count OUT NOCOPY NUMBER,
242 x_msg_data OUT NOCOPY VARCHAR2,
243
244 p_forecast_id IN NUMBER,
245 p_object_version_number IN NUMBER
246 );
247
248
249
250 -- Start of comments
251 -- API Name Validate_ActForecast
252 -- Type Private
253 -- Pre-reqs None.
254 -- Function Validate items in activity forecast table.
255
256 -- Parameters
257 -- IN p_api_version IN NUMBER Required
258 -- p_init_msg_list IN VARCHAR2 Optional
259 -- Default := FND_API.G_FALSE
260 -- p_commit IN VARCHAR2 Optional
261 -- Default := FND_API.G_FALSE
262 -- p_validation_level IN NUMBER Optional
263 -- Default := FND_API.G_VALID_LEVEL_FULL
264 -- p_act_forecast_rec IN act_forecast_rec_type Required
265 -- OUT NOCOPY x_return_status OUT NOCOPY VARCHAR2
266 -- x_msg_count OUT NOCOPY NUMBER
267 -- x_msg_data OUT NOCOPY VARCHAR2
268 -- Version Current version: 1.0
269 -- Previous version: 1.0
270 -- Initial version: 1.0
271 -- End of comments
272
273
274 PROCEDURE Validate_ActForecast (
275 p_api_version IN NUMBER,
276 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
277 p_validation_level IN NUMBER := FND_API.G_Valid_Level_Full,
278
279 x_return_status OUT NOCOPY VARCHAR2,
280 x_msg_count OUT NOCOPY NUMBER,
281 x_msg_data OUT NOCOPY VARCHAR2,
282
283 p_act_forecast_rec IN act_forecast_rec_type
284 );
285
286
287 -- Start of comments
288 -- API Name Validate_ActFcst_Items
289 -- Type Private
290 -- Pre-reqs None.
291 -- Function Validate Activity Forecast Items
292 -- Parameters
293 -- IN p_act_forecast_rec IN act_forecast_rec_type Required
294 -- p_validate_mode IN VARCHAR2
295 -- OUT NOCOPY x_return_status OUT NOCOPY VARCHAR2
296 -- Version Current version: 1.0
297 -- Previous version: 1.0
298 -- Initial version: 1.0
299 -- End of comments
300
301 PROCEDURE Validate_ActFcst_items(
302 p_act_forecast_rec IN act_forecast_rec_type,
303 p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
304 x_return_status OUT NOCOPY VARCHAR2
305 ) ;
306
307
308 -- Start of comments
309 -- API Name Validate_ActFcst_Rec
310 -- Type Private
311 -- Pre-reqs None.
312 -- Function Validate Activity Forecast Records
313 -- Parameters
314 -- IN p_act_forecast_rec IN act_forecast_rec_type Required
315 -- p_complete_fcst_rec IN act_forecast_rec_type Required
319 -- Initial version: 1.0
316 -- OUT NOCOPY x_return_status OUT NOCOPY VARCHAR2
317 -- Version Current version: 1.0
318 -- Previous version: 1.0
320 -- End of comments
321
322 PROCEDURE Validate_ActFcst_rec(
323 p_act_forecast_rec IN act_forecast_rec_type,
324 p_complete_fcst_rec IN act_forecast_rec_type,
325 x_return_status OUT NOCOPY VARCHAR2
326 ) ;
327
328
329 -- Start of comments
330 -- API Name Complete_ActFcst_Rec
331 -- Type Private
332 -- Pre-reqs None.
333 -- Function This Process returns the details for the Activity Metric Fact
334 --
335 -- Parameters
336 -- IN p_act_forecast_rec IN act_forecast_rec_type Required
337 -- OUT NOCOPY x_complete_fcst_rec OUT NOCOPY act_forecast_rec_type
338 -- Version Current version: 1.0
339 -- Previous version: 1.0
340 -- Initial version: 1.0
341 -- End of comments
342
343 PROCEDURE Complete_ActFcst_Rec(
344 p_act_forecast_rec IN act_forecast_rec_type,
345 x_complete_fcst_rec OUT NOCOPY act_forecast_rec_type
346 );
347
348 PROCEDURE Init_ActForecast_Rec(
349 x_actforecast_rec OUT NOCOPY act_forecast_rec_type
350 );
351
352 END Ozf_ActForecast_Pvt;