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