APPS.CE_FORECAST_TRX_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_trx_amount			NUMBER,
			X_reference_id			VARCHAR2,
			X_currency_code			VARCHAR2,
			X_org_id			NUMBER,
			X_include_flag			VARCHAR2,
			X_trx_date			DATE,
			X_bank_account_id		NUMBER,
			X_code_combination_id		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_TRX_CELLS
		 WHERE forecast_cell_id = X_forecast_cell_id;

Line: 27

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

Line: 34

    INSERT INTO CE_FORECAST_TRX_CELLS(
			FORECAST_CELL_ID,
 			FORECAST_ID,
 			FORECAST_HEADER_ID,
 			FORECAST_ROW_ID,
 			FORECAST_COLUMN_ID,
 			AMOUNT,
			TRX_AMOUNT,
			REFERENCE_ID,
			CURRENCY_CODE,
			ORG_ID,
			INCLUDE_FLAG,
			TRX_DATE,
			BANK_ACCOUNT_ID,
			CODE_COMBINATION_ID,
 			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_trx_amount,
			X_reference_id,
			X_currency_code,
			X_org_id,
			X_include_flag,
			X_trx_date,
			X_bank_account_id,
			X_code_combination_id,
			X_created_by,
			X_creation_date,
			X_last_updated_by,
			X_last_update_date,
			X_last_update_login);

Line: 80

  END insert_row;

Line: 82

  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_TRX_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: 99

  END Update_Row;

Line: 102

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

Line: 110

  END Delete_Row;

Line: 115

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

Line: 125

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