DBA Data[Home] [Help]

PACKAGE: APPS.CSD_MASS_RO_SN_ERRORS_PKG

Source


1 PACKAGE CSD_MASS_RO_SN_ERRORS_PKG AUTHID CURRENT_USER as
2 /* $Header: csdtmres.pls 115.2 2003/08/13 17:23:40 mshirkol noship $ */
3 -- Start of Comments
4 -- Package name     : CSD_MASS_RO_SN_ERRORS_PKG
5 -- Purpose          :
6 -- History          :
7 -- NOTE             :
8 -- End of Comments
9 
10 PROCEDURE Insert_Row(
11           px_MASS_RO_SN_ERROR_ID   IN OUT NOCOPY NUMBER
12          ,p_REPAIR_LINE_ID   NUMBER
13          ,p_MASS_RO_SN_ID    NUMBER
14          ,p_ERROR_TYPE    VARCHAR2
15          ,p_ERROR_MSG    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          ,p_OBJECT_VERSION_NUMBER    NUMBER);
22 
23 PROCEDURE Update_Row(
24           p_MASS_RO_SN_ERROR_ID    NUMBER
25          ,p_REPAIR_LINE_ID   NUMBER
26          ,p_MASS_RO_SN_ID    NUMBER
27          ,p_ERROR_TYPE    VARCHAR2
28          ,p_ERROR_MSG    VARCHAR2
29          ,p_CREATED_BY    NUMBER
30          ,p_CREATION_DATE    DATE
31          ,p_LAST_UPDATED_BY    NUMBER
32          ,p_LAST_UPDATE_DATE    DATE
33          ,p_LAST_UPDATE_LOGIN    NUMBER
34          ,p_OBJECT_VERSION_NUMBER    NUMBER);
35 
36 PROCEDURE Lock_Row(
37           p_MASS_RO_SN_ERROR_ID    NUMBER
38          ,p_REPAIR_LINE_ID   NUMBER
39          ,p_MASS_RO_SN_ID    NUMBER
40          ,p_ERROR_TYPE    VARCHAR2
41          ,p_ERROR_MSG    VARCHAR2
42          ,p_CREATED_BY    NUMBER
43          ,p_CREATION_DATE    DATE
44          ,p_LAST_UPDATED_BY    NUMBER
45          ,p_LAST_UPDATE_DATE    DATE
46          ,p_LAST_UPDATE_LOGIN    NUMBER
47          ,p_OBJECT_VERSION_NUMBER    NUMBER);
48 
49 PROCEDURE Delete_Row(
50     p_MASS_RO_SN_ERROR_ID  NUMBER);
51 End CSD_MASS_RO_SN_ERRORS_PKG;