19: --
20: -- Input Parameters
21: -- p_api_version
22: -- API version number (current version is 1.0)
23: -- p_init_msg_list (optional, default FND_API.G_FALSE)
24: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
25: -- if set to FND_API.G_TRUE
26: -- initialize error message list
27: -- if set to FND_API.G_FALSE - do not initialize error
20: -- Input Parameters
21: -- p_api_version
22: -- API version number (current version is 1.0)
23: -- p_init_msg_list (optional, default FND_API.G_FALSE)
24: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
25: -- if set to FND_API.G_TRUE
26: -- initialize error message list
27: -- if set to FND_API.G_FALSE - do not initialize error
28: -- message list
21: -- p_api_version
22: -- API version number (current version is 1.0)
23: -- p_init_msg_list (optional, default FND_API.G_FALSE)
24: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
25: -- if set to FND_API.G_TRUE
26: -- initialize error message list
27: -- if set to FND_API.G_FALSE - do not initialize error
28: -- message list
29: -- p_commit (optional, default FND_API.G_FALSE)
23: -- p_init_msg_list (optional, default FND_API.G_FALSE)
24: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
25: -- if set to FND_API.G_TRUE
26: -- initialize error message list
27: -- if set to FND_API.G_FALSE - do not initialize error
28: -- message list
29: -- p_commit (optional, default FND_API.G_FALSE)
30: -- whether or not to commit the changes to database
31: -- p_organization_id Organization - Required
25: -- if set to FND_API.G_TRUE
26: -- initialize error message list
27: -- if set to FND_API.G_FALSE - do not initialize error
28: -- message list
29: -- p_commit (optional, default FND_API.G_FALSE)
30: -- whether or not to commit the changes to database
31: -- p_organization_id Organization - Required
32: -- p_subinventory Subinventory - Required
33: -- p_locator_id Locator Id - Required
35: --
36: -- Output Parameters
37: -- x_return_status
38: -- if the Create_Unscheduled_Counts API succeeds, this value is
39: -- FND_API.G_RET_STS_SUCCESS;
40: -- if there is an expected error, this value is
41: -- FND_API.G_RET_STS_ERROR;
42: -- if there is an unexpected error, this value is
43: -- FND_API.G_RET_STS_UNEXP_ERROR;
37: -- x_return_status
38: -- if the Create_Unscheduled_Counts API succeeds, this value is
39: -- FND_API.G_RET_STS_SUCCESS;
40: -- if there is an expected error, this value is
41: -- FND_API.G_RET_STS_ERROR;
42: -- if there is an unexpected error, this value is
43: -- FND_API.G_RET_STS_UNEXP_ERROR;
44: -- x_msg_count
45: -- if there is one or more errors, this output variable represents
39: -- FND_API.G_RET_STS_SUCCESS;
40: -- if there is an expected error, this value is
41: -- FND_API.G_RET_STS_ERROR;
42: -- if there is an unexpected error, this value is
43: -- FND_API.G_RET_STS_UNEXP_ERROR;
44: -- x_msg_count
45: -- if there is one or more errors, this output variable represents
46: -- the number of error messages in the buffer
47: -- x_msg_data
51: --Added NOCOPY hint to x_return_status,x_msg_count and x_msg_data to comply with
52: --GSCC File.Sql.39 standard Bug:4410902
53: PROCEDURE Create_Unscheduled_Counts
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: x_return_status OUT NOCOPY VARCHAR2 ,
58: x_msg_count OUT NOCOPY NUMBER ,
59: x_msg_data OUT NOCOPY VARCHAR2 ,
52: --GSCC File.Sql.39 standard Bug:4410902
53: PROCEDURE Create_Unscheduled_Counts
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: x_return_status OUT NOCOPY VARCHAR2 ,
58: x_msg_count OUT NOCOPY NUMBER ,
59: x_msg_data OUT NOCOPY VARCHAR2 ,
60: p_organization_id IN NUMBER ,