158: */
159:
160: PROCEDURE Create_Quota(
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: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
165: ,x_return_status OUT NOCOPY VARCHAR2
166: ,x_msg_count OUT NOCOPY NUMBER
159:
160: PROCEDURE Create_Quota(
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: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
165: ,x_return_status OUT NOCOPY VARCHAR2
166: ,x_msg_count OUT NOCOPY NUMBER
167: ,x_msg_data OUT NOCOPY VARCHAR2
160: PROCEDURE Create_Quota(
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: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
165: ,x_return_status OUT NOCOPY VARCHAR2
166: ,x_msg_count OUT NOCOPY NUMBER
167: ,x_msg_data OUT NOCOPY VARCHAR2
168: ,p_method IN VARCHAR2 := 'MANUAL'
199: */
200:
201: PROCEDURE Create_Quota_Product_Spread(
202: p_api_version IN NUMBER
203: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
204: ,p_commit IN VARCHAR2 := fnd_api.g_false
205: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
206: ,x_return_status OUT NOCOPY VARCHAR2
207: ,x_msg_count OUT NOCOPY NUMBER
200:
201: PROCEDURE Create_Quota_Product_Spread(
202: p_api_version IN NUMBER
203: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
204: ,p_commit IN VARCHAR2 := fnd_api.g_false
205: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
206: ,x_return_status OUT NOCOPY VARCHAR2
207: ,x_msg_count OUT NOCOPY NUMBER
208: ,x_msg_data OUT NOCOPY VARCHAR2
201: PROCEDURE Create_Quota_Product_Spread(
202: p_api_version IN NUMBER
203: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
204: ,p_commit IN VARCHAR2 := fnd_api.g_false
205: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
206: ,x_return_status OUT NOCOPY VARCHAR2
207: ,x_msg_count OUT NOCOPY NUMBER
208: ,x_msg_data OUT NOCOPY VARCHAR2
209: ,p_allocation_for IN VARCHAR2
232: */
233:
234: PROCEDURE Create_Quota_Account_Spread(
235: p_api_version IN NUMBER
236: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
237: ,p_commit IN VARCHAR2 := fnd_api.g_false
238: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
239: ,x_return_status OUT NOCOPY VARCHAR2
240: ,x_msg_count OUT NOCOPY NUMBER
233:
234: PROCEDURE Create_Quota_Account_Spread(
235: p_api_version IN NUMBER
236: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
237: ,p_commit IN VARCHAR2 := fnd_api.g_false
238: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
239: ,x_return_status OUT NOCOPY VARCHAR2
240: ,x_msg_count OUT NOCOPY NUMBER
241: ,x_msg_data OUT NOCOPY VARCHAR2
234: PROCEDURE Create_Quota_Account_Spread(
235: p_api_version IN NUMBER
236: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
237: ,p_commit IN VARCHAR2 := fnd_api.g_false
238: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
239: ,x_return_status OUT NOCOPY VARCHAR2
240: ,x_msg_count OUT NOCOPY NUMBER
241: ,x_msg_data OUT NOCOPY VARCHAR2
242: ,p_fund_id IN NUMBER
266: */
267:
268: PROCEDURE Update_Quota(
269: p_api_version IN NUMBER
270: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
271: ,p_commit IN VARCHAR2 := fnd_api.g_false
272: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
273: ,x_return_status OUT NOCOPY VARCHAR2
274: ,x_msg_count OUT NOCOPY NUMBER
267:
268: PROCEDURE Update_Quota(
269: p_api_version IN NUMBER
270: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
271: ,p_commit IN VARCHAR2 := fnd_api.g_false
272: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
273: ,x_return_status OUT NOCOPY VARCHAR2
274: ,x_msg_count OUT NOCOPY NUMBER
275: ,x_msg_data OUT NOCOPY VARCHAR2
268: PROCEDURE Update_Quota(
269: p_api_version IN NUMBER
270: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
271: ,p_commit IN VARCHAR2 := fnd_api.g_false
272: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
273: ,x_return_status OUT NOCOPY VARCHAR2
274: ,x_msg_count OUT NOCOPY NUMBER
275: ,x_msg_data OUT NOCOPY VARCHAR2
276: ,p_quota_rec IN quota_rec_type );
294: */
295:
296: PROCEDURE Update_Quota_Product_Spread(
297: p_api_version IN NUMBER
298: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
299: ,p_commit IN VARCHAR2 := fnd_api.g_false
300: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
301: ,x_return_status OUT NOCOPY VARCHAR2
302: ,x_msg_count OUT NOCOPY NUMBER
295:
296: PROCEDURE Update_Quota_Product_Spread(
297: p_api_version IN NUMBER
298: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
299: ,p_commit IN VARCHAR2 := fnd_api.g_false
300: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
301: ,x_return_status OUT NOCOPY VARCHAR2
302: ,x_msg_count OUT NOCOPY NUMBER
303: ,x_msg_data OUT NOCOPY VARCHAR2
296: PROCEDURE Update_Quota_Product_Spread(
297: p_api_version IN NUMBER
298: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
299: ,p_commit IN VARCHAR2 := fnd_api.g_false
300: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
301: ,x_return_status OUT NOCOPY VARCHAR2
302: ,x_msg_count OUT NOCOPY NUMBER
303: ,x_msg_data OUT NOCOPY VARCHAR2
304: ,p_quota_products_tbl IN quota_products_tbl_type
323: */
324:
325: PROCEDURE Update_Quota_Account_Spread(
326: p_api_version IN NUMBER
327: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
328: ,p_commit IN VARCHAR2 := fnd_api.g_false
329: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
330: ,x_return_status OUT NOCOPY VARCHAR2
331: ,x_msg_count OUT NOCOPY NUMBER
324:
325: PROCEDURE Update_Quota_Account_Spread(
326: p_api_version IN NUMBER
327: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
328: ,p_commit IN VARCHAR2 := fnd_api.g_false
329: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
330: ,x_return_status OUT NOCOPY VARCHAR2
331: ,x_msg_count OUT NOCOPY NUMBER
332: ,x_msg_data OUT NOCOPY VARCHAR2
325: PROCEDURE Update_Quota_Account_Spread(
326: p_api_version IN NUMBER
327: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
328: ,p_commit IN VARCHAR2 := fnd_api.g_false
329: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
330: ,x_return_status OUT NOCOPY VARCHAR2
331: ,x_msg_count OUT NOCOPY NUMBER
332: ,x_msg_data OUT NOCOPY VARCHAR2
333: ,p_quota_accounts_tbl IN quota_accounts_tbl_type
353: */
354:
355: PROCEDURE delete_quota(
356: p_api_version IN NUMBER
357: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
358: ,p_commit IN VARCHAR2 := fnd_api.g_false
359: ,p_quota_id IN NUMBER
360: ,x_return_status OUT NOCOPY VARCHAR2
361: ,x_msg_count OUT NOCOPY NUMBER
354:
355: PROCEDURE delete_quota(
356: p_api_version IN NUMBER
357: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
358: ,p_commit IN VARCHAR2 := fnd_api.g_false
359: ,p_quota_id IN NUMBER
360: ,x_return_status OUT NOCOPY VARCHAR2
361: ,x_msg_count OUT NOCOPY NUMBER
362: ,x_msg_data OUT NOCOPY VARCHAR2