APPS.CE_FORECAST_UTILS dependencies on CE_FORECAST_TRX_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 165: from ce_forecast_trx_cells

161: end if;
162:
163: select count(1)
164: into l_count
165: from ce_forecast_trx_cells
166: where forecast_id = X_forecast_id;
167:
168: if l_count > 0 then
169: delete from ce_forecast_trx_cells where forecast_id = X_forecast_id;

Line 169: delete from ce_forecast_trx_cells where forecast_id = X_forecast_id;

165: from ce_forecast_trx_cells
166: where forecast_id = X_forecast_id;
167:
168: if l_count > 0 then
169: delete from ce_forecast_trx_cells where forecast_id = X_forecast_id;
170: end if;
171:
172: select count(1)
173: into l_count

Line 225: from ce_forecast_trx_cells

221: FROM ce_forecast_rows
222: WHERE forecast_header_id = X_forecast_header_id
223: AND forecast_row_id not in
224: (select forecast_row_id
225: from ce_forecast_trx_cells
226: where forecast_header_id = X_forecast_header_id
227: and forecast_id = p_forecast_id);
228:
229: forecast_rowid VARCHAR2(30);

Line 267: FROM ce_forecast_trx_cells

263: END IF;
264:
265: SELECT count(1)
266: INTO l_count
267: FROM ce_forecast_trx_cells
268: WHERE forecast_id = p_fc.forecast_id;
269: IF l_count > 0 THEN
270: FOR p_frow_trx IN C_frow_trx(p_fc.forecast_id) LOOP
271: forecast_cell_id := NULL;

Line 273: CE_FORECAST_TRX_CELLS_PKG.insert_row(

269: IF l_count > 0 THEN
270: FOR p_frow_trx IN C_frow_trx(p_fc.forecast_id) LOOP
271: forecast_cell_id := NULL;
272: forecast_rowid := NULL;
273: CE_FORECAST_TRX_CELLS_PKG.insert_row(
274: X_rowid =>forecast_rowid,
275: X_FORECAST_CELL_ID =>forecast_cell_id,
276: X_FORECAST_ID =>p_fc.forecast_id,
277: X_FORECAST_HEADER_ID =>X_forecast_header_id,

Line 568: UPDATE ce_forecast_trx_cells

564: SET forecast_header_id = l_forecast_header_id
565: WHERE forecast_id = X_forecast_id;
566:
567: if l_drilldown_flag = 'Y' then
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

Line 756: update ce_forecast_trx_cells

752: p_frow.use_payment_terms);
753:
754: if X_forecast_id is not null then
755: if l_drilldown_flag = 'Y' then
756: update ce_forecast_trx_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

Line 832: update ce_forecast_trx_cells

828: p_fcol.attribute15);
829:
830: if X_forecast_id is not null then
831: if l_drilldown_flag = 'Y' then
832: update ce_forecast_trx_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