APPS.CE_FORECASTS_PKG dependencies on CE_FORECAST_CELLS

Line 144: CE_FORECAST_CELLS_PKG.insert_row(

140: for ccount in 1..num_cols loop
141: fetch cc into cid;
142: cell_id := null;
143: p_rowid := null;
144: CE_FORECAST_CELLS_PKG.insert_row(
145: X_Rowid => p_rowid,
146: X_forecast_cell_id => cell_id,
147: X_forecast_id => X_forecast_id,
148: X_forecast_header_id => X_forecast_header_id,

Line 170: CE_FORECAST_CELLS_PKG.insert_row(

166: open cc;
167: for ccount in 1..num_cols loop
168: fetch cc into cid;
169: cell_id := null;
170: CE_FORECAST_CELLS_PKG.insert_row(
171: X_Rowid => p_rowid,
172: X_forecast_cell_id => cell_id,
173: X_forecast_id => X_forecast_id,
174: X_forecast_header_id => X_forecast_header_id,

Line 308: from ce_forecast_cells

304: row_number = p_line_number;
305:
306: select amount
307: into p_amount
308: from ce_forecast_cells
309: where forecast_header_id = X_forecast_header_id and
310: forecast_column_id = p_last_column_id and
311: forecast_row_id = p_forecast_row_id;
312:

Line 315: from ce_Forecast_cells

311: forecast_row_id = p_forecast_row_id;
312:
313: select forecast_cell_id
314: into p_forecast_cell_id
315: from ce_Forecast_cells
316: where forecast_header_id = X_forecast_header_id and
317: forecast_column_id = X_forecast_column_id and
318: forecast_row_id = p_forecast_row_id;
319:

Line 320: CE_FORECAST_CELLS_PKG.update_row(

316: where forecast_header_id = X_forecast_header_id and
317: forecast_column_id = X_forecast_column_id and
318: forecast_row_id = p_forecast_row_id;
319:
320: CE_FORECAST_CELLS_PKG.update_row(
321: X_CELLID => p_forecast_cell_id,
322: X_AMOUNT => p_amount,
323: X_LAST_UPDATED_BY => X_last_updated_by,
324: X_LAST_UPDATE_DATE => X_last_update_date,

Line 492: from ce_forecast_cells

488: from ce_forecasts
489: where forecast_header_id = X_header_id;
490: cursor cr(ffid number) is
491: select distinct(forecast_row_id)
492: from ce_forecast_cells
493: where forecast_id = ffid;
494: cursor cc is select forecast_column_id
495: from ce_forecast_columns
496: where forecast_header_id = X_header_id;

Line 529: CE_FORECAST_CELLS_PKG.insert_row(

525: fetch cc into cid;
526: EXIT WHEN cc%NOTFOUND or cc%NOTFOUND IS NULL;
527: end if;
528: cell_id := null;
529: CE_FORECAST_CELLS_PKG.insert_row(
530: X_Rowid => p_rowid,
531: X_forecast_cell_id => cell_id,
532: X_forecast_id => fid,
533: X_forecast_header_id => X_header_id,

Line 672: UPDATE CE_FORECAST_CELLS

668:
669: --
670: -- Update forecast and forecast cells with new forecast_header_id
671: --
672: UPDATE CE_FORECAST_CELLS
673: SET forecast_header_id = p_forecast_header_id
674: WHERE forecast_id = X_forecast_id;
675:
676: UPDATE CE_FORECASTS

Line 719: UPDATE CE_FORECAST_CELLS

715: X_attribute13 => ColInfo.attribute13,
716: X_attribute14 => ColInfo.attribute14,
717: X_attribute15 => ColInfo.attribute15);
718:
719: UPDATE CE_FORECAST_CELLS
720: SET forecast_column_id = cid
721: WHERE forecast_id = X_forecast_id AND
722: forecast_column_id = ColInfo.forecast_column_id;
723:

Line 824: UPDATE CE_FORECAST_CELLS

820: X_period => RowInfo.period,
821: X_order_type_id => RowInfo.order_type_id,
822: X_use_payment_terms => RowInfo.use_payment_terms);
823:
824: UPDATE CE_FORECAST_CELLS
825: SET forecast_row_id = rid
826: WHERE forecast_id = X_forecast_id AND
827: forecast_row_id = RowInfo.forecast_row_id;
828: