PACKAGE: APPS.CSP_PICKLIST_SERIAL_LOTS_PKG

Source

1 PACKAGE CSP_PICKLIST_SERIAL_LOTS_PKG AUTHID CURRENT_USER AS
2 /* $Header: cspttsls.pls 115.3 2002/11/26 07:13:08 hhaugeru ship $ */
3 -- Start of Comments
4 -- Package name     : CSP_PICKLIST_SERIAL_LOTS_PKG
5 -- Purpose          :
6 -- History          :
7 -- NOTE             :
8 -- End of Comments
9 
10 PROCEDURE Insert_Row(
11           px_PICKLIST_SERIAL_LOT_ID   IN OUT NOCOPY NUMBER,
12           p_CREATED_BY    NUMBER,
13           p_CREATION_DATE    DATE,
14           p_LAST_UPDATED_BY    NUMBER,
15           p_LAST_UPDATE_DATE    DATE,
16           p_LAST_UPDATE_LOGIN    NUMBER,
17           p_PICKLIST_LINE_ID    NUMBER,
18           p_ORGANIZATION_ID    NUMBER,
19           p_INVENTORY_ITEM_ID    NUMBER,
20           p_QUANTITY    NUMBER,
21           p_LOT_NUMBER    VARCHAR2,
22           p_SERIAL_NUMBER    VARCHAR2);
23 
24 PROCEDURE Update_Row(
25           p_PICKLIST_SERIAL_LOT_ID    NUMBER,
26           p_CREATED_BY    NUMBER,
27           p_CREATION_DATE    DATE,
28           p_LAST_UPDATED_BY    NUMBER,
29           p_LAST_UPDATE_DATE    DATE,
30           p_LAST_UPDATE_LOGIN    NUMBER,
31           p_PICKLIST_LINE_ID    NUMBER,
32           p_ORGANIZATION_ID    NUMBER,
33           p_INVENTORY_ITEM_ID    NUMBER,
34           p_QUANTITY    NUMBER,
35           p_LOT_NUMBER    VARCHAR2,
36           p_SERIAL_NUMBER    VARCHAR2);
37 
38 PROCEDURE Lock_Row(
39           p_PICKLIST_SERIAL_LOT_ID    NUMBER,
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           p_PICKLIST_LINE_ID    NUMBER,
46           p_ORGANIZATION_ID    NUMBER,
47           p_INVENTORY_ITEM_ID    NUMBER,
48           p_QUANTITY    NUMBER,
49           p_LOT_NUMBER    VARCHAR2,
50           p_SERIAL_NUMBER    VARCHAR2);
51 
52 PROCEDURE Delete_Row(
53     p_PICKLIST_SERIAL_LOT_ID  NUMBER);
54 End CSP_PICKLIST_SERIAL_LOTS_PKG;