PACKAGE: APPS.CSP_EXCESS_LST_SERIAL_LOTS_PKG

Source

1 PACKAGE CSP_EXCESS_LST_SERIAL_LOTS_PKG AUTHID CURRENT_USER as
2 /* $Header: csptesls.pls 115.6 2003/02/27 23:41:02 ajosephg ship $ */
3 -- Start of Comments
4 -- Package name     : CSP_EXCESS_LST_SERIAL_LOTS_PKG
5 -- Purpose          :
6 -- History          :
7 -- NOTE             :
8 -- End of Comments
9 
10 PROCEDURE Insert_Row(
11           px_EXCESS_LIST_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_EXCESS_LINE_ID    NUMBER,
18           p_QUANTITY    NUMBER,
19           p_LOT_NUMBER    VARCHAR2,
20           p_SERIAL_NUMBER    VARCHAR2,
21           p_REVISION VARCHAR2,
22           p_LOCATOR_ID NUMBER);
23 
24 PROCEDURE Update_Row(
25           p_EXCESS_LIST_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_EXCESS_LINE_ID    NUMBER,
32           p_QUANTITY    NUMBER,
33           p_LOT_NUMBER    VARCHAR2,
34           p_SERIAL_NUMBER    VARCHAR2,
35           p_REVISION VARCHAR2,
36           p_LOCATOR_ID NUMBER);
37 
38 
39 PROCEDURE Lock_Row(
40           p_EXCESS_LIST_SERIAL_LOT_ID    NUMBER,
41           p_CREATED_BY    NUMBER,
42           p_CREATION_DATE    DATE,
43           p_LAST_UPDATED_BY    NUMBER,
44           p_LAST_UPDATE_DATE    DATE,
45           p_LAST_UPDATE_LOGIN    NUMBER,
46           p_EXCESS_LINE_ID    NUMBER,
47           p_QUANTITY    NUMBER,
48           p_LOT_NUMBER    VARCHAR2,
49           p_SERIAL_NUMBER    VARCHAR2,
50           p_REVISION VARCHAR2,
51           p_LOCATOR_ID NUMBER);
52 
53 PROCEDURE Delete_Row(
54     p_EXCESS_LIST_SERIAL_LOT_ID  NUMBER);
55 End CSP_EXCESS_LST_SERIAL_LOTS_PKG;