APPS.CSP_POPULATION_CHANGES_PKG dependencies on CSP_POPULATION_CHANGES

Line 1: PACKAGE BODY CSP_POPULATION_CHANGES_PKG as

1: PACKAGE BODY CSP_POPULATION_CHANGES_PKG as
2: /* $Header: csptppcb.pls 120.2 2005/12/16 10:36:39 phegde noship $ */
3: -- Start of Comments
4: -- Package name : CSP_POPULATION_CHANGES_PKG
5: -- Purpose :

Line 4: -- Package name : CSP_POPULATION_CHANGES_PKG

1: PACKAGE BODY CSP_POPULATION_CHANGES_PKG as
2: /* $Header: csptppcb.pls 120.2 2005/12/16 10:36:39 phegde noship $ */
3: -- Start of Comments
4: -- Package name : CSP_POPULATION_CHANGES_PKG
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

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

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

Line 29: CURSOR C2 IS SELECT CSP_POPULATION_CHANGES_S1.nextval FROM sys.dual;

25: p_LAST_UPDATE_LOGIN NUMBER,
26: p_PRODUCT_ID NUMBER )
27:
28: IS
29: CURSOR C2 IS SELECT CSP_POPULATION_CHANGES_S1.nextval FROM sys.dual;
30: BEGIN
31: If (px_POPULATION_CHANGES_ID IS NULL) OR (px_POPULATION_CHANGES_ID = FND_API.G_MISS_NUM) then
32: OPEN C2;
33: FETCH C2 INTO px_POPULATION_CHANGES_ID;

Line 36: INSERT INTO CSP_POPULATION_CHANGES(

32: OPEN C2;
33: FETCH C2 INTO px_POPULATION_CHANGES_ID;
34: CLOSE C2;
35: End If;
36: INSERT INTO CSP_POPULATION_CHANGES(
37: POPULATION_CHANGES_ID,
38: ORGANIZATION_ID,
39: --INVENTORY_ITEM_ID,
40: START_DATE,

Line 80: Update CSP_POPULATION_CHANGES

76: p_PRODUCT_ID NUMBER )
77:
78: IS
79: BEGIN
80: Update CSP_POPULATION_CHANGES
81: SET
82: ORGANIZATION_ID = decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, p_ORGANIZATION_ID),
83: --INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID),
84: START_DATE = decode(p_START_DATE, fnd_api.g_miss_date,start_date,p_start_date),

Line 104: DELETE FROM CSP_POPULATION_CHANGES

100: PROCEDURE Delete_Row(
101: p_POPULATION_CHANGES_ID NUMBER)
102: IS
103: BEGIN
104: DELETE FROM CSP_POPULATION_CHANGES
105: WHERE POPULATION_CHANGES_ID = p_POPULATION_CHANGES_ID;
106: If (SQL%NOTFOUND) then
107: RAISE NO_DATA_FOUND;
108: End If;

Line 128: FROM CSP_POPULATION_CHANGES

124:
125: IS
126: CURSOR C IS
127: SELECT *
128: FROM CSP_POPULATION_CHANGES
129: WHERE POPULATION_CHANGES_ID = p_POPULATION_CHANGES_ID
130: FOR UPDATE of POPULATION_CHANGES_ID NOWAIT;
131: Recinfo C%ROWTYPE;
132: BEGIN

Line 184: End CSP_POPULATION_CHANGES_PKG;

180: APP_EXCEPTION.RAISE_EXCEPTION;
181: End If;
182: END Lock_Row;
183:
184: End CSP_POPULATION_CHANGES_PKG;