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,
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,
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,
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,
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:
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,
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,
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,
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:
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,
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:
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,
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,
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
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,
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,
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,
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,
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,
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,
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,
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:
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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:
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,