APPS.CCT_QDE_PUB dependencies on CCT_MEDIA_TYPES_PUB

Line 28: l_item_type := CCT_MEDIA_TYPES_PUB.GET_UWQ_MEDIA_TYPE_ID(p_item_type);

24: --|| ' p_item_type = ' || p_item_type
25: --|| ' p_classification = ' || p_classification
26: --|| ' p_count = ' || p_count);
27:
28: l_item_type := CCT_MEDIA_TYPES_PUB.GET_UWQ_MEDIA_TYPE_ID(p_item_type);
29:
30: update cct_qde_agent_queues set count = p_count
31: where agent_id = p_agent_id
32: and item_type = l_item_type

Line 819: where (item_type = CCT_MEDIA_TYPES_PUB.GET_UWQ_MEDIA_TYPE_ID(p_item_type))

815:
816: declare cursor r2 is
817: select agent_queue_id , classification
818: from cct_qde_agent_queues
819: where (item_type = CCT_MEDIA_TYPES_PUB.GET_UWQ_MEDIA_TYPE_ID(p_item_type))
820: and classification is not null
821: and agent_id = p_agent_id ;
822: begin
823: for r2_rec in r2 loop