PACKAGE: APPS.CSP_STOCK_LISTS_PVT

Source

1 PACKAGE CSP_STOCK_LISTS_PVT authid current_user as
2 /* $Header: cspvstls.pls 120.0.12020000.4 2013/03/21 04:11:57 sunarasi noship $ */
3 -- Start of Comments
4 -- Package name     :CSP_STOCK_LISTS_PVT
5 -- Purpose          :
6 -- History          :
7 --  01-Mar-13, sunarasi
8 --
9 -- NOTE             :
10 -- End of Comments
11   PROCEDURE PROCESS_ITEMS       (
12                                 p_ORGANIZATION_ID    NUMBER
13                                ,p_INVENTORY_ITEM_ID   IN NUMBER
14                                ,p_SUBINVENTORY_CODE    VARCHAR2
15                                ,p_MANUAL_AUTO    VARCHAR2
16                                ,p_REASON_CODE    VARCHAR2
17                                ,p_CREATED_BY    NUMBER
18                                ,p_CREATION_DATE    DATE
19                                ,p_LAST_UPDATED_BY    NUMBER
20                                ,p_LAST_UPDATE_DATE    DATE
21                                ,p_LAST_UPDATE_LOGIN    NUMBER
22                                ,x_return_status out NOCOPY VARCHAR2);
23   PROCEDURE PROCESS_SUBINV_ITEMS(
24           p_ROWID VARCHAR2,
25           p_INVENTORY_ITEM_ID  NUMBER,
26           p_ORGANIZATION_ID    NUMBER,
27           p_SECONDARY_INVENTORY    VARCHAR2,
28           p_LAST_UPDATE_DATE    DATE,
29           p_LAST_UPDATED_BY    NUMBER,
30           p_CREATION_DATE    DATE,
31           p_CREATED_BY    NUMBER,
32           p_LAST_UPDATE_LOGIN    NUMBER,
33           p_PRIMARY_SUBINVENTORY_FLAG    NUMBER,
34           p_PICKING_ORDER    NUMBER,
35           p_MIN_MINMAX_QUANTITY    NUMBER,
36           p_MAX_MINMAX_QUANTITY    NUMBER,
37           p_INVENTORY_PLANNING_CODE    NUMBER,
38           p_FIXED_LOT_MULTIPLE    NUMBER,
39           p_MINIMUM_ORDER_QUANTITY    NUMBER,
40           p_MAXIMUM_ORDER_QUANTITY    NUMBER,
41           p_SOURCE_TYPE    NUMBER,
42           p_SOURCE_ORGANIZATION_ID    NUMBER,
43           p_SOURCE_SUBINVENTORY    VARCHAR2,
44           p_ATTRIBUTE_CATEGORY    VARCHAR2,
45           p_ATTRIBUTE1    VARCHAR2,
46           p_ATTRIBUTE2    VARCHAR2,
47           p_ATTRIBUTE3    VARCHAR2,
48           p_ATTRIBUTE4    VARCHAR2,
49           p_ATTRIBUTE5    VARCHAR2,
50           p_ATTRIBUTE6    VARCHAR2,
51           p_ATTRIBUTE7    VARCHAR2,
52           p_ATTRIBUTE8    VARCHAR2,
53           p_ATTRIBUTE9    VARCHAR2,
54           p_ATTRIBUTE10    VARCHAR2,
55           p_ATTRIBUTE11    VARCHAR2,
56           p_ATTRIBUTE12    VARCHAR2,
57           p_ATTRIBUTE13    VARCHAR2,
58           p_ATTRIBUTE14    VARCHAR2,
59           p_ATTRIBUTE15    VARCHAR2,
60           p_ENCUMBRANCE_ACCOUNT    NUMBER,
61           p_PREPROCESSING_LEAD_TIME    NUMBER,
62           p_PROCESSING_LEAD_TIME    NUMBER,
63           p_POSTPROCESSING_LEAD_TIME    NUMBER
64           ,X_RETURN_STATUS OUT NOCOPY VARCHAR2);
65    PROCEDURE DELETE_STOCK_LIST(
66                         P_INVENTORY_ITEM_ID  NUMBER
67                        ,p_ORGANIZATION_ID    NUMBER
68                        ,p_SUBINVENTORY_CODE    VARCHAR2
69                        ,x_return_status out NOCOPY VARCHAR2);
70 END CSP_STOCK_LISTS_PVT;