APPS.CE_FORECAST_ROWS2_PKG dependencies on CE_FORECAST_ROWS

Line 1: PACKAGE BODY CE_FORECAST_ROWS2_PKG AS

1: PACKAGE BODY CE_FORECAST_ROWS2_PKG AS
2: /* $Header: cefrow2b.pls 120.0 2002/08/24 02:36:14 appldev noship $ */
3:
4: --
5: -- Package

Line 6: -- CE_FORECAST_ROWS2_PKG

2: /* $Header: cefrow2b.pls 120.0 2002/08/24 02:36:14 appldev noship $ */
3:
4: --
5: -- Package
6: -- CE_FORECAST_ROWS2_PKG
7: -- Purpose
8: -- To group all the procedures/functions for table handling of the
9: -- ce_forecast_rows table.
10: -- History

Line 9: -- ce_forecast_rows table.

5: -- Package
6: -- CE_FORECAST_ROWS2_PKG
7: -- Purpose
8: -- To group all the procedures/functions for table handling of the
9: -- ce_forecast_rows table.
10: -- History
11: -- 07.10.96 C. Kawamoto Created
12: -- 07.28.97 E. Lau Added org_payment_method_id
13:

Line 32: -- To update ce_forecast_rows with changes made.

28: --
29: -- Procedure
30: -- Update_Row
31: -- Purpose
32: -- To update ce_forecast_rows with changes made.
33: -- History
34: -- 07.10.96 C. Kawamoto Created
35: -- Example
36: -- CE_FORECAST_ROWS2_PKG.Update_Row(...)

Line 36: -- CE_FORECAST_ROWS2_PKG.Update_Row(...)

32: -- To update ce_forecast_rows with changes made.
33: -- History
34: -- 07.10.96 C. Kawamoto Created
35: -- Example
36: -- CE_FORECAST_ROWS2_PKG.Update_Row(...)
37: -- Notes
38: --
39:
40: PROCEDURE Update_Row(

Line 128: UPDATE ce_forecast_rows

124: X_order_type_id NUMBER,
125: X_use_payment_terms VARCHAR2
126: ) IS
127: BEGIN
128: UPDATE ce_forecast_rows
129: SET
130: forecast_row_id = X_forecast_row_id,
131: forecast_header_id = X_forecast_header_id,
132: row_number = X_row_number,

Line 226: -- To delete a row from ce_forecast_rows.

222: --
223: -- Procedure
224: -- Delete_Row
225: -- Purpose
226: -- To delete a row from ce_forecast_rows.
227: -- History
228: -- 07.10.96 C. Kawamoto Created
229: -- Example
230: -- CE_FORECAST_ROWS2_PKG.Delete_Row(...)

Line 230: -- CE_FORECAST_ROWS2_PKG.Delete_Row(...)

226: -- To delete a row from ce_forecast_rows.
227: -- History
228: -- 07.10.96 C. Kawamoto Created
229: -- Example
230: -- CE_FORECAST_ROWS2_PKG.Delete_Row(...)
231: -- Notes
232: --
233:
234: PROCEDURE Delete_Row(X_rowid VARCHAR2) IS

Line 236: DELETE FROM ce_forecast_rows

232: --
233:
234: PROCEDURE Delete_Row(X_rowid VARCHAR2) IS
235: BEGIN
236: DELETE FROM ce_forecast_rows
237: WHERE rowid = X_rowid;
238: if (SQL%NOTFOUND) then
239: Raise NO_DATA_FOUND;
240: end if;

Line 253: FROM CE_FORECAST_ROWS

249: -- delete all forecast cells that belong to the template row
250: --
251: SELECT forecast_header_id, forecast_row_id
252: INTO p_forecast_header_id, p_forecast_row_id
253: FROM CE_FORECAST_ROWS
254: WHERE rowid = X_rowid;
255:
256: DELETE FROM CE_FORECAST_CELLS
257: WHERE forecast_header_id = p_forecast_header_id AND

Line 263: END CE_FORECAST_ROWS2_PKG;

259:
260: END Delete_Forecast_Cells;
261:
262:
263: END CE_FORECAST_ROWS2_PKG;