The following lines contain the word 'select', 'insert', 'update' or 'delete':
Select meaning into l_node_label
from fnd_lookup_values_vl
where lookup_type = 'CCT_SDK_TYPES'
and lookup_code = 'BASIC';
UPDATE_RT_STATS(P_RESOURCE_ID,0);
PROCEDURE UPDATE_RT_STATS
(
P_RESOURCE_ID IN NUMBER,
P_COUNT IN NUMBER
)
IS
l_count number ;
UPDATE CCT_AGENT_RT_STATS
SET CLIENT_ID = P_COUNT
WHERE AGENT_ID = P_RESOURCE_ID;
INSERT INTO CCT_AGENT_RT_STATS
(
AGENT_ID,
CLIENT_ID,
MCM_ID,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
AGENT_RT_STAT_ID
)
VALUES
(P_RESOURCE_ID,P_COUNT,-1,-1,SYSDATE,-1,SYSDATE,CCT_AGENT_RT_STATS_S.nextval);
END UPDATE_RT_STATS;