APPS.CE_FORECAST_CELLS_PKG dependencies on CE_FORECAST_CELLS

Line 1: PACKAGE BODY CE_FORECAST_CELLS_PKG as

1: PACKAGE BODY CE_FORECAST_CELLS_PKG as
2: /* $Header: cefcellb.pls 120.1 2002/11/12 21:35:02 bhchung ship $ */
3:
4: PROCEDURE Insert_Row( X_Rowid IN OUT NOCOPY VARCHAR2,
5: X_forecast_cell_id IN OUT NOCOPY NUMBER,

Line 17: FROM CE_FORECAST_CELLS

13: X_Last_Updated_By NUMBER,
14: X_Last_Update_Date DATE,
15: X_Last_Update_Login NUMBER) IS
16: CURSOR C1 IS SELECT rowid
17: FROM CE_FORECAST_CELLS
18: WHERE forecast_cell_id = X_forecast_cell_id;
19: CURSOR C2 IS SELECT CE_FORECAST_CELLS_S.nextval FROM sys.dual;
20: BEGIN
21: IF (X_forecast_cell_id IS NULL) THEN

Line 19: CURSOR C2 IS SELECT CE_FORECAST_CELLS_S.nextval FROM sys.dual;

15: X_Last_Update_Login NUMBER) IS
16: CURSOR C1 IS SELECT rowid
17: FROM CE_FORECAST_CELLS
18: WHERE forecast_cell_id = X_forecast_cell_id;
19: CURSOR C2 IS SELECT CE_FORECAST_CELLS_S.nextval FROM sys.dual;
20: BEGIN
21: IF (X_forecast_cell_id IS NULL) THEN
22: OPEN C2;
23: FETCH C2 INTO X_forecast_cell_id;

Line 26: INSERT INTO CE_FORECAST_CELLS(

22: OPEN C2;
23: FETCH C2 INTO X_forecast_cell_id;
24: CLOSE C2;
25: END IF;
26: INSERT INTO CE_FORECAST_CELLS(
27: FORECAST_CELL_ID,
28: FORECAST_ID,
29: FORECAST_HEADER_ID,
30: FORECAST_ROW_ID,

Line 64: UPDATE CE_FORECAST_CELLS

60: X_Last_Updated_By NUMBER,
61: X_Last_Update_Date DATE,
62: X_Last_Update_Login NUMBER) IS
63: BEGIN
64: UPDATE CE_FORECAST_CELLS
65: SET
66: amount = X_amount,
67: last_updated_by = X_last_updated_by,
68: last_update_date = X_last_update_date,

Line 80: DELETE FROM CE_FORECAST_CELLS

76:
77:
78: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
79: BEGIN
80: DELETE FROM CE_FORECAST_CELLS
81: WHERE rowid = X_Rowid;
82:
83: if (SQL%NOTFOUND) then
84: Raise NO_DATA_FOUND;

Line 92: FROM CE_FORECAST_CELLS

88: PROCEDURE Lock_Row( X_forecast_cell_id NUMBER,
89: X_amount NUMBER) IS
90: CURSOR C IS
91: SELECT *
92: FROM CE_FORECAST_CELLS
93: WHERE forecast_cell_id = X_forecast_cell_id
94: FOR UPDATE of forecast_cell_id NOWAIT;
95: Recinfo C%ROWTYPE;
96: BEGIN

Line 116: END CE_FORECAST_CELLS_PKG;

112: END Lock_Row;
113:
114:
115:
116: END CE_FORECAST_CELLS_PKG;