APPS.CCT_MEDIA_QUEUE_PUB dependencies on CCT_MEDIA_ITEMS

Line 176: from cct_media_items where media_item_id = p_media_item_id;

172:
173: -- determine media type for media item.
174:
175: select media_type into l_media_type
176: from cct_media_items where media_item_id = p_media_item_id;
177:
178: IF sql%notfound THEN raise MEDIA_ITEM_NOT_FOUND;
179: END IF;
180:

Line 189: select queue_position into l_queue_position from cct_media_items

185: x_relative_pos_all_media_types := 0;
186:
187: -- x_abs_pos_media_type = dequeue_count - queue_position
188:
189: select queue_position into l_queue_position from cct_media_items
190: where media_item_id = p_media_item_id;
191:
192: IF (l_queue_position = 0) THEN
193: raise l_queue_position_undefined;

Line 229: select queue_seq_num into l_queue_seq_num from cct_media_items

225: END IF;
226:
227: -- x_abs_pos_all_media_types = dequeue_count_all_media_types - queue_seq_num
228:
229: select queue_seq_num into l_queue_seq_num from cct_media_items
230: where media_item_id = p_media_item_id;
231:
232: IF (l_queue_seq_num = 0) THEN
233: raise l_queue_seq_num_undefined;