[Home] [Help]
PACKAGE: APPS.OZF_FORECAST_UTIL_PVT
Source
1 PACKAGE OZF_FORECAST_UTIL_PVT AUTHID CURRENT_USER AS
2 /* $Header: ozfvfous.pls 120.0 2005/11/04 18:48:05 mkothari noship $*/
3
4 TYPE fcst_return_rec_type
5 IS RECORD ( forecast_id NUMBER,
6 spread_count NUMBER
7 );
8
9 FUNCTION get_product_list_price(p_activity_metric_fact_id IN NUMBER) RETURN NUMBER;
10
11 FUNCTION get_product_cost(p_activity_metric_fact_id IN NUMBER) RETURN NUMBER;
12
13 FUNCTION get_best_fit_lift (
14 p_obj_type IN VARCHAR2,
15 p_obj_id IN NUMBER,
16 p_forecast_id IN NUMBER,
17 p_base_quantity_ref IN VARCHAR2,
18 p_market_type IN VARCHAR2,
19 p_market_id IN NUMBER,
20 p_product_attribute_context IN VARCHAR2,
21 p_product_attribute IN VARCHAR2,
22 p_product_attr_value IN VARCHAR2,
23 p_product_id IN NUMBER,
24 p_tpr_percent IN NUMBER,
25 p_report_date IN DATE
26 )
27 RETURN NUMBER;
28
29 PROCEDURE adjust_baseline_spreads
30 (
31 p_api_version IN NUMBER,
32 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
33 p_commit IN VARCHAR2 := FND_API.g_false,
34 p_obj_type IN VARCHAR2,
35 p_obj_id IN NUMBER,
36 p_forecast_id IN NUMBER,
37 p_activity_metric_fact_id IN NUMBER,
38 p_new_tpr_percent IN NUMBER,
39 p_new_incremental_sales OUT NOCOPY NUMBER,
40 x_return_status OUT NOCOPY VARCHAR2,
41 x_msg_count OUT NOCOPY NUMBER,
42 x_msg_data OUT NOCOPY VARCHAR2
43 );
44
45 PROCEDURE create_forecast(
46 p_api_version IN NUMBER,
47 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
48 p_commit IN VARCHAR2 := FND_API.g_false,
49
50 p_obj_type IN VARCHAR2,
51 p_obj_id IN NUMBER,
52 p_fcst_uom IN VARCHAR2,
53 p_start_date IN DATE,
54 p_end_date IN DATE,
55 p_base_quantity_type IN VARCHAR2,
56 p_base_quantity_ref IN VARCHAR2,
57 p_last_scenario_id IN NUMBER,
58 p_offer_code IN VARCHAR2,
59
60 x_forecast_id IN OUT NOCOPY NUMBER,
61 x_activity_metric_id OUT NOCOPY NUMBER, -- 11510
62 x_return_status OUT NOCOPY VARCHAR2,
63 x_msg_count OUT NOCOPY NUMBER,
64 x_msg_data OUT NOCOPY VARCHAR2
65 );
66
67
68 PROCEDURE create_wkst_forecasts(
69 p_api_version IN NUMBER,
70 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
71 p_commit IN VARCHAR2 := FND_API.g_false,
72
73 p_worksheet_header_id IN NUMBER,
74
75 x_return_status OUT NOCOPY VARCHAR2,
76 x_msg_count OUT NOCOPY NUMBER,
77 x_msg_data OUT NOCOPY VARCHAR2 ) ;
78
79 PROCEDURE create_base_sales(
80 p_api_version IN NUMBER,
81 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
82 p_commit IN VARCHAR2 := FND_API.g_false,
83
84 p_obj_type IN VARCHAR2,
85 p_obj_id IN NUMBER,
86 p_forecast_id IN NUMBER,
87 p_activity_metric_id IN NUMBER,
88 p_level IN VARCHAR2,
89 p_dimention IN VARCHAR2,
90 p_fcst_uom IN VARCHAR2,
91 p_start_date IN DATE,
92 p_end_date IN DATE,
93 p_period_level IN VARCHAR2,
94 --R12
95 p_base_quantity_type IN VARCHAR2,
96 p_base_quantity_ref IN VARCHAR2,
97 p_last_forecast_id IN NUMBER,
98 p_base_quantity_start_date IN DATE,
99 p_base_quantity_end_date IN DATE,
100 p_offer_code IN VARCHAR2,
101
102 x_fcst_return_rec OUT NOCOPY fcst_return_rec_type,
103 x_return_status OUT NOCOPY VARCHAR2,
104 x_msg_count OUT NOCOPY NUMBER,
105 x_msg_data OUT NOCOPY VARCHAR2
106 );
107
108 PROCEDURE fcst_remqty(
109 p_api_version IN NUMBER,
110 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
111 p_commit IN VARCHAR2 := FND_API.g_false,
112
113 p_forecast_id IN NUMBER,
114
115 x_return_status OUT NOCOPY VARCHAR2,
116 x_msg_count OUT NOCOPY NUMBER,
117 x_msg_data OUT NOCOPY VARCHAR2
118 );
119
120
121 PROCEDURE freeze_check(
122 p_api_version IN NUMBER,
123 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
124 p_commit IN VARCHAR2 := FND_API.g_false,
125
126 p_forecast_id IN NUMBER,
127
128 x_return_status OUT NOCOPY VARCHAR2,
129 x_msg_count OUT NOCOPY NUMBER,
130 x_msg_data OUT NOCOPY VARCHAR2
131 );
132
133 PROCEDURE copy_forecast(
134 p_api_version IN NUMBER,
135 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
136 p_commit IN VARCHAR2 := FND_API.g_false,
137 p_forecast_id IN NUMBER,
138 x_return_status OUT NOCOPY VARCHAR2,
139 x_msg_count OUT NOCOPY NUMBER,
140 x_msg_data OUT NOCOPY VARCHAR2
141 );
142
143
144 PROCEDURE cascade_update(
145 p_api_version IN NUMBER,
146 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
147 p_commit IN VARCHAR2 := FND_API.g_false,
148
149 p_id IN NUMBER,
150 p_value IN NUMBER,
151 p_fwd_buy_value IN NUMBER,
152 p_fcast_id IN NUMBER,
153 p_cascade_flag IN NUMBER,
154
155 x_return_status OUT NOCOPY VARCHAR2,
156 x_msg_count OUT NOCOPY NUMBER,
157 x_msg_data OUT NOCOPY VARCHAR2
158 );
159
160 PROCEDURE cascade_first_level(
161 p_api_version IN NUMBER,
162 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
163 p_commit IN VARCHAR2 := FND_API.g_false,
164
165 p_fcast_value IN NUMBER,
166 p_fwd_buy_value IN NUMBER,
167 p_fcast_id IN NUMBER,
168 p_cascade_flag IN NUMBER,
169
170 x_return_status OUT NOCOPY VARCHAR2,
171 x_msg_count OUT NOCOPY NUMBER,
172 x_msg_data OUT NOCOPY VARCHAR2
173 );
174
175 procedure calc_perc(
176 p_api_version IN NUMBER,
177 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
178 p_commit IN VARCHAR2 := FND_API.g_false,
179
180 p_used_by_id IN NUMBER,
181 p_level_num IN NUMBER,
182 p_spread_type IN VARCHAR2,
183
184 x_return_status OUT NOCOPY VARCHAR2,
185 x_msg_count OUT NOCOPY NUMBER,
186 x_msg_data OUT NOCOPY VARCHAR2
187 );
188
189 procedure allocate_facts(
190 p_api_version IN NUMBER,
191 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
192 p_commit IN VARCHAR2 := FND_API.g_false,
193
194 p_used_by_id IN NUMBER,
195 p_dimention IN VARCHAR2,
196
197 x_return_status OUT NOCOPY VARCHAR2,
198 x_msg_count OUT NOCOPY NUMBER,
199 x_msg_data OUT NOCOPY VARCHAR2
200 );
201
202
203
204 PROCEDURE get_discount_info(
205 p_api_version IN NUMBER,
206 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
207 p_commit IN VARCHAR2 := FND_API.g_false,
208
209 p_obj_type IN VARCHAR2,
210 p_obj_id IN NUMBER,
211 p_forecast_id IN NUMBER,
212 p_currency_code IN VARCHAR2,
213 p_product_attribute IN VARCHAR2,
214 p_product_attr_value IN VARCHAR2,
215 p_node_id IN NUMBER,
216
217 x_list_price OUT NOCOPY NUMBER,
218 x_discount_type OUT NOCOPY VARCHAR2,
219 x_discount_value OUT NOCOPY NUMBER,
220 x_standard_cost OUT NOCOPY NUMBER,
221
222 x_return_status OUT NOCOPY VARCHAR2,
223 x_msg_count OUT NOCOPY NUMBER,
224 x_msg_data OUT NOCOPY VARCHAR2 );
225
226
227 PROCEDURE get_actual_sales(
228 p_api_version IN NUMBER,
229 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
230 p_commit IN VARCHAR2 := FND_API.g_false,
231
232 p_obj_type IN VARCHAR2,
233 p_obj_id IN NUMBER,
234 p_product_attribute IN VARCHAR2,
235 p_product_attr_value IN VARCHAR2,
236 p_fcst_uom IN VARCHAR2,
237 p_cogs IN NUMBER,
238
239 x_actual_units OUT NOCOPY NUMBER,
240 x_actual_revenue OUT NOCOPY NUMBER,
241 x_actual_costs OUT NOCOPY NUMBER,
242 x_roi OUT NOCOPY NUMBER,
243
244 x_return_status OUT NOCOPY VARCHAR2,
245 x_msg_count OUT NOCOPY NUMBER,
246 x_msg_data OUT NOCOPY VARCHAR2 );
247
248
249
250 PROCEDURE get_volume_offer_discount(
251 p_api_version IN NUMBER,
252 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
253 p_commit IN VARCHAR2 := FND_API.g_false,
254
255 p_obj_type IN VARCHAR2,
256 p_obj_id IN NUMBER,
257 p_forecast_id IN NUMBER,
258 p_currency_code IN VARCHAR2,
259
260 p_product_attribute IN VARCHAR2,
261 p_product_attr_value IN VARCHAR2,
262
263 x_discount_type_code OUT NOCOPY VARCHAR2,
264 x_discount OUT NOCOPY NUMBER,
265
266 x_return_status OUT NOCOPY VARCHAR2,
267 x_msg_count OUT NOCOPY NUMBER,
268 x_msg_data OUT NOCOPY VARCHAR2 );
269
270
271
272
273 PROCEDURE get_list_price(
274 p_api_version IN NUMBER,
275 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
276 p_commit IN VARCHAR2 := FND_API.g_false,
277
278 p_obj_type IN VARCHAR2,
279 p_obj_id IN NUMBER,
280 p_forecast_id IN NUMBER,
281 p_product_attribute IN VARCHAR2,
282 p_product_attr_value IN VARCHAR2,
283 p_fcst_uom IN VARCHAR2,
284 p_currency_code IN VARCHAR2,
285 p_price_list_id IN NUMBER,
286
287 x_list_price OUT NOCOPY NUMBER,
288 x_return_status OUT NOCOPY VARCHAR2,
289 x_msg_count OUT NOCOPY NUMBER,
290 x_msg_data OUT NOCOPY VARCHAR2
291 );
292
293
294
295 PROCEDURE allocate_pg_facts(
296 p_api_version IN NUMBER,
297 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
298 p_commit IN VARCHAR2 := FND_API.g_false,
299
300 p_used_by_id IN NUMBER,
301 p_dimention IN VARCHAR2,
302 p_currency_code IN VARCHAR2,
303
304 x_return_status OUT NOCOPY VARCHAR2,
305 x_msg_count OUT NOCOPY NUMBER,
306 x_msg_data OUT NOCOPY VARCHAR2
307 ) ;
308
309 PROCEDURE get_other_costs (p_obj_type IN VARCHAR2,
310 p_obj_id IN VARCHAR2,
311 p_product_attribute IN VARCHAR2,
312 p_product_attr_value IN VARCHAR2,
313 p_uom IN VARCHAR2,
314 p_other_costs OUT NOCOPY VARCHAR2) ;
315
316 PROCEDURE cascade_baseline_update(
317 p_api_version IN NUMBER,
318 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
319 p_commit IN VARCHAR2 := FND_API.g_false,
320 p_id IN NUMBER,
321 p_value IN NUMBER,
322 p_fcast_id IN NUMBER,
323 p_rem_value IN NUMBER,
324 p_cascade_flag IN NUMBER,
325 p_tpr_percent IN NUMBER,
326 p_obj_type IN VARCHAR2,
327 p_obj_id IN NUMBER,
328 x_return_status OUT NOCOPY VARCHAR2,
329 x_msg_count OUT NOCOPY NUMBER,
330 x_msg_data OUT NOCOPY VARCHAR2
331 );
332
333 PROCEDURE cascade_baseline_levels(
334 p_api_version IN NUMBER,
335 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
336 p_commit IN VARCHAR2 := FND_API.g_false,
337 p_fcast_value IN NUMBER,
338 p_fcast_id IN NUMBER,
339 p_cascade_flag IN NUMBER,
340 p_obj_type IN VARCHAR2,
341 p_obj_id IN NUMBER,
342 x_return_status OUT NOCOPY VARCHAR2,
343 x_msg_count OUT NOCOPY NUMBER,
344 x_msg_data OUT NOCOPY VARCHAR2
345 );
346
347 PROCEDURE fcst_BL_remqty(
348 p_api_version IN NUMBER,
349 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
350 p_commit IN VARCHAR2 := FND_API.g_false,
351
352 p_forecast_id IN NUMBER,
353
354 x_return_status OUT NOCOPY VARCHAR2,
355 x_msg_count OUT NOCOPY NUMBER,
356 x_msg_data OUT NOCOPY VARCHAR2
357 );
358
359 END;