14: -- 3. Add-on Quota on subsequent call
15: -- -----------------------------------------------------------------
16: PROCEDURE setup_product_spread(
17: p_api_version IN NUMBER,
18: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
19: p_commit IN VARCHAR2 := FND_API.G_FALSE,
20: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
21: x_return_status OUT NOCOPY VARCHAR2,
22: x_error_number OUT NOCOPY NUMBER,
15: -- -----------------------------------------------------------------
16: PROCEDURE setup_product_spread(
17: p_api_version IN NUMBER,
18: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
19: p_commit IN VARCHAR2 := FND_API.G_FALSE,
20: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
21: x_return_status OUT NOCOPY VARCHAR2,
22: x_error_number OUT NOCOPY NUMBER,
23: x_error_message OUT NOCOPY VARCHAR2,
16: PROCEDURE setup_product_spread(
17: p_api_version IN NUMBER,
18: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
19: p_commit IN VARCHAR2 := FND_API.G_FALSE,
20: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
21: x_return_status OUT NOCOPY VARCHAR2,
22: x_error_number OUT NOCOPY NUMBER,
23: x_error_message OUT NOCOPY VARCHAR2,
24: p_mode IN VARCHAR2,
32: -- who are part of same hierarchy.
33: -- -----------------------------------------------------------------
34: PROCEDURE cascade_product_spread(
35: p_api_version IN NUMBER,
36: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
37: p_commit IN VARCHAR2 := FND_API.G_FALSE,
38: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
39: x_return_status OUT NOCOPY VARCHAR2,
40: x_error_number OUT NOCOPY NUMBER,
33: -- -----------------------------------------------------------------
34: PROCEDURE cascade_product_spread(
35: p_api_version IN NUMBER,
36: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
37: p_commit IN VARCHAR2 := FND_API.G_FALSE,
38: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
39: x_return_status OUT NOCOPY VARCHAR2,
40: x_error_number OUT NOCOPY NUMBER,
41: x_error_message OUT NOCOPY VARCHAR2,
34: PROCEDURE cascade_product_spread(
35: p_api_version IN NUMBER,
36: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
37: p_commit IN VARCHAR2 := FND_API.G_FALSE,
38: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
39: x_return_status OUT NOCOPY VARCHAR2,
40: x_error_number OUT NOCOPY NUMBER,
41: x_error_message OUT NOCOPY VARCHAR2,
42: p_mode IN VARCHAR2,
52: -- -----------------------------------------------------------------
53: PROCEDURE allocate_target
54: (
55: p_api_version IN NUMBER,
56: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
57: p_commit IN VARCHAR2 := FND_API.G_FALSE,
58: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
59: x_return_status OUT NOCOPY VARCHAR2,
60: x_error_number OUT NOCOPY NUMBER,
53: PROCEDURE allocate_target
54: (
55: p_api_version IN NUMBER,
56: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
57: p_commit IN VARCHAR2 := FND_API.G_FALSE,
58: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
59: x_return_status OUT NOCOPY VARCHAR2,
60: x_error_number OUT NOCOPY NUMBER,
61: x_error_message OUT NOCOPY VARCHAR2,
54: (
55: p_api_version IN NUMBER,
56: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
57: p_commit IN VARCHAR2 := FND_API.G_FALSE,
58: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
59: x_return_status OUT NOCOPY VARCHAR2,
60: x_error_number OUT NOCOPY NUMBER,
61: x_error_message OUT NOCOPY VARCHAR2,
62: p_mode IN VARCHAR2,