The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Row(
X_Row_Id IN OUT NOCOPY VARCHAR2,
X_statement_line_id IN OUT NOCOPY NUMBER,
X_statement_header_id IN OUT NOCOPY NUMBER,
X_line_number NUMBER,
X_trx_date DATE,
X_trx_type VARCHAR2,
X_trx_status VARCHAR2,
X_trx_code VARCHAR2, --5131976
X_effective_date IN OUT NOCOPY DATE,
X_bank_trx_number VARCHAR2,
X_trx_text VARCHAR2,
X_customer_text VARCHAR2,
X_invoice_text VARCHAR2,
X_bank_account_text VARCHAR2,
X_amount NUMBER,
X_charges_amount NUMBER,
X_status VARCHAR2,
X_created_by NUMBER,
X_creation_date DATE,
X_last_updated_by NUMBER,
X_last_update_date DATE,
X_currency_code VARCHAR2,
X_original_amount NUMBER,
X_exchange_rate NUMBER,
X_exchange_rate_type VARCHAR2,
X_exchange_rate_date DATE,
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,
--5916290: GDF Changes
X_global_att_category VARCHAR2,
X_global_attribute1 VARCHAR2,
X_global_attribute2 VARCHAR2,
X_global_attribute3 VARCHAR2,
X_global_attribute4 VARCHAR2,
X_global_attribute5 VARCHAR2,
X_global_attribute6 VARCHAR2,
X_global_attribute7 VARCHAR2,
X_global_attribute8 VARCHAR2,
X_global_attribute9 VARCHAR2,
X_global_attribute10 VARCHAR2,
X_global_attribute11 VARCHAR2,
X_global_attribute12 VARCHAR2,
X_global_attribute13 VARCHAR2,
X_global_attribute14 VARCHAR2,
X_global_attribute15 VARCHAR2,
X_global_attribute16 VARCHAR2,
X_global_attribute17 VARCHAR2,
X_global_attribute18 VARCHAR2,
X_global_attribute19 VARCHAR2,
X_global_attribute20 VARCHAR2
) IS
CURSOR C IS SELECT rowid FROM CE_STATEMENT_LINES
WHERE statement_line_id = X_Statement_line_Id;
CURSOR C1 IS SELECT ce_statement_lines_s.nextval from sys.dual;
CURSOR C2 IS SELECT NVL(MAX(line_number),0) + 10 FROM CE_STATEMENT_LINES
WHERE statement_header_id = X_statement_header_Id;
CURSOR C3 IS SELECT ce_statement_headers_s.nextval FROM sys.dual;
SELECT X_trx_date + float_days
INTO X_effective_date
FROM ce_transaction_codes
WHERE transaction_code_id = X_trx_code_id;
INSERT INTO CE_STATEMENT_LINES
(statement_line_id,
statement_header_id,
line_number,
trx_date,
trx_type,
trx_code,
effective_date,
bank_trx_number,
trx_text,
customer_text,
invoice_text,
bank_account_text,
amount,
charges_amount,
status,
created_by,
creation_date,
last_updated_by,
last_update_date,
currency_code,
original_amount,
exchange_rate,
exchange_rate_type,
exchange_rate_date,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
-- 5916290: GDF Changes
global_attribute_category,
global_attribute1,
global_attribute2,
global_attribute3,
global_attribute4,
global_attribute5,
global_attribute6,
global_attribute7,
global_attribute8,
global_attribute9,
global_attribute10,
global_attribute11,
global_attribute12,
global_attribute13,
global_attribute14,
global_attribute15,
global_attribute16,
global_attribute17,
global_attribute18,
global_attribute19,
global_attribute20
) VALUES (
X_statement_line_id,
X_statement_header_id,
sl_number,
X_trx_date,
line_type,
X_trx_code,
X_effective_date,
X_bank_trx_number,
X_trx_text,
X_customer_text,
X_invoice_text,
X_bank_account_text,
NVL(line_amount, X_amount),
X_charges_amount,
X_status,
X_created_by,
X_creation_date,
X_last_updated_by,
X_last_update_date,
X_currency_code,
abs(X_original_amount),
X_exchange_rate,
X_exchange_rate_type,
X_exchange_rate_date,
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,
X_global_att_category,
X_global_attribute1,
X_global_attribute2,
X_global_attribute3,
X_global_attribute4,
X_global_attribute5,
X_global_attribute6,
X_global_attribute7,
X_global_attribute8,
X_global_attribute9,
X_global_attribute10,
X_global_attribute11,
X_global_attribute12,
X_global_attribute13,
X_global_attribute14,
X_global_attribute15,
X_global_attribute16,
X_global_attribute17,
X_global_attribute18,
X_global_attribute19,
X_global_attribute20);
END insert_row;
PROCEDURE Delete_Row( X_Row_Id VARCHAR2 ) IS
L_STMT_LINE_ID CE_STATEMENT_LINES.STATEMENT_LINE_ID%TYPE; -- Bug 9099087
SELECT STATEMENT_LINE_ID INTO L_STMT_LINE_ID
FROM CE_STATEMENT_LINES
WHERE rowid = X_Row_Id;
DELETE FROM CE_STATEMENT_RECONCILS_ALL
WHERE STATEMENT_LINE_ID = L_STMT_LINE_ID;
DELETE FROM CE_STATEMENT_LINES
WHERE rowid = X_Row_Id;
END Delete_Row;
PROCEDURE Update_Row (
X_Row_Id VARCHAR2,
X_statement_line_id NUMBER,
X_statement_header_id NUMBER,
X_line_number NUMBER,
X_trx_date DATE,
X_trx_type VARCHAR2,
X_trx_code VARCHAR2, --5131976
X_effective_date DATE,
X_bank_trx_number VARCHAR2,
X_trx_text VARCHAR2,
X_customer_text VARCHAR2,
X_invoice_text VARCHAR2,
X_bank_account_text VARCHAR2,
X_amount NUMBER,
X_charges_amount NUMBER,
X_status VARCHAR2,
X_last_updated_by NUMBER,
X_last_update_date DATE,
X_attribute_category VARCHAR2,
X_original_amount NUMBER,
X_currency_code VARCHAR2,
X_exchange_rate NUMBER,
X_exchange_rate_type VARCHAR2,
X_exchange_rate_date DATE,
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,
--5916290: GDF Changes
X_global_att_category VARCHAR2,
X_global_attribute1 VARCHAR2,
X_global_attribute2 VARCHAR2,
X_global_attribute3 VARCHAR2,
X_global_attribute4 VARCHAR2,
X_global_attribute5 VARCHAR2,
X_global_attribute6 VARCHAR2,
X_global_attribute7 VARCHAR2,
X_global_attribute8 VARCHAR2,
X_global_attribute9 VARCHAR2,
X_global_attribute10 VARCHAR2,
X_global_attribute11 VARCHAR2,
X_global_attribute12 VARCHAR2,
X_global_attribute13 VARCHAR2,
X_global_attribute14 VARCHAR2,
X_global_attribute15 VARCHAR2,
X_global_attribute16 VARCHAR2,
X_global_attribute17 VARCHAR2,
X_global_attribute18 VARCHAR2,
X_global_attribute19 VARCHAR2,
X_global_attribute20 VARCHAR2
) IS
BEGIN
UPDATE CE_STATEMENT_LINES
SET
statement_line_id = X_statement_line_id,
statement_header_id = X_statement_header_id,
line_number = X_line_number,
trx_date = X_trx_date,
trx_type = X_trx_type,
trx_code = X_trx_code,
effective_date = X_effective_date,
bank_trx_number = X_bank_trx_number,
trx_text = X_trx_text,
customer_text = X_customer_text,
invoice_text = X_invoice_text,
bank_account_text = X_bank_account_text,
amount = X_amount,
charges_amount= X_charges_amount,
status = X_status,
last_updated_by = X_last_updated_by,
last_update_date = X_last_update_date,
attribute_category = X_attribute_category,
original_amount = X_original_amount,
currency_code = X_currency_code,
exchange_rate = X_exchange_rate,
exchange_rate_type = X_exchange_rate_type,
exchange_rate_date = X_exchange_rate_date,
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,
--Bug 6899211
global_attribute_category = X_global_att_category,
--5916290: GDF Changes
global_attribute1 = X_global_attribute1,
global_attribute2 = X_global_attribute2,
global_attribute3 = X_global_attribute3,
global_attribute4 = X_global_attribute4,
global_attribute5 = X_global_attribute5,
global_attribute6 = X_global_attribute6,
global_attribute7 = X_global_attribute7,
global_attribute8 = X_global_attribute8,
global_attribute9 = X_global_attribute9,
global_attribute10 = X_global_attribute10,
global_attribute11 = X_global_attribute11,
global_attribute12 = X_global_attribute12,
global_attribute13 = X_global_attribute13,
global_attribute14 = X_global_attribute14,
global_attribute15 = X_global_attribute15,
global_attribute16 = X_global_attribute16,
global_attribute17 = X_global_attribute17,
global_attribute18 = X_global_attribute18,
global_attribute19 = X_global_attribute19,
global_attribute20 = X_global_attribute20
WHERE rowid = X_Row_Id;
END Update_Row;
SELECT *
FROM CE_STATEMENT_LINES
WHERE rowid = X_Row_Id
FOR UPDATE OF statement_line_id NOWAIT;
FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');