APPS.CE_FORECASTS_TABLE_PKG SQL Statements

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

Line: 17

  PROCEDURE Insert_Row( X_Rowid			IN OUT NOCOPY	VARCHAR2,
			X_forecast_id		IN OUT NOCOPY	NUMBER,
			X_forecast_header_id		NUMBER,
			X_name				VARCHAR2,
                        X_description			VARCHAR2,
			X_start_date			DATE,
			X_period_set_name		VARCHAR2,
			X_start_period			VARCHAR2,
			X_forecast_currency		VARCHAR2,
			X_currency_type			VARCHAR2,
			X_source_currency		VARCHAR2,
			X_exchange_rate_type		VARCHAR2,
			X_exchange_date                 DATE,
                        X_exchange_rate                 NUMBER,
			X_error_status			VARCHAR2,
			X_amount_threshold		NUMBER,
			X_project_id			NUMBER,
			X_drilldown_flag		VARCHAR2,
			X_bank_balance_type		VARCHAR2,
			X_float_type			VARCHAR2,
			X_view_by			VARCHAR2,
			X_include_sub_account		VARCHAR2,
			X_factor			NUMBER,
			X_request_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,
			X_attribute_category            VARCHAR2,
			X_attribute1                    VARCHAR2,
			X_attribute2                    VARCHAR2,
			X_attribute3                    VARCHAR2,
			X_attribute4                    VARCHAR2,
			X_attribute5                    VARCHAR2,
			X_attribute6                    VARCHAR2,
			X_attribute7                    VARCHAR2,
			X_attribute8                    VARCHAR2,
			X_attribute9                    VARCHAR2,
			X_attribute10                   VARCHAR2,
			X_attribute11                   VARCHAR2,
			X_attribute12                   VARCHAR2,
			X_attribute13                   VARCHAR2,
			X_attribute14                   VARCHAR2,
			X_attribute15                   VARCHAR2) IS
    CURSOR C1 IS SELECT rowid
		 FROM CE_FORECASTS
		 WHERE forecast_id = X_forecast_id;

Line: 65

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

Line: 72

    INSERT INTO CE_FORECASTS(
			forecast_id,
			forecast_header_id,
			name,
                        description,
			start_date,
			period_set_name,
			start_period,
			forecast_currency,
			currency_type,
			source_currency,
			exchange_rate_type,
			exchange_date,
			exchange_rate,
			error_status,
			amount_threshold,
			project_id,
			drilldown_flag,
			bank_balance_type,
			float_type,
			view_by,
			include_sub_account,
			factor,
			request_id,
			Created_By,
                       	Creation_Date,
                       	Last_Updated_By,
                       	Last_Update_Date,
                       	Last_Update_Login,
			attribute_category,
			attribute1,
			attribute2,
			attribute3,
			attribute4,
			attribute5,
			attribute6,
			attribute7,
			attribute8,
			attribute9,
			attribute10,
			attribute11,
			attribute12,
			attribute13,
			attribute14,
			attribute15)
		 VALUES
		(	X_forecast_id,
			X_forecast_header_id,
			X_name,
                        X_description,
			X_start_date,
			X_period_set_name,
			X_start_period,
			X_forecast_currency,
			X_currency_type,
			X_source_currency,
			X_exchange_rate_type,
			X_exchange_date,
			X_exchange_rate,
			X_error_status,
			X_amount_threshold,
			X_project_id,
			X_drilldown_flag,
			X_bank_balance_type,
			X_float_type,
			X_view_by,
			X_include_sub_account,
			X_factor,
			X_request_id,
			X_Created_By ,
                       	X_Creation_Date,
                       	X_Last_Updated_By,
                       	X_Last_Update_Date,
                       	X_Last_Update_Login,
			X_attribute_category,
			X_attribute1,
			X_attribute2,
			X_attribute3,
			X_attribute4,
			X_attribute5,
			X_attribute6,
			X_attribute7,
			X_attribute8,
			X_attribute9,
			X_attribute10,
			X_attribute11,
			X_attribute12,
			X_attribute13,
			X_attribute14,
			X_attribute15) ;

Line: 169

  END Insert_row;

Line: 171

  PROCEDURE Update_Row( X_rowid				VARCHAR2,
			X_forecast_id			NUMBER,
			X_forecast_header_id		NUMBER,
			X_name				VARCHAR2,
                        X_description			VARCHAR2,
			X_start_date			DATE,
			X_period_set_name			VARCHAR2,
			X_start_period			VARCHAR2,
			X_forecast_currency		VARCHAR2,
			X_currency_type			VARCHAR2,
			X_source_currency		VARCHAR2,
			X_exchange_rate_type		VARCHAR2,
			X_exchange_date                 DATE,
                        X_exchange_rate                 NUMBER,
			X_error_status			VARCHAR2,
			X_amount_threshold		NUMBER,
			X_project_id			NUMBER,
                       	X_Last_Updated_By               NUMBER,
                       	X_Last_Update_Date              DATE,
                       	X_Last_Update_Login             NUMBER,
			X_attribute_category            VARCHAR2,
			X_attribute1                    VARCHAR2,
			X_attribute2                    VARCHAR2,
			X_attribute3                    VARCHAR2,
			X_attribute4                    VARCHAR2,
			X_attribute5                    VARCHAR2,
			X_attribute6                    VARCHAR2,
			X_attribute7                    VARCHAR2,
			X_attribute8                    VARCHAR2,
			X_attribute9                    VARCHAR2,
			X_attribute10                   VARCHAR2,
			X_attribute11                   VARCHAR2,
			X_attribute12                   VARCHAR2,
			X_attribute13                   VARCHAR2,
			X_attribute14                   VARCHAR2,
			X_attribute15                   VARCHAR2) IS
  BEGIN
    UPDATE CE_FORECASTS
    SET
	forecast_id		=	X_forecast_id,
	forecast_header_id	=	X_forecast_header_id,
	name			=	X_name,
        description		=	X_description,
	start_date		=	X_start_date,
	period_set_name		=	X_period_set_name,
	start_period		=	X_start_period,
	forecast_currency	=	X_forecast_currency,
	currency_type		=	X_currency_type,
	source_currency		=	X_source_currency,
	exchange_rate_type	=	X_exchange_rate_type,
	exchange_date		=	X_exchange_date,
	exchange_rate		= 	X_exchange_rate,
	error_status		=	X_error_status,
	amount_threshold	=	X_amount_threshold,
	project_id		= 	X_project_id,
        Last_Updated_By		=	X_Last_Updated_By,
        Last_Update_Date	=	X_Last_Update_Date,
        Last_Update_Login	=	X_Last_Update_Login,
	attribute_category	=	X_attribute_category,
	attribute1		=	X_attribute1,
	attribute2		=	X_attribute2,
	attribute3		=	X_attribute3,
	attribute4		=	X_attribute4,
	attribute5		=	X_attribute5,
	attribute6		=	X_attribute6,
	attribute7		=	X_attribute7,
	attribute8		=	X_attribute8,
	attribute9		=	X_attribute9,
	attribute10		=	X_attribute10,
	attribute11		=	X_attribute11,
	attribute12		=	X_attribute12,
	attribute13		=	X_attribute13,
	attribute14		=	X_attribute14,
	attribute15		=	X_attribute15
    WHERE	rowid = X_rowid;

Line: 250

  END Update_Row;

Line: 253

  PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
    p_forecast_id	NUMBER;

Line: 259

    SELECT	forecast_id
    INTO	p_forecast_id
    FROM	CE_FORECASTS
    WHERE	rowid = X_Rowid;

Line: 264

    DELETE FROM CE_FORECAST_ERRORS
    WHERE	forecast_id = p_forecast_id;

Line: 267

    DELETE FROM CE_FORECAST_CELLS
    WHERE	forecast_id = p_forecast_id;

Line: 270

    DELETE FROM CE_FORECASTS
    WHERE 	rowid = X_Rowid;

Line: 276

  END Delete_Row;

Line: 312

	SELECT 	*
	FROM	CE_FORECASTS
	WHERE	rowid = X_rowid
	FOR UPDATE OF forecast_id NOWAIT;

Line: 322

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