DBA Data[Home] [Help]

APPS.OZF_FORECAST_UTIL_PVT dependencies on FND_API

Line 32: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

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,

Line 33: p_commit IN VARCHAR2 := FND_API.g_false,

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,

Line 47: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

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,

Line 48: p_commit IN VARCHAR2 := FND_API.g_false,

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,

Line 70: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

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:

Line 71: p_commit IN VARCHAR2 := FND_API.g_false,

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,

Line 81: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

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,

Line 82: p_commit IN VARCHAR2 := FND_API.g_false,

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,

Line 110: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

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:

Line 111: p_commit IN VARCHAR2 := FND_API.g_false,

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,

Line 123: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

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:

Line 124: p_commit IN VARCHAR2 := FND_API.g_false,

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,

Line 135: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

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,

Line 136: p_commit IN VARCHAR2 := FND_API.g_false,

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

Line 146: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

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,

Line 147: p_commit IN VARCHAR2 := FND_API.g_false,

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,

Line 162: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

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,

Line 163: p_commit IN VARCHAR2 := FND_API.g_false,

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,

Line 177: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

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,

Line 178: p_commit IN VARCHAR2 := FND_API.g_false,

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,

Line 191: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

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,

Line 192: p_commit IN VARCHAR2 := FND_API.g_false,

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:

Line 206: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

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,

Line 207: p_commit IN VARCHAR2 := FND_API.g_false,

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,

Line 229: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

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,

Line 230: p_commit IN VARCHAR2 := FND_API.g_false,

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,

Line 252: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

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,

Line 253: p_commit IN VARCHAR2 := FND_API.g_false,

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,

Line 275: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

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,

Line 276: p_commit IN VARCHAR2 := FND_API.g_false,

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,

Line 297: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

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,

Line 298: p_commit IN VARCHAR2 := FND_API.g_false,

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,

Line 318: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

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,

Line 319: p_commit IN VARCHAR2 := FND_API.g_false,

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,

Line 335: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

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,

Line 336: p_commit IN VARCHAR2 := FND_API.g_false,

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,

Line 349: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

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:

Line 350: p_commit IN VARCHAR2 := FND_API.g_false,

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,