APPS.CCT_BASIC_TELE_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 17

        Select meaning into l_node_label
        from fnd_lookup_values_vl
        where lookup_type = 'CCT_SDK_TYPES'
        and lookup_code = 'BASIC';

Line: 35

        UPDATE_RT_STATS(P_RESOURCE_ID,0);

Line: 49

    PROCEDURE UPDATE_RT_STATS
    (
        P_RESOURCE_ID IN NUMBER,
        P_COUNT       IN NUMBER
    )
    IS
        l_count number ;

Line: 58

        UPDATE CCT_AGENT_RT_STATS
        SET CLIENT_ID = P_COUNT
        WHERE AGENT_ID = P_RESOURCE_ID;

Line: 63

            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);

Line: 78

    END UPDATE_RT_STATS;