APPS.CE_BANK_STMT_LDR_PKG SQL Statements

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

Line: 4

PROCEDURE Map_Insert_Row(
 X_ROW_ID			IN OUT NOCOPY      VARCHAR2,
 X_MAP_ID                       IN OUT NOCOPY      NUMBER,
 X_FORMAT_NAME                              VARCHAR2,
 X_DESCRIPTION				    VARCHAR2,
 X_FORMAT_TYPE                              VARCHAR2,
 X_CONTROL_FILE_NAME                        VARCHAR2,
 X_ENABLED                                  VARCHAR2,
 X_PRECISION				    NUMBER,
 X_DATE_FORMAT				    VARCHAR2,
 X_TIMESTAMP_FORMAT			    VARCHAR2,
 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_map_id IS
   SELECT 	CE_BANK_STMT_INT_MAP_S.nextval
   FROM		sys.dual;

Line: 42

   SELECT 	rowid
   FROM 	ce_bank_stmt_int_map
   WHERE 	map_id = TO_NUMBER(X_MAP_ID);

Line: 51

  INSERT INTO ce_bank_stmt_int_map(
	MAP_ID,
   	FORMAT_NAME,
	DESCRIPTION,
   	FORMAT_TYPE,
   	CONTROL_FILE_NAME,
	ENABLED,
	PRECISION,
 	DATE_FORMAT,
 	TIMESTAMP_FORMAT,
	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_MAP_ID,
   	X_FORMAT_NAME,
	X_DESCRIPTION,
   	X_FORMAT_TYPE,
   	X_CONTROL_FILE_NAME,
	X_ENABLED,
	X_PRECISION,
	X_DATE_FORMAT,
 	X_TIMESTAMP_FORMAT,
	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: 122

END Map_Insert_Row;

Line: 124

PROCEDURE Map_Update_Row(
 X_ROW_ID				    VARCHAR2,
 X_MAP_ID                                   NUMBER,
 X_FORMAT_NAME                              VARCHAR2,
 X_DESCRIPTION				    VARCHAR2,
 X_FORMAT_TYPE                              VARCHAR2,
 X_CONTROL_FILE_NAME                        VARCHAR2,
 X_ENABLED                                  VARCHAR2,
 X_PRECISION				    NUMBER,
 X_DATE_FORMAT				    VARCHAR2,
 X_TIMESTAMP_FORMAT			    VARCHAR2,
 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_bank_stmt_int_map
  SET  	map_id			= X_map_id,
	format_name 		= X_format_name,
	description		= X_description,
	format_type		= X_format_type,
	control_file_name	= X_control_file_name,
	enabled			= X_enabled,
	precision		= X_precision,
	date_format		= X_date_format,
	timestamp_format	= X_timestamp_format,
	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,
        last_updated_by         = x_last_updated_by,
        last_update_date        = x_last_update_date,
        last_update_login       = x_last_update_login
  WHERE rowid = X_row_id;

Line: 190

END Map_Update_Row;

Line: 205

 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_bank_stmt_int_map
    WHERE rowid = X_row_id
    FOR UPDATE of map_id NOWAIT;

Line: 238

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

Line: 318

PROCEDURE Headers_Insert_Row(
 X_ROW_ID		IN OUT NOCOPY		    VARCHAR2,
 X_MAP_HEADER_ID	IN OUT NOCOPY		    NUMBER,
 X_MAP_ID				    NUMBER,
 X_COLUMN_NAME				    VARCHAR2,
 X_REC_ID				    VARCHAR2,
 X_POSITION				    NUMBER,
 X_FORMAT				    VARCHAR2,
 X_INCLUDE_FORMAT_IND			    VARCHAR2,
 X_CONCATENATE_FORMAT_FLAG		    VARCHAR2,
 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_map_id IS
   SELECT 	CE_BANK_STMT_MAP_HDR_S.nextval
   FROM		sys.dual;

Line: 355

   SELECT 	rowid
   FROM 	ce_bank_stmt_map_hdr
   WHERE 	map_header_id = TO_NUMBER(X_MAP_HEADER_ID);

Line: 364

  INSERT INTO ce_bank_stmt_map_hdr(
   	MAP_HEADER_ID,
	MAP_ID,
   	COLUMN_NAME,
   	REC_ID_NO,
   	POSITION,
	FORMAT,
       	INCLUDE_FORMAT_IND,
        CONCATENATE_FORMAT_FLAG,
	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_MAP_HEADER_ID,
  	X_MAP_ID,
   	X_COLUMN_NAME,
   	X_REC_ID,
   	X_POSITION,
	X_FORMAT,
       	X_INCLUDE_FORMAT_IND,
	X_CONCATENATE_FORMAT_FLAG,
	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: 432

END Headers_Insert_Row;

Line: 434

PROCEDURE Headers_Update_Row(
 X_ROW_ID				    VARCHAR2,
 X_MAP_HEADER_ID			    NUMBER,
 X_MAP_ID				    NUMBER,
 X_COLUMN_NAME				    VARCHAR2,
 X_REC_ID				    VARCHAR2,
 X_POSITION				    NUMBER,
 X_FORMAT				    VARCHAR2,
 X_INCLUDE_FORMAT_IND			    VARCHAR2,
 X_CONCATENATE_FORMAT_FLAG		    VARCHAR2,
 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_bank_stmt_map_hdr
  SET  	map_header_id		= X_map_header_id,
	map_id			= X_map_id,
	column_name 		= X_column_name,
	rec_id_no		= X_rec_id,
	position		= X_position,
	format			= X_format,
       	include_format_ind	= X_include_format_ind,
        concatenate_format_flag	= X_concatenate_format_flag,
	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,
        last_updated_by         = x_last_updated_by,
        last_update_date        = x_last_update_date,
        last_update_login       = x_last_update_login
  WHERE rowid = X_row_id;

Line: 498

END Headers_Update_Row;

Line: 512

 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_bank_stmt_map_hdr
    WHERE rowid = X_row_id
    FOR UPDATE of map_header_id NOWAIT;

Line: 545

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

Line: 620

PROCEDURE Lines_Insert_Row(
 X_ROW_ID		IN OUT NOCOPY		    VARCHAR2,
 X_MAP_LINE_ID		IN OUT NOCOPY		    NUMBER,
 X_MAP_ID				    NUMBER,
 X_COLUMN_NAME				    VARCHAR2,
 X_REC_ID				    VARCHAR2,
 X_POSITION				    NUMBER,
 X_FORMAT				    VARCHAR2,
 X_INCLUDE_FORMAT_IND			    VARCHAR2,
 X_CONCATENATE_FORMAT_FLAG		    VARCHAR2,
 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_map_id IS
   SELECT 	CE_BANK_STMT_MAP_LINE_S.nextval
   FROM		sys.dual;

Line: 657

   SELECT 	rowid
   FROM 	ce_bank_stmt_map_line
   WHERE 	map_line_id = TO_NUMBER(X_MAP_LINE_ID);

Line: 666

  INSERT INTO ce_bank_stmt_map_line(
   	MAP_LINE_ID,
	MAP_ID,
   	COLUMN_NAME,
   	REC_ID_NO,
   	POSITION,
	FORMAT,
       	INCLUDE_FORMAT_IND,
	CONCATENATE_FORMAT_FLAG,
	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_MAP_LINE_ID,
  	X_MAP_ID,
   	X_COLUMN_NAME,
   	X_REC_ID,
   	X_POSITION,
	X_FORMAT,
       	X_INCLUDE_FORMAT_IND,
	X_CONCATENATE_FORMAT_FLAG,
	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: 734

END Lines_Insert_Row;

Line: 736

PROCEDURE Lines_Update_Row(
 X_ROW_ID				    VARCHAR2,
 X_MAP_LINE_ID				    NUMBER,
 X_MAP_ID				    NUMBER,
 X_COLUMN_NAME				    VARCHAR2,
 X_REC_ID				    VARCHAR2,
 X_POSITION				    NUMBER,
 X_FORMAT				    VARCHAR2,
 X_INCLUDE_FORMAT_IND			    VARCHAR2,
 X_CONCATENATE_FORMAT_FLAG		    VARCHAR2,
 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_bank_stmt_map_line
  SET  	map_line_id		= X_map_line_id,
	map_id			= X_map_id,
	column_name 		= X_column_name,
	rec_id_no		= X_rec_id,
	position		= X_position,
        format			= X_format,
	include_format_ind	= X_include_format_ind,
	concatenate_format_flag	= X_concatenate_format_flag,
	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,
	last_updated_by         = x_last_updated_by,
        last_update_date        = x_last_update_date,
        last_update_login       = x_last_update_login
  WHERE rowid = X_row_id;

Line: 800

END Lines_Update_Row;

Line: 814

 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_bank_stmt_map_line
    WHERE rowid = X_row_id
    FOR UPDATE of map_line_id NOWAIT;

Line: 847

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