The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
communication_message_id
,parent_id
,communication_topic_id
,message_subject
,message_body
,message_post_date
,sender_type
,sender_id
,document_type
,document_id
,deleted_flag
,object_version_number
from irc_comm_messages
where communication_message_id = p_communication_message_id;
select
communication_message_id
,parent_id
,communication_topic_id
,message_subject
,message_body
,message_post_date
,sender_type
,sender_id
,document_type
,document_id
,deleted_flag
,object_version_number
from irc_comm_messages
where communication_message_id = p_communication_message_id
for update nowait;
,p_deleted_flag in varchar2
,p_object_version_number in number
)
Return g_rec_type is
--
l_rec g_rec_type;
l_rec.deleted_flag := p_deleted_flag;