12: --
13: -- Parameters :
14: -- IN : p_api_version IN NUMBER Required
15: -- p_init_msg_list IN VARCHAR2 Optional
16: -- Default = FND_API.G_FALSE
17: -- p_commit IN VARCHAR2 Optional
18: -- Default = FND_API.G_FALSE
19: -- p_validation_level IN NUMBER Optional
20: -- Default = FND_API.G_VALID_LEVEL_FULL
14: -- IN : p_api_version IN NUMBER Required
15: -- p_init_msg_list IN VARCHAR2 Optional
16: -- Default = FND_API.G_FALSE
17: -- p_commit IN VARCHAR2 Optional
18: -- Default = FND_API.G_FALSE
19: -- p_validation_level IN NUMBER Optional
20: -- Default = FND_API.G_VALID_LEVEL_FULL
21: -- OUT : x_return_status OUT VARCHAR2(1)
22: -- x_msg_count OUT NUMBER
16: -- Default = FND_API.G_FALSE
17: -- p_commit IN VARCHAR2 Optional
18: -- Default = FND_API.G_FALSE
19: -- p_validation_level IN NUMBER Optional
20: -- Default = FND_API.G_VALID_LEVEL_FULL
21: -- OUT : x_return_status OUT VARCHAR2(1)
22: -- x_msg_count OUT NUMBER
23: -- x_msg_data OUT VARCHAR2(2000)
24: -- : x_loading_status OUT VARCHAR2(50)
35:
36: PROCEDURE Create_Period_Quotas
37: (
38: p_api_version IN NUMBER,
39: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
40: p_commit IN VARCHAR2 := FND_API.G_FALSE,
41: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
42: x_return_status OUT NOCOPY VARCHAR2,
43: x_msg_count OUT NOCOPY NUMBER,
36: PROCEDURE Create_Period_Quotas
37: (
38: p_api_version IN NUMBER,
39: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
40: p_commit IN VARCHAR2 := FND_API.G_FALSE,
41: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
42: x_return_status OUT NOCOPY VARCHAR2,
43: x_msg_count OUT NOCOPY NUMBER,
44: x_msg_data OUT NOCOPY VARCHAR2,
37: (
38: p_api_version IN NUMBER,
39: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
40: p_commit IN VARCHAR2 := FND_API.G_FALSE,
41: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
42: x_return_status OUT NOCOPY VARCHAR2,
43: x_msg_count OUT NOCOPY NUMBER,
44: x_msg_data OUT NOCOPY VARCHAR2,
45: p_quota_name IN VARCHAR2,
51:
52: PROCEDURE Update_Period_Quotas
53: (
54: p_api_version IN NUMBER,
55: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
56: p_commit IN VARCHAR2 := FND_API.G_FALSE,
57: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
58: x_return_status OUT NOCOPY VARCHAR2,
59: x_msg_count OUT NOCOPY NUMBER,
52: PROCEDURE Update_Period_Quotas
53: (
54: p_api_version IN NUMBER,
55: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
56: p_commit IN VARCHAR2 := FND_API.G_FALSE,
57: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
58: x_return_status OUT NOCOPY VARCHAR2,
59: x_msg_count OUT NOCOPY NUMBER,
60: x_msg_data OUT NOCOPY VARCHAR2,
53: (
54: p_api_version IN NUMBER,
55: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
56: p_commit IN VARCHAR2 := FND_API.G_FALSE,
57: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
58: x_return_status OUT NOCOPY VARCHAR2,
59: x_msg_count OUT NOCOPY NUMBER,
60: x_msg_data OUT NOCOPY VARCHAR2,
61: p_quota_name IN VARCHAR2,