APPS.CCT_MEDIA_QUEUE_PUB SQL Statements

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

Line: 8

PROCEDURE UPDATE_DEQUEUE_COUNT
( 	p_api_version           IN	NUMBER ,
  	p_init_msg_list		IN	VARCHAR2 ,
	p_commit	    	IN  	VARCHAR2 ,
	p_root_svr_group_id IN NUMBER,
	p_media_type	IN 	NUMBER,
	p_dequeue_count IN NUMBER,
	x_return_status		OUT NOCOPY	VARCHAR2		  	,
	x_msg_count		OUT NOCOPY	NUMBER				,
	x_msg_data		OUT NOCOPY	VARCHAR2
)
IS
l_api_name			CONSTANT VARCHAR2(30)	:= 'UPDATE_DEQUEUE_COUNT';

Line: 25

    SAVEPOINT	UPDATE_DEQUEUE_COUNT_PUB;

Line: 43

    update cct_media_type_dequeue_count
    set dequeue_count = p_dequeue_count
    where server_group_id = p_root_svr_group_id and media_type = p_media_type;

Line: 65

    insert into cct_media_type_dequeue_count
    ( media_type, dequeue_count, server_group_id, created_by, creation_date, last_updated_by, last_update_date, last_update_login )
    values (p_media_type, p_dequeue_count, p_root_svr_group_id, 1, sysdate, 1, sysdate, 1);

Line: 75

		ROLLBACK TO UPDATE_DEQUEUE_COUNT_PUB;

Line: 82

		ROLLBACK TO UPDATE_DEQUEUE_COUNT_PUB;

Line: 89

		ROLLBACK TO UPDATE_DEQUEUE_COUNT_PUB;

Line: 103

END UPDATE_DEQUEUE_COUNT;

Line: 170

	select server_group_id into l_root_server_group_id
	from ieo_svr_groups where group_name = l_root_server_group_name;

Line: 175

	select media_type into l_media_type
	from cct_media_items where media_item_id = p_media_item_id;

Line: 189

    select queue_position into l_queue_position from cct_media_items
    where media_item_id = p_media_item_id;

Line: 197

    select dequeue_count into l_dequeue_count from cct_media_type_dequeue_count
    where media_type = l_media_type  and server_group_id = l_root_server_group_id;

Line: 209

    select count(*) into l_agents_media_type
    from cct_agent_rt_stats where attribute11 = l_root_server_group_id
    and  attribute1 = 'T' and media_type = l_media_type ;

Line: 213

    select count(*) into l_agents_any_media_type
    from cct_agent_rt_stats where attribute11 = l_root_server_group_id
    and attribute1 = 'T' and media_type = l_media_type_any;

Line: 229

   select queue_seq_num into l_queue_seq_num from cct_media_items
   where media_item_id = p_media_item_id;

Line: 237

   select sum(dequeue_count) into l_dequeue_count_all_types
   from cct_media_type_dequeue_count where server_group_id = l_root_server_group_id;

Line: 246

    select count(*) into l_agents_all_media_types from cct_agent_rt_stats
    where attribute1 = 'T' and attribute11= l_root_server_group_id;