1 PACKAGE WMS_Cycle_PVT AUTHID CURRENT_USER AS
2 /* $Header: WMSCYCCS.pls 120.1.12010000.4 2010/05/27 11:01:01 abasheer 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
54 /* Bug 7504490 - Modified the procedure. Added the parameter p_pn_id and p_revision
55 to create CC entries for an LPN when a short pick was for an allocated lpn */
56
57 PROCEDURE Create_Unscheduled_Counts
58 ( p_api_version IN NUMBER ,
59 p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
60 p_commit IN VARCHAR2 := fnd_api.g_false ,
61 x_return_status OUT NOCOPY VARCHAR2 ,
62 x_msg_count OUT NOCOPY NUMBER ,
63 x_msg_data OUT NOCOPY VARCHAR2 ,
64 p_organization_id IN NUMBER ,
65 p_subinventory IN VARCHAR2 ,
66 p_locator_id IN NUMBER ,
67 p_inventory_item_id IN NUMBER ,
68 p_lpn_id IN NUMBER ,
69 p_revision IN VARCHAR2,
70 p_cycle_count_header_id IN NUMBER DEFAULT NULL -- For bug # 9751256
71 );
72
73
74 END WMS_Cycle_PVT;