APPS.CE_FORECAST_CELLS_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 4

  PROCEDURE Insert_Row(	X_Rowid			IN OUT NOCOPY	VARCHAR2,
			X_forecast_cell_id	IN OUT NOCOPY	NUMBER,
			X_forecast_id			NUMBER,
			X_forecast_header_id		NUMBER,
			X_forecast_row_id		NUMBER,
			X_forecast_column_id		NUMBER,
			X_amount			NUMBER,
		        X_Created_By                    NUMBER,
                       	X_Creation_Date                 DATE,
                       	X_Last_Updated_By               NUMBER,
                       	X_Last_Update_Date              DATE,
                       	X_Last_Update_Login             NUMBER) IS
    CURSOR C1 IS SELECT rowid
		 FROM CE_FORECAST_CELLS
		 WHERE forecast_cell_id = X_forecast_cell_id;

Line: 19

    CURSOR C2 IS SELECT CE_FORECAST_CELLS_S.nextval FROM sys.dual;

Line: 26

    INSERT INTO CE_FORECAST_CELLS(
			FORECAST_CELL_ID,
 			FORECAST_ID,
 			FORECAST_HEADER_ID,
 			FORECAST_ROW_ID,
 			FORECAST_COLUMN_ID,
 			AMOUNT,
 			CREATED_BY,
 			CREATION_DATE,
 			LAST_UPDATED_BY,
 			LAST_UPDATE_DATE,
 			LAST_UPDATE_LOGIN ) VALUES
		(	X_forecast_cell_id,
			X_forecast_id,
			X_forecast_header_id,
			X_forecast_row_id,
			X_forecast_column_id,
			X_amount,
			X_created_by,
			X_creation_date,
			X_last_updated_by,
			X_last_update_date,
			X_last_update_login);

Line: 56

  END insert_row;

Line: 58

  PROCEDURE Update_Row(	X_cellid			NUMBER,
			X_amount			NUMBER,
                       	X_Last_Updated_By               NUMBER,
                       	X_Last_Update_Date              DATE,
                       	X_Last_Update_Login             NUMBER) IS
  BEGIN
    UPDATE CE_FORECAST_CELLS
    SET
	amount			= X_amount,
	last_updated_by		= X_last_updated_by,
	last_update_date	= X_last_update_date,
	last_update_login	= X_last_update_login
    WHERE forecast_cell_id = X_cellid;

Line: 75

  END Update_Row;

Line: 78

  PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
  BEGIN
    DELETE FROM CE_FORECAST_CELLS
    WHERE rowid = X_Rowid;

Line: 86

  END Delete_Row;

Line: 91

	SELECT	*
	FROM	CE_FORECAST_CELLS
	WHERE 	forecast_cell_id = X_forecast_cell_id
	FOR UPDATE of forecast_cell_id NOWAIT;

Line: 101

      FND_MESSAGE.set_name('FND', 'FORM_RECORD_DELETED');