APPS.CCT_QDE_PUB dependencies on CCT_QDE_AGENT_QUEUES

Line 30: update cct_qde_agent_queues set count = p_count

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
33: and ((p_classification is null and classification is null) or (p_classification is not null
34: and classification = p_classification)) ;

Line 48: insert into cct_qde_agent_queues

44: end if;
45:
46: EXCEPTION
47: WHEN ENTRY_NOT_FOUND THEN
48: insert into cct_qde_agent_queues
49: ( agent_queue_id, agent_id, item_type, classification, count,
50: created_by, creation_date,
51: last_updated_by, last_update_date, last_update_login
52: )

Line 55: cct_qde_agent_queues_s1.nextval, p_agent_id, l_item_type, p_classification, p_count,

51: last_updated_by, last_update_date, last_update_login
52: )
53: values
54: (
55: cct_qde_agent_queues_s1.nextval, p_agent_id, l_item_type, p_classification, p_count,
56: 1, sysdate, 1, sysdate, 1
57: );
58: IF FND_API.To_Boolean( p_commit ) THEN
59: COMMIT WORK;

Line 818: from cct_qde_agent_queues

814:
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

Line 843: delete from cct_qde_agent_queues

839: if l_found = 'false'
840: then
841: begin
842: --dbms_output.put_line('Deleting classification' || r2_rec.classification);
843: delete from cct_qde_agent_queues
844: where agent_queue_id = r2_rec.agent_queue_id;
845: IF FND_API.To_Boolean( p_commit ) THEN
846: COMMIT WORK;
847: END IF;