1 PACKAGE WMS_Cycle_PVT AS
2 /* $Header: WMSCYCCS.pls 120.1.12000000.1 2007/01/16 06:51:57 appldev ship $ */
3
4
5 /*---------------------------------------------------------------------*/
6 -- Name
7 -- PROCEDURE Create_Unscheduled_Counts
8 /*---------------------------------------------------------------------*/
9 -- Purpose
10 -- This API allows you to manually schedule a cycle count for a
11 -- given organization, subinventory, locator and Item (BUG#2867331). This will create
12 -- unscheduled count entries for the default cycle count associated with
13 -- the organization. If there is none associated with the organization,
14 -- or if the cycle count doesn't allow unscheduled counts, then this will
15 -- error out with the appropriate error messages. Count entries will not
16 -- be generated for items that are not associated with that cycle count
17 -- but unscheduled counts will be allowed.
18 --
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
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
34 -- p_inventory_item_id Inventory Item ID - Required (BUG #2867331)
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;
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
48 -- if there is one and only one error, this output variable
49 -- contains the error message
50 --
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 ,
60 p_organization_id IN NUMBER ,
61 p_subinventory IN VARCHAR2 ,
62 p_locator_id IN NUMBER ,
63 p_inventory_item_id IN NUMBER
64 );
65
66
67 END WMS_Cycle_PVT;