APPS.CE_FORECAST_UTILS dependencies on CE_FORECAST_CELLS

Line 140: | from CE_FORECAST_CELLS, CE_FORECAST_TRX_CELLS and |

136: | Delete_Forecast_Children |
137: | |
138: | DESCRIPTION |
139: | This procedure deletes all children of a particular forecast |
140: | from CE_FORECAST_CELLS, CE_FORECAST_TRX_CELLS and |
141: | CE_FORECAST_OPENING_BAL tables. |
142: | |
143: | CALLED BY |
144: | OA Controller Classes |

Line 156: from ce_forecast_cells

152: l_count NUMBER;
153: BEGIN
154: select count(1)
155: into l_count
156: from ce_forecast_cells
157: where forecast_id = X_forecast_id;
158:
159: if l_count > 0 then
160: delete from ce_forecast_cells where forecast_id = X_forecast_id;

Line 160: delete from ce_forecast_cells where forecast_id = X_forecast_id;

156: from ce_forecast_cells
157: where forecast_id = X_forecast_id;
158:
159: if l_count > 0 then
160: delete from ce_forecast_cells where forecast_id = X_forecast_id;
161: end if;
162:
163: select count(1)
164: into l_count

Line 217: from ce_forecast_cells

213: FROM ce_forecast_rows
214: WHERE forecast_header_id = X_forecast_header_id
215: AND forecast_row_id not in
216: (select forecast_row_id
217: from ce_forecast_cells
218: where forecast_header_id = X_forecast_header_id
219: and forecast_id = p_forecast_id);
220: CURSOR C_frow_trx(p_forecast_id NUMBER) IS SELECT forecast_row_id
221: FROM ce_forecast_rows

Line 243: FROM ce_forecast_cells

239:
240: FOR p_fc IN C_fc LOOP
241: SELECT count(1)
242: INTO l_count
243: FROM ce_forecast_cells
244: WHERE forecast_id = p_fc.forecast_id;
245: IF l_count > 0 THEN
246: FOR p_frow IN C_frow(p_fc.forecast_id) LOOP
247: forecast_cell_id := NULL;

Line 249: CE_FORECAST_CELLS_PKG.insert_row(

245: IF l_count > 0 THEN
246: FOR p_frow IN C_frow(p_fc.forecast_id) LOOP
247: forecast_cell_id := NULL;
248: forecast_rowid := NULL;
249: CE_FORECAST_CELLS_PKG.insert_row(
250: X_rowid =>forecast_rowid,
251: X_FORECAST_CELL_ID =>forecast_cell_id,
252: X_FORECAST_ID =>p_fc.forecast_id,
253: X_FORECAST_HEADER_ID =>X_forecast_header_id,

Line 572: UPDATE ce_forecast_cells

568: UPDATE ce_forecast_trx_cells
569: SET forecast_header_id = l_forecast_header_id
570: WHERE forecast_id = X_forecast_id;
571: else
572: UPDATE ce_forecast_cells
573: SET forecast_header_id = l_forecast_header_id
574: WHERE forecast_id = X_forecast_id;
575: end if;
576: end if;

Line 761: update ce_forecast_cells

757: set forecast_row_id = l_forecast_row_id
758: where forecast_row_id = p_frow.forecast_row_id
759: and forecast_id = X_forecast_id;
760: else
761: update ce_forecast_cells
762: set forecast_row_id = l_forecast_row_id
763: where forecast_row_id = p_frow.forecast_row_id
764: and forecast_id = X_forecast_id;
765: end if;

Line 837: update ce_forecast_cells

833: set forecast_column_id = l_forecast_column_id
834: where forecast_column_id = p_fcol.forecast_column_id
835: and forecast_id = X_forecast_id;
836: else
837: update ce_forecast_cells
838: set forecast_column_id = l_forecast_column_id
839: where forecast_column_id = p_fcol.forecast_column_id
840: and forecast_id = X_forecast_id;
841: end if;