APPS.CCT_MEDIA_QUEUE_PUB dependencies on CCT_MEDIA_TYPE_DEQUEUE_COUNT

Line 43: update cct_media_type_dequeue_count

39: x_return_status := FND_API.G_RET_STS_SUCCESS;
40: -- API body
41:
42:
43: update cct_media_type_dequeue_count
44: set dequeue_count = p_dequeue_count
45: where server_group_id = p_root_svr_group_id and media_type = p_media_type;
46:
47: IF sql%notfound THEN raise NO_DATA_FOUND;

Line 65: insert into cct_media_type_dequeue_count

61: EXCEPTION
62:
63: WHEN NO_DATA_FOUND THEN
64:
65: insert into cct_media_type_dequeue_count
66: ( media_type, dequeue_count, server_group_id, created_by, creation_date, last_updated_by, last_update_date, last_update_login )
67: values (p_media_type, p_dequeue_count, p_root_svr_group_id, 1, sysdate, 1, sysdate, 1);
68:
69: IF FND_API.To_Boolean( p_commit ) THEN

Line 197: select dequeue_count into l_dequeue_count from cct_media_type_dequeue_count

193: raise l_queue_position_undefined;
194: END IF;
195:
196:
197: select dequeue_count into l_dequeue_count from cct_media_type_dequeue_count
198: where media_type = l_media_type and server_group_id = l_root_server_group_id;
199:
200: IF ((l_queue_position - l_dequeue_count) > 0) THEN
201: x_abs_pos_media_type := l_queue_position - l_dequeue_count;

Line 238: from cct_media_type_dequeue_count where server_group_id = l_root_server_group_id;

234: END IF;
235:
236:
237: select sum(dequeue_count) into l_dequeue_count_all_types
238: from cct_media_type_dequeue_count where server_group_id = l_root_server_group_id;
239:
240: IF ((l_queue_seq_num - l_dequeue_count_all_types) > 0 ) THEN
241: x_abs_pos_all_media_types := l_queue_seq_num - l_dequeue_count_all_types;
242: END IF;