DBA Data[Home] [Help]

PACKAGE: APPS.CSD_GENERIC_ERRMSGS_PKG

Source


1 PACKAGE CSD_GENERIC_ERRMSGS_PKG AUTHID CURRENT_USER as
2 /* $Header: csdtgems.pls 115.0 2003/08/29 18:47:44 vparvath noship $ */
3 -- Start of Comments
4 -- Package name     : CSD_GENERIC_ERRMSGS_PKG
5 -- Purpose          :
6 -- History          :
7 -- NOTE             :
8 -- End of Comments
9 
10 PROCEDURE Insert_Row(
11           px_GENERIC_ERRMSGS_ID   IN OUT NOCOPY NUMBER
12          ,p_MODULE_CODE    VARCHAR2
13          ,p_SOURCE_ENTITY_ID1    NUMBER
14          ,p_SOURCE_ENTITY_ID2    NUMBER
15          ,p_SOURCE_ENTITY_TYPE_CODE    VARCHAR2
16          ,p_MSG_TYPE_CODE    VARCHAR2
17          ,p_MSG    VARCHAR2
18          ,p_MSG_STATUS    VARCHAR2
19          ,p_CREATED_BY    NUMBER
20          ,p_CREATION_DATE    DATE
21          ,p_LAST_UPDATED_BY    NUMBER
22          ,p_LAST_UPDATE_DATE    DATE
23          ,p_LAST_UPDATE_LOGIN    NUMBER
24          ,p_OBJECT_VERSION_NUMBER    NUMBER);
25 
26 PROCEDURE Update_Row(
27           p_GENERIC_ERRMSGS_ID    NUMBER
28          ,p_MODULE_CODE    VARCHAR2
29          ,p_SOURCE_ENTITY_ID1    NUMBER
30          ,p_SOURCE_ENTITY_ID2    NUMBER
31          ,p_SOURCE_ENTITY_TYPE_CODE    VARCHAR2
32          ,p_MSG_TYPE_CODE    VARCHAR2
33          ,p_MSG    VARCHAR2
34          ,p_MSG_STATUS    VARCHAR2
35          ,p_CREATED_BY    NUMBER
36          ,p_CREATION_DATE    DATE
37          ,p_LAST_UPDATED_BY    NUMBER
38          ,p_LAST_UPDATE_DATE    DATE
39          ,p_LAST_UPDATE_LOGIN    NUMBER
40          ,p_OBJECT_VERSION_NUMBER    NUMBER);
41 
42 PROCEDURE Lock_Row(
43           p_GENERIC_ERRMSGS_ID    NUMBER
44          ,p_MODULE_CODE    VARCHAR2
45          ,p_SOURCE_ENTITY_ID1    NUMBER
46          ,p_SOURCE_ENTITY_ID2    NUMBER
47          ,p_SOURCE_ENTITY_TYPE_CODE    VARCHAR2
48          ,p_MSG_TYPE_CODE    VARCHAR2
49          ,p_MSG    VARCHAR2
50          ,p_MSG_STATUS    VARCHAR2
51          ,p_CREATED_BY    NUMBER
52          ,p_CREATION_DATE    DATE
53          ,p_LAST_UPDATED_BY    NUMBER
54          ,p_LAST_UPDATE_DATE    DATE
55          ,p_LAST_UPDATE_LOGIN    NUMBER
56          ,p_OBJECT_VERSION_NUMBER    NUMBER);
57 
58 PROCEDURE Delete_Row(
59     p_GENERIC_ERRMSGS_ID  NUMBER);
60 End CSD_GENERIC_ERRMSGS_PKG;