The following lines contain the word 'select', 'insert', 'update' or 'delete':
select middleware_id into x_middleware_id from cct_telesets where teleset_id =
(select client_id from cct_agent_rt_stats where attribute1='T' and agent_id = p_agent_id);
select milcs_id, start_date_time into l_milcs_id, l_start_date_time
from jtf_ih_media_item_lc_segs
where media_id = p_media_item_id and milcs_type_id = p_milcs_type_id
and end_date_time is null;
JTF_IH_PUB_W.Update_MediaLifecycle
(p_api_version=>1.0
,p_init_msg_list=>FND_API.G_FALSE
,p_commit=>FND_API.G_TRUE
,p_resp_appl_id=>1 -- IN RESP APPL ID
,p_resp_id=>1 -- IN RESP ID
,p_user_id=>FND_GLOBAL.USER_ID -- IN USER ID
,p_login_id=>NULL -- IN LOGIN ID
,p10_a3=>l_milcs_duration -- IN duration
,p10_a4=>p_end_date_time -- IN end date time
,p10_a5=>l_milcs_id -- IN milcs id
,p10_a7=>p_media_item_id -- IN media id
,p10_a8=>CCT_IH_PUB.G_IH_CCT_HANDLER_ID -- IN handler id
,x_return_status=>x_return_status
,x_msg_count=>x_msg_count
,x_msg_data=>x_msg_data );
select max(c.end_date_time) into l_end_date_time from jtf_ih_media_item_lc_segs c
where c.media_id = p_media_item_id and c.milcs_type_id = IH_MILCS_TYPE_WITH_AGENT;
select count(*) into l_nwa_count from jtf_ih_media_item_lc_segs c
where c.media_id = p_media_item_id and c.milcs_type_id = IH_MILCS_TYPE_WITH_AGENT
and c.end_date_time IS NULL ;
select max(c.start_date_time) into l_start_date_time from jtf_ih_media_item_lc_segs c
where c.media_id = p_media_item_id and c.milcs_type_id = IH_MILCS_TYPE_WITH_AGENT;
select max(c.start_date_time) into l_in_queue_start_date_time from jtf_ih_media_item_lc_segs c
where c.media_id = p_media_item_id and c.milcs_type_id = IH_MILCS_TYPE_IN_QUEUE;