APPS.CE_FORECAST_COLUMNS_PKG SQL Statements

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

Line: 43

		SELECT 'Duplicate'
		FROM ce_forecast_columns cfc
		WHERE cfc.forecast_header_id = X_forecast_header_id
	 	AND   cfc.column_number = X_column_number
		AND  (X_rowid IS NULL
		   OR cfc.rowid <> chartorowid(X_rowid));

Line: 87

		SELECT 'Duplicate'
		FROM ce_forecast_columns cfc
		WHERE cfc.forecast_header_id = X_forecast_header_id
	 	AND   cfc.days_from = X_days_from
		AND   cfc.days_to = X_days_to
		AND  (X_rowid IS NULL
		   OR cfc.rowid <> chartorowid(X_rowid));

Line: 127

  PROCEDURE Insert_Row(
		X_rowid			IN OUT NOCOPY	VARCHAR2,
		X_forecast_column_id	IN OUT NOCOPY	NUMBER,
		X_forecast_header_id		NUMBER,
		X_column_number			NUMBER,
		X_days_from			NUMBER,
		X_days_to			NUMBER,
		X_developer_column_num		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 C IS SELECT rowid FROM ce_forecast_columns
			WHERE forecast_column_id = TO_NUMBER(X_forecast_column_id);

Line: 159

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

Line: 165

		INSERT INTO ce_forecast_columns(
			forecast_column_id,
			forecast_header_id,
			column_number,
			days_from,
			days_to,
			developer_column_num,
			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_column_id,
			X_forecast_header_id,
			X_column_number,
			X_days_from,
			X_days_to,
			X_developer_column_num,
			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: 229

	END Insert_Row;

Line: 252

		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 C IS
			SELECT *
			FROM ce_forecast_columns
			WHERE rowid = X_rowid
			FOR UPDATE of forecast_column_id NOWAIT;

Line: 283

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

Line: 363

  PROCEDURE Update_Row(
		X_rowid				VARCHAR2,
		X_forecast_column_id		NUMBER,
		X_forecast_header_id		NUMBER,
		X_column_number			NUMBER,
		X_days_from			NUMBER,
		X_days_to			NUMBER,
		X_developer_column_num		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
  BEGIN
	UPDATE ce_forecast_columns
	SET
		forecast_column_id	= X_forecast_column_id,
		forecast_header_id 	= X_forecast_header_id,
		column_number		= X_column_number,
		days_from		= X_days_from,
		days_to			= X_days_to,
		developer_column_num	= X_developer_column_num,
		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: 422

  END Update_Row;

Line: 435

  PROCEDURE Delete_Row(X_rowid VARCHAR2) IS
  BEGIN
	DELETE FROM ce_forecast_columns
	WHERE rowid = X_rowid;

Line: 442

  END Delete_Row;

Line: 444

  PROCEDURE Delete_Forecast_Cells(X_rowid VARCHAR2) IS
        p_forecast_header_id    NUMBER;

Line: 451

        SELECT     forecast_header_id, forecast_column_id
        INTO       p_forecast_header_id, p_forecast_column_id
        FROM       CE_FORECAST_COLUMNS
        WHERE      rowid = X_rowid;

Line: 456

        DELETE FROM CE_FORECAST_CELLS
        WHERE       forecast_header_id = p_forecast_header_id AND
                    forecast_column_id    = p_forecast_column_id;

Line: 460

  END Delete_Forecast_Cells;