[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;