PACKAGE: APPS.CSP_STOCK_LISTS_PKG

Source

1 PACKAGE CSP_STOCK_LISTS_PKG AUTHID CURRENT_USER AS
2 /* $Header: csptpsls.pls 115.3 2002/11/26 06:34:49 hhaugeru noship $ */
3 -- Start of Comments
4 -- Package name     : CSP_STOCK_LISTS_PKG
5 -- Purpose          :
6 -- History          :
7 -- NOTE             :
8 -- End of Comments
9 
10 PROCEDURE Insert_Row(
11           p_ORGANIZATION_ID    NUMBER
12          ,p_INVENTORY_ITEM_ID   IN NUMBER
13          ,p_SUBINVENTORY_CODE    VARCHAR2
14          ,p_MANUAL_AUTO    VARCHAR2
15          ,p_REASON_CODE    VARCHAR2
16          ,p_CREATED_BY    NUMBER
17          ,p_CREATION_DATE    DATE
18          ,p_LAST_UPDATED_BY    NUMBER
19          ,p_LAST_UPDATE_DATE    DATE
20          ,p_LAST_UPDATE_LOGIN    NUMBER
21 );
22 PROCEDURE Update_Row(
23           p_ORGANIZATION_ID    NUMBER
24          ,p_INVENTORY_ITEM_ID    NUMBER
25          ,p_SUBINVENTORY_CODE    VARCHAR2
26          ,p_MANUAL_AUTO    VARCHAR2
27          ,p_REASON_CODE    VARCHAR2
28          ,p_CREATED_BY    NUMBER
29          ,p_CREATION_DATE    DATE
30          ,p_LAST_UPDATED_BY    NUMBER
31          ,p_LAST_UPDATE_DATE    DATE
32          ,p_LAST_UPDATE_LOGIN    NUMBER
33 );
34 PROCEDURE Lock_Row(
35           p_ORGANIZATION_ID    NUMBER
36          ,p_INVENTORY_ITEM_ID    NUMBER
37          ,p_SUBINVENTORY_CODE    VARCHAR2
38          ,p_MANUAL_AUTO    VARCHAR2
39          ,p_REASON_CODE    VARCHAR2
40          ,p_CREATED_BY    NUMBER
41          ,p_CREATION_DATE    DATE
42          ,p_LAST_UPDATED_BY    NUMBER
43          ,p_LAST_UPDATE_DATE    DATE
44          ,p_LAST_UPDATE_LOGIN    NUMBER
45 );
46 
47 PROCEDURE Delete_Row(
48     p_INVENTORY_ITEM_ID  NUMBER
49    ,p_ORGANIZATION_ID    NUMBER
50    ,p_SUBINVENTORY_CODE  VARCHAR2
51 );
52 
53 End CSP_STOCK_LISTS_PKG;