APPS.CE_FORECASTS_PKG dependencies on CE_FORECAST_ROWS

Line 50: from ce_forecast_rows

46: X_last_updated_by NUMBER,
47: X_last_update_date DATE,
48: X_last_update_login NUMBER) IS
49: cursor cr is select forecast_row_id, trx_type
50: from ce_forecast_rows
51: where forecast_header_id = X_forecast_header_id
52: order by row_number;
53: cursor cc is select forecast_column_id
54: from ce_forecast_columns

Line 65: trx ce_forecast_rows.trx_type%TYPE;

61: ccount number;
62: num_rows number;
63: num_cols number;
64: p_rowid VARCHAR2(100);
65: trx ce_forecast_rows.trx_type%TYPE;
66: glc_rowid number default 0;
67:
68: BEGIN
69: --

Line 121: from ce_forecast_rows r

117: X_attribute15 => null);
118:
119: select count(r.forecast_row_id)
120: into num_rows
121: from ce_forecast_rows r
122: where r.forecast_header_id = X_forecast_header_id;
123:
124: select count(r.forecast_column_id)
125: into num_cols

Line 208: from ce_forecast_rows

204: X_last_update_login NUMBER,
205: X_forecast_id NUMBER DEFAULT NULL,
206: X_name VARCHAR2 DEFAULT NULL) IS
207: cursor cr is select row_number
208: from ce_forecast_rows
209: where forecast_header_id = X_forecast_header_id
210: and trx_type = 'GLC';
211: p_rowid VARCHAR2(100);
212: p_amount NUMBER;

Line 302: from ce_forecast_rows

298: exit when cr%NOTFOUND;
299:
300: select forecast_row_id
301: into p_forecast_row_id
302: from ce_forecast_rows
303: where forecast_header_id = X_forecast_header_id and
304: row_number = p_line_number;
305:
306: select amount

Line 372: CE_FORECAST_ROWS1_PKG.Insert_Row(

368: X_name => X_name);
369: CE_FORECASTS_PKG.rearrange_column_number(X_forecast_header_id);
370: END IF;
371:
372: CE_FORECAST_ROWS1_PKG.Insert_Row(
373: X_rowid => p_rowid,
374: X_forecast_row_id => X_forecast_row_id,
375: X_forecast_header_id => X_forecast_header_id,
376: X_row_number => X_row_number,

Line 616: FROM CE_FORECAST_ROWS

612: WHERE forecast_header_id = X_forecast_header_id
613: AND developer_column_num <> 0;
614: ColInfo CC%ROWTYPE;
615: CURSOR CR IS SELECT *
616: FROM CE_FORECAST_ROWS
617: WHERE forecast_header_id = X_forecast_header_id;
618: RowInfo CR%ROWTYPE;
619:
620: BEGIN

Line 736: CE_FORECAST_ROWS1_PKG.Insert_Row(

732: fetch CR into RowInfo;
733: WHILE (CR%FOUND) LOOP
734: cep_standard.debug(' - insert row');
735: rid := NULL;
736: CE_FORECAST_ROWS1_PKG.Insert_Row(
737: X_rowid => p_rowid,
738: X_forecast_row_id => rid,
739: X_forecast_header_id => p_forecast_header_id,
740: X_row_number => RowInfo.row_number,

Line 859: l_rownum_from CE_FORECAST_ROWS.row_number%TYPE;

855: l_exchange_date CE_FORECASTS.exchange_date%TYPE;
856: l_exchange_rate CE_FORECASTS.exchange_rate%TYPE;
857: l_src_curr_type CE_FORECASTS.currency_type%TYPE;
858: l_source_currency CE_FORECASTS.source_currency%TYPE;
859: l_rownum_from CE_FORECAST_ROWS.row_number%TYPE;
860: l_rownum_to CE_FORECAST_ROWS.row_number%TYPE;
861: l_amount_threshold CE_FORECASTS.amount_threshold%TYPE;
862: l_project_id CE_FORECASTS.project_id%TYPE;
863:

Line 860: l_rownum_to CE_FORECAST_ROWS.row_number%TYPE;

856: l_exchange_rate CE_FORECASTS.exchange_rate%TYPE;
857: l_src_curr_type CE_FORECASTS.currency_type%TYPE;
858: l_source_currency CE_FORECASTS.source_currency%TYPE;
859: l_rownum_from CE_FORECAST_ROWS.row_number%TYPE;
860: l_rownum_to CE_FORECAST_ROWS.row_number%TYPE;
861: l_amount_threshold CE_FORECASTS.amount_threshold%TYPE;
862: l_project_id CE_FORECASTS.project_id%TYPE;
863:
864: cnt_fc NUMBER;

Line 909: FROM ce_forecast_rows

905: SELECT min(row_number),
906: max(row_number)
907: INTO l_rownum_from,
908: l_rownum_to
909: FROM ce_forecast_rows
910: WHERE forecast_header_id = X_hid;
911:
912: CE_CASH_FCST.set_parameters(X_hid,
913: null,