The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Update_Row(
X_Rowid IN VARCHAR2,
X_Code_Combination_Id IN NUMBER,
X_Description IN VARCHAR2,
X_Last_Update_Date IN DATE,
X_Last_Updated_By IN NUMBER,
X_Last_Update_Login IN NUMBER ,
X_Calling_Sequence IN VARCHAR2,
X_Accounting_Error_Code IN VARCHAR2 -- Bug 1369125
) IS
Current_Calling_Sequence VARCHAR2(2000);
Current_Calling_Sequence := 'AP_FIX_ACCTG_PKG.UPDATE_ROW<-' ||
X_Calling_Sequence;
debug_info := 'Update ap_ae_lines';
UPDATE ap_ae_lines
SET code_combination_id = X_Code_Combination_Id,
description = X_Description,
last_update_date = X_Last_Update_Date,
last_updated_by = X_Last_Updated_By,
last_update_login = X_Last_Update_Login,
Accounting_Error_Code = X_Accounting_Error_Code -- Bug 1369125
WHERE Rowid = X_Rowid;
END Update_Row;
SELECT *
FROM ap_ae_lines
WHERE rowid = X_Rowid
FOR UPDATE of code_combination_id, description NOWAIT;
FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');