The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
X_Invoice_Transaction_Id IN OUT NOCOPY NUMBER,
X_Book_Type_Code VARCHAR2,
X_Transaction_Type VARCHAR2,
X_Date_Effective DATE,
X_Calling_Fn VARCHAR2
, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
CURSOR C IS SELECT rowid FROM fa_invoice_transactions
WHERE invoice_transaction_id = X_Invoice_Transaction_Id;
CURSOR C2 IS SELECT fa_invoice_transactions_s.nextval FROM sys.dual;
INSERT INTO fa_invoice_transactions(
invoice_transaction_id,
book_type_code,
transaction_type,
date_effective
) VALUES (
X_Invoice_Transaction_Id,
X_Book_Type_Code,
X_Transaction_Type,
X_Date_Effective
);
(Called_Fn => 'FA_INVOICE_TRANSACTIONS_PKG.Insert_Row',
Calling_Fn => X_Calling_Fn, p_log_level_rec => p_log_level_rec); */
Calling_Fn => 'FA_INVOICE_TRANSACTIONS_PKG.Insert_Row', p_log_level_rec => p_log_level_rec);
END Insert_Row;
SELECT *
FROM fa_invoice_transactions
WHERE rowid = X_Rowid
FOR UPDATE of Invoice_Transaction_Id NOWAIT;
FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
PROCEDURE Update_Row(X_Rowid VARCHAR2,
X_Invoice_Transaction_Id NUMBER,
X_Book_Type_Code VARCHAR2,
X_Transaction_Type VARCHAR2,
X_Date_Effective DATE,
X_Calling_Fn VARCHAR2
, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
BEGIN
UPDATE fa_invoice_transactions
SET
invoice_transaction_id = X_Invoice_Transaction_Id,
book_type_code = X_Book_Type_Code,
transaction_type = X_Transaction_Type,
date_effective = X_Date_Effective
WHERE rowid = X_Rowid;
(Calling_Fn => 'FA_INVOICE_TRANSACTIONS_PKG.Update_Row', p_log_level_rec => p_log_level_rec);
END Update_Row;
PROCEDURE Delete_Row(X_Rowid VARCHAR2,
X_Calling_Fn VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
BEGIN
DELETE FROM fa_invoice_transactions
WHERE rowid = X_Rowid;
(Calling_Fn => 'FA_INVOICE_TRANSACTIONS_PKG.Delete_Row', p_log_level_rec => p_log_level_rec);
END Delete_Row;