APPS.CSP_CURR_SUP_DEM_SUMS_PKG dependencies on CSP_CURR_SUP_DEM_SUMS

Line 1: PACKAGE BODY CSP_CURR_SUP_DEM_SUMS_PKG as

1: PACKAGE BODY CSP_CURR_SUP_DEM_SUMS_PKG as
2: /* $Header: csptpsdb.pls 115.6 2002/11/26 07:32:16 hhaugeru ship $ */
3: -- Start of Comments
4: -- Package name : CSP_CURR_SUP_DEM_SUMS_PKG
5: -- Purpose :

Line 4: -- Package name : CSP_CURR_SUP_DEM_SUMS_PKG

1: PACKAGE BODY CSP_CURR_SUP_DEM_SUMS_PKG as
2: /* $Header: csptpsdb.pls 115.6 2002/11/26 07:32:16 hhaugeru ship $ */
3: -- Start of Comments
4: -- Package name : CSP_CURR_SUP_DEM_SUMS_PKG
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

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

7: -- NOTE :
8: -- End of Comments
9:
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSP_CURR_SUP_DEM_SUMS_PKG';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csptpsdb.pls';
13:
14:
15: PROCEDURE Insert_Row(

Line 61: CURSOR C2 IS SELECT CSP_CURR_SUP_DEM_SUMS_S1.nextval FROM sys.dual;

57: p_ATTRIBUTE14 VARCHAR2,
58: p_ATTRIBUTE15 VARCHAR2)
59:
60: IS
61: CURSOR C2 IS SELECT CSP_CURR_SUP_DEM_SUMS_S1.nextval FROM sys.dual;
62: BEGIN
63: If (px_SUPPLY_DEMAND_ID IS NULL) OR (px_SUPPLY_DEMAND_ID = FND_API.G_MISS_NUM) then
64: OPEN C2;
65: FETCH C2 INTO px_SUPPLY_DEMAND_ID;

Line 68: INSERT INTO CSP_CURR_SUP_DEM_SUMS(

64: OPEN C2;
65: FETCH C2 INTO px_SUPPLY_DEMAND_ID;
66: CLOSE C2;
67: End If;
68: INSERT INTO CSP_CURR_SUP_DEM_SUMS(
69: SUPPLY_DEMAND_ID,
70: CREATED_BY,
71: CREATION_DATE,
72: LAST_UPDATED_BY,

Line 205: Update CSP_CURR_SUP_DEM_SUMS

201: p_ATTRIBUTE15 VARCHAR2)
202:
203: IS
204: BEGIN
205: Update CSP_CURR_SUP_DEM_SUMS
206: SET
207: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
208: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
209: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),

Line 260: DELETE FROM CSP_CURR_SUP_DEM_SUMS

256: PROCEDURE Delete_Row(
257: p_SUPPLY_DEMAND_ID NUMBER)
258: IS
259: BEGIN
260: DELETE FROM CSP_CURR_SUP_DEM_SUMS
261: WHERE SUPPLY_DEMAND_ID = p_SUPPLY_DEMAND_ID;
262: If (SQL%NOTFOUND) then
263: RAISE NO_DATA_FOUND;
264: End If;

Line 315: FROM CSP_CURR_SUP_DEM_SUMS

311:
312: IS
313: CURSOR C IS
314: SELECT *
315: FROM CSP_CURR_SUP_DEM_SUMS
316: WHERE SUPPLY_DEMAND_ID = p_SUPPLY_DEMAND_ID
317: FOR UPDATE of SUPPLY_DEMAND_ID NOWAIT;
318: Recinfo C%ROWTYPE;
319: BEGIN

Line 465: End CSP_CURR_SUP_DEM_SUMS_PKG;

461: End If;
462: END Lock_Row;
463:
464:
465: End CSP_CURR_SUP_DEM_SUMS_PKG;