APPS.CE_FORECAST_HEADERS_PKG dependencies on CE_FORECAST_COLUMNS

Line 196: CE_FORECAST_COLUMNS_PKG.insert_row(

192: end if;
193: CLOSE C;
194:
195: IF(X_overdue_transactions = 'INCLUDE')THEN
196: CE_FORECAST_COLUMNS_PKG.insert_row(
197: X_rowid => p_row_id,
198: X_forecast_column_id => p_forecast_column_id,
199: X_forecast_header_id => X_forecast_header_id,
200: X_column_number => 0,

Line 461: CE_FORECAST_COLUMNS_PKG.insert_row(

457: -- new column for overdue transactions in column table
458: --
459: IF(p_overdue_transactions = 'EXCLUDE' AND
460: X_overdue_transactions = 'INCLUDE')THEN
461: CE_FORECAST_COLUMNS_PKG.insert_row(
462: X_rowid => p_row_id,
463: X_forecast_column_id => p_forecast_column_id,
464: X_forecast_header_id => X_forecast_header_id,
465: X_column_number => 0,

Line 498: UPDATE CE_FORECAST_COLUMNS

494: --
495: IF(p_overdue_transactions = 'INCLUDE' AND
496: X_overdue_transactions = 'INCLUDE' AND
497: p_cutoff_period <> X_cutoff_period) THEN
498: UPDATE CE_FORECAST_COLUMNS
499: SET days_from = -X_cutoff_period+1
500: WHERE forecast_header_id = X_forecast_header_id
501: AND column_number = 0
502: AND developer_column_num = 0;

Line 511: DELETE FROM CE_FORECAST_COLUMNS

507: -- the overdue column from the column table
508: --
509: IF(p_overdue_transactions = 'INCLUDE' AND
510: X_overdue_transactions = 'EXCLUDE')THEN
511: DELETE FROM CE_FORECAST_COLUMNS
512: WHERE forecast_header_id = X_forecast_header_id
513: AND column_number = 0
514: AND developer_column_num = 0;
515: IF(SQL%NOTFOUND)THEN

Line 547: DELETE FROM CE_FORECAST_COLUMNS

543:
544: DELETE FROM CE_FORECAST_ROWS
545: WHERE forecast_header_id = p_forecast_header_id;
546:
547: DELETE FROM CE_FORECAST_COLUMNS
548: WHERE forecast_header_id = p_forecast_header_id;
549:
550: DELETE FROM ce_forecast_headers
551: WHERE rowid = X_rowid;