APPS.CCT_BASIC_TELE_PUB dependencies on CCT_AGENT_RT_STATS

Line 58: UPDATE CCT_AGENT_RT_STATS

54: IS
55: l_count number ;
56: BEGIN
57:
58: UPDATE CCT_AGENT_RT_STATS
59: SET CLIENT_ID = P_COUNT
60: WHERE AGENT_ID = P_RESOURCE_ID;
61:
62: IF(SQL%NOTFOUND OR (SQL%ROWCOUNT <= 0)) THEN

Line 63: INSERT INTO CCT_AGENT_RT_STATS

59: SET CLIENT_ID = P_COUNT
60: WHERE AGENT_ID = P_RESOURCE_ID;
61:
62: IF(SQL%NOTFOUND OR (SQL%ROWCOUNT <= 0)) THEN
63: INSERT INTO CCT_AGENT_RT_STATS
64: (
65: AGENT_ID,
66: CLIENT_ID,
67: MCM_ID,

Line 75: (P_RESOURCE_ID,P_COUNT,-1,-1,SYSDATE,-1,SYSDATE,CCT_AGENT_RT_STATS_S.nextval);

71: LAST_UPDATE_DATE,
72: AGENT_RT_STAT_ID
73: )
74: VALUES
75: (P_RESOURCE_ID,P_COUNT,-1,-1,SYSDATE,-1,SYSDATE,CCT_AGENT_RT_STATS_S.nextval);
76: END IF;
77:
78: END UPDATE_RT_STATS;
79: