APPS.CE_FORECAST_TRX_CELLS_PKG dependencies on CE_FORECAST_TRX_CELLS

Line 1: PACKAGE BODY CE_FORECAST_TRX_CELLS_PKG as

1: PACKAGE BODY CE_FORECAST_TRX_CELLS_PKG as
2: /* $Header: ceftcelb.pls 120.0 2004/06/21 21:51:38 bhchung ship $ */
3:
4: PROCEDURE Insert_Row( X_Rowid IN OUT NOCOPY VARCHAR2,
5: X_forecast_cell_id IN OUT NOCOPY NUMBER,

Line 25: FROM CE_FORECAST_TRX_CELLS

21: X_Last_Updated_By NUMBER,
22: X_Last_Update_Date DATE,
23: X_Last_Update_Login NUMBER) IS
24: CURSOR C1 IS SELECT rowid
25: FROM CE_FORECAST_TRX_CELLS
26: WHERE forecast_cell_id = X_forecast_cell_id;
27: CURSOR C2 IS SELECT CE_FORECAST_TRX_CELLS_S.nextval FROM sys.dual;
28: BEGIN
29: IF (X_forecast_cell_id IS NULL) THEN

Line 27: CURSOR C2 IS SELECT CE_FORECAST_TRX_CELLS_S.nextval FROM sys.dual;

23: X_Last_Update_Login NUMBER) IS
24: CURSOR C1 IS SELECT rowid
25: FROM CE_FORECAST_TRX_CELLS
26: WHERE forecast_cell_id = X_forecast_cell_id;
27: CURSOR C2 IS SELECT CE_FORECAST_TRX_CELLS_S.nextval FROM sys.dual;
28: BEGIN
29: IF (X_forecast_cell_id IS NULL) THEN
30: OPEN C2;
31: FETCH C2 INTO X_forecast_cell_id;

Line 34: INSERT INTO CE_FORECAST_TRX_CELLS(

30: OPEN C2;
31: FETCH C2 INTO X_forecast_cell_id;
32: CLOSE C2;
33: END IF;
34: INSERT INTO CE_FORECAST_TRX_CELLS(
35: FORECAST_CELL_ID,
36: FORECAST_ID,
37: FORECAST_HEADER_ID,
38: FORECAST_ROW_ID,

Line 88: UPDATE CE_FORECAST_TRX_CELLS

84: X_Last_Updated_By NUMBER,
85: X_Last_Update_Date DATE,
86: X_Last_Update_Login NUMBER) IS
87: BEGIN
88: UPDATE CE_FORECAST_TRX_CELLS
89: SET
90: amount = X_amount,
91: last_updated_by = X_last_updated_by,
92: last_update_date = X_last_update_date,

Line 104: DELETE FROM CE_FORECAST_TRX_CELLS

100:
101:
102: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
103: BEGIN
104: DELETE FROM CE_FORECAST_TRX_CELLS
105: WHERE rowid = X_Rowid;
106:
107: if (SQL%NOTFOUND) then
108: Raise NO_DATA_FOUND;

Line 116: FROM CE_FORECAST_TRX_CELLS

112: PROCEDURE Lock_Row( X_forecast_cell_id NUMBER,
113: X_amount NUMBER) IS
114: CURSOR C IS
115: SELECT *
116: FROM CE_FORECAST_TRX_CELLS
117: WHERE forecast_cell_id = X_forecast_cell_id
118: FOR UPDATE of forecast_cell_id NOWAIT;
119: Recinfo C%ROWTYPE;
120: BEGIN

Line 140: END CE_FORECAST_TRX_CELLS_PKG;

136: END Lock_Row;
137:
138:
139:
140: END CE_FORECAST_TRX_CELLS_PKG;