APPS.CSD_SC_DOMAINS_PKG dependencies on CSD_SC_DOMAINS

Line 1: PACKAGE BODY CSD_SC_DOMAINS_PKG as

1: PACKAGE BODY CSD_SC_DOMAINS_PKG as
2: /* $Header: csdtscdb.pls 115.3 2003/11/05 00:18:08 gilam noship $ */
3: -- Start of Comments
4: -- Package name : CSD_SC_DOMAINS_PKG
5: -- Purpose : To insert, update, delete and lock sc domain

Line 4: -- Package name : CSD_SC_DOMAINS_PKG

1: PACKAGE BODY CSD_SC_DOMAINS_PKG as
2: /* $Header: csdtscdb.pls 115.3 2003/11/05 00:18:08 gilam noship $ */
3: -- Start of Comments
4: -- Package name : CSD_SC_DOMAINS_PKG
5: -- Purpose : To insert, update, delete and lock sc domain
6: -- History : 19-Aug-2003 Gilam created
7: -- NOTE :
8: -- End of Comments

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

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

Line 45: CURSOR C2 IS SELECT CSD_SC_DOMAINS_S1.nextval FROM sys.dual;

41: ,p_ATTRIBUTE14 VARCHAR2
42: ,p_ATTRIBUTE15 VARCHAR2)
43:
44: IS
45: CURSOR C2 IS SELECT CSD_SC_DOMAINS_S1.nextval FROM sys.dual;
46: BEGIN
47: If (px_SC_DOMAIN_ID IS NULL) OR (px_SC_DOMAIN_ID = FND_API.G_MISS_NUM) then
48: OPEN C2;
49: FETCH C2 INTO px_SC_DOMAIN_ID;

Line 52: INSERT INTO CSD_SC_DOMAINS(

48: OPEN C2;
49: FETCH C2 INTO px_SC_DOMAIN_ID;
50: CLOSE C2;
51: End If;
52: INSERT INTO CSD_SC_DOMAINS(
53: SC_DOMAIN_ID
54: ,OBJECT_VERSION_NUMBER
55: ,SERVICE_CODE_ID
56: ,INVENTORY_ITEM_ID

Line 144: Update CSD_SC_DOMAINS

140: ,p_ATTRIBUTE15 VARCHAR2)
141:
142: IS
143: BEGIN
144: Update CSD_SC_DOMAINS
145: SET
146: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, NULL, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
147: ,SERVICE_CODE_ID = decode( p_SERVICE_CODE_ID, FND_API.G_MISS_NUM, NULL, NULL, SERVICE_CODE_ID, p_SERVICE_CODE_ID)
148: ,INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, NULL, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID)

Line 184: DELETE FROM CSD_SC_DOMAINS

180: PROCEDURE Delete_Row(
181: p_SC_DOMAIN_ID NUMBER)
182: IS
183: BEGIN
184: DELETE FROM CSD_SC_DOMAINS
185: WHERE SC_DOMAIN_ID = p_SC_DOMAIN_ID;
186: If (SQL%NOTFOUND) then
187: RAISE NO_DATA_FOUND;
188: End If;

Line 230: FROM CSD_SC_DOMAINS

226:
227: IS
228: CURSOR C IS
229: SELECT *
230: FROM CSD_SC_DOMAINS
231: WHERE SC_DOMAIN_ID = p_SC_DOMAIN_ID
232: FOR UPDATE of SC_DOMAIN_ID NOWAIT;
233: Recinfo C%ROWTYPE;
234: BEGIN

Line 339: End CSD_SC_DOMAINS_PKG;

335: APP_EXCEPTION.RAISE_EXCEPTION;
336: End If;
337: END Lock_Row;
338:
339: End CSD_SC_DOMAINS_PKG;