The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Update_Row(
p_rowid in varchar2
, p_database_object_name in VARCHAR2
, p_attribute_code in VARCHAR2
, p_defaulting_sequence in NUMBER
, p_defaulting_condn_ref_flag in VARCHAR2
, p_last_updated_by in number
, p_last_update_date in date
, p_last_update_login in number
)
IS
BEGIN
UPDATE OE_AK_OBJ_ATTR_EXT
SET
defaulting_sequence = p_defaulting_sequence
,defaulting_condn_ref_flag = p_defaulting_condn_ref_flag
,last_updated_by = p_last_updated_by
,last_update_date = p_last_update_date
,last_update_login = p_last_update_login
WHERE rowid = p_rowid;
END Update_Row;
, p_last_updated_by in number
, p_last_update_date in date
, p_last_update_login in number
)
IS
CURSOR C IS
SELECT * FROM OE_AK_OBJ_ATTR_EXT
WHERE rowid = p_Rowid
FOR UPDATE OF database_object_name NOWAIT;
FND_MESSAGE.Set_Name('FND','FORM_RECORD_DELETED');