APPS.CSD_GENERIC_ERRMSGS_PKG dependencies on CSD_GENERIC_ERRMSGS

Line 1: PACKAGE BODY CSD_GENERIC_ERRMSGS_PKG as

1: PACKAGE BODY CSD_GENERIC_ERRMSGS_PKG as
2: /* $Header: csdtgemb.pls 115.1 2003/09/09 19:01:28 vparvath noship $ */
3: -- Start of Comments
4: -- Package name : CSD_GENERIC_ERRMSGS_PKG
5: -- Purpose :

Line 4: -- Package name : CSD_GENERIC_ERRMSGS_PKG

1: PACKAGE BODY CSD_GENERIC_ERRMSGS_PKG as
2: /* $Header: csdtgemb.pls 115.1 2003/09/09 19:01:28 vparvath noship $ */
3: -- Start of Comments
4: -- Package name : CSD_GENERIC_ERRMSGS_PKG
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

Line 11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSD_GENERIC_ERRMSGS_PKG';

7: -- NOTE :
8: -- End of Comments
9:
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSD_GENERIC_ERRMSGS_PKG';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csdtgemb.pls';
13:
14: PROCEDURE Insert_Row(
15: px_GENERIC_ERRMSGS_ID IN OUT NOCOPY NUMBER

Line 31: CURSOR C2 IS SELECT CSD_GENERIC_ERRMSGS_S1.nextval FROM sys.dual;

27: ,p_LAST_UPDATE_LOGIN NUMBER
28: ,p_OBJECT_VERSION_NUMBER NUMBER)
29:
30: IS
31: CURSOR C2 IS SELECT CSD_GENERIC_ERRMSGS_S1.nextval FROM sys.dual;
32: BEGIN
33: If (px_GENERIC_ERRMSGS_ID IS NULL) OR (px_GENERIC_ERRMSGS_ID = FND_API.G_MISS_NUM) then
34: OPEN C2;
35: FETCH C2 INTO px_GENERIC_ERRMSGS_ID;

Line 38: INSERT INTO CSD_GENERIC_ERRMSGS(

34: OPEN C2;
35: FETCH C2 INTO px_GENERIC_ERRMSGS_ID;
36: CLOSE C2;
37: End If;
38: INSERT INTO CSD_GENERIC_ERRMSGS(
39: GENERIC_ERRMSGS_ID
40: ,MODULE_CODE
41: ,SOURCE_ENTITY_ID1
42: ,SOURCE_ENTITY_ID2

Line 88: Update CSD_GENERIC_ERRMSGS

84: ,p_OBJECT_VERSION_NUMBER NUMBER)
85:
86: IS
87: BEGIN
88: Update CSD_GENERIC_ERRMSGS
89: SET
90: MODULE_CODE = decode( p_MODULE_CODE, FND_API.G_MISS_CHAR,NULL,NULL, MODULE_CODE, p_MODULE_CODE)
91: ,SOURCE_ENTITY_ID1 = decode( p_SOURCE_ENTITY_ID1, FND_API.G_MISS_NUM,NULL,NULL, SOURCE_ENTITY_ID1, p_SOURCE_ENTITY_ID1)
92: ,SOURCE_ENTITY_ID2 = decode( p_SOURCE_ENTITY_ID2, FND_API.G_MISS_NUM,NULL,NULL, SOURCE_ENTITY_ID2, p_SOURCE_ENTITY_ID2)

Line 114: DELETE FROM CSD_GENERIC_ERRMSGS

110: PROCEDURE Delete_Row(
111: p_GENERIC_ERRMSGS_ID NUMBER)
112: IS
113: BEGIN
114: DELETE FROM CSD_GENERIC_ERRMSGS
115: WHERE GENERIC_ERRMSGS_ID = p_GENERIC_ERRMSGS_ID;
116: If (SQL%NOTFOUND) then
117: RAISE NO_DATA_FOUND;
118: End If;

Line 140: FROM CSD_GENERIC_ERRMSGS

136:
137: IS
138: CURSOR C IS
139: SELECT *
140: FROM CSD_GENERIC_ERRMSGS
141: WHERE GENERIC_ERRMSGS_ID = p_GENERIC_ERRMSGS_ID
142: FOR UPDATE of GENERIC_ERRMSGS_ID NOWAIT;
143: Recinfo C%ROWTYPE;
144: BEGIN

Line 202: End CSD_GENERIC_ERRMSGS_PKG;

198: APP_EXCEPTION.RAISE_EXCEPTION;
199: End If;
200: END Lock_Row;
201:
202: End CSD_GENERIC_ERRMSGS_PKG;