APPS.CE_FC_EXT_VIEWS_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_external_source_type		VARCHAR2,
			X_external_source_view		VARCHAR2,
			X_db_link_name			VARCHAR2,
			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_EXT_VIEWS
		WHERE external_source_type = X_external_source_type;

Line: 31

  INSERT INTO CE_FORECAST_EXT_VIEWS (
			external_source_type,
			external_source_view,
			db_link_name,
			created_by,
			creation_date,
			last_updated_by,
			last_update_date,
			last_update_login)
		VALUES
		(	X_external_source_type,
			X_external_source_view,
			X_db_link_name,
			X_created_by,
 			X_creation_date,
 			X_last_updated_by,
 			X_last_update_date,
 			X_last_update_login);

Line: 57

  END Insert_Row;

Line: 60

  PROCEDURE Update_Row(	X_Rowid				VARCHAR2,
			X_external_source_type		VARCHAR2,
			X_external_source_view		VARCHAR2,
			X_db_link_name			VARCHAR2,
			X_created_by                    NUMBER,
 			X_creation_date                 DATE,
 			X_last_updated_by               NUMBER,
 			X_last_update_date              DATE,
 			X_last_update_login    		NUMBER) IS
  BEGIN
    UPDATE CE_FORECAST_EXT_VIEWS
    SET
	external_source_type	=	X_external_source_type,
	external_source_view	=	X_external_source_view,
	db_link_name		=	X_db_link_name,
	created_by		=	X_created_by,
 	creation_date		= 	X_creation_date,
 	last_updated_by		= 	X_last_updated_by,
 	last_update_date	=	X_last_update_date,
 	last_update_login	=	X_last_update_login
    WHERE	rowid = X_rowid;

Line: 84

  END Update_Row;

Line: 87

  PROCEDURE Delete_Row( X_rowid				VARCHAR2) IS

  BEGIN

    DELETE FROM CE_FORECAST_EXT_VIEWS
    WHERE	rowid = X_rowid;

Line: 97

  END Delete_Row;

Line: 105

 			X_last_updated_by               NUMBER,
 			X_last_update_date              DATE,
 			X_last_update_login    		NUMBER) IS
    CURSOR C IS SELECT *
    FROM CE_FORECAST_EXT_VIEWS
    WHERE rowid = X_rowid
    FOR UPDATE OF external_source_type NOWAIT;

Line: 119

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

Line: 148

	SELECT 'founddup'
        FROM ce_forecast_ext_views cesv
	WHERE cesv.external_source_type = X_external_source_type
	AND  (X_rowid IS NULL
                   OR cesv.rowid <> chartorowid(X_rowid));