APPS.CCT_QDE_PUB dependencies on CCT_QDE_ROUTE_RESULT

Line 152: insert into cct_qde_route_result (item_id,

148: p_kvp,
149: 1, sysdate, 1, sysdate, 1);
150: --dbms_output.put_line('RECEIVE_ITEM: post insert data');
151: --dbms_output.put_line('RECEIVE_ITEM: pre insert rr');
152: insert into cct_qde_route_result (item_id,
153: item_type, classification, route_result,
154: is_route_to_all, is_reroute, is_routed, start_time,
155: created_by, creation_date,
156: last_updated_by, last_update_date, last_update_login)

Line 273: update cct_qde_route_result

269: if ((p_is_route_to_all = 'Y') or (p_route_result is null)) then
270: l_route_result := '0000';
271: end if;
272:
273: update cct_qde_route_result
274: set classification = p_classification,
275: route_result = l_route_result,
276: is_route_to_all = p_is_route_to_all,
277: is_reroute = p_is_reroute,

Line 325: from cct_qde_route_result

321:
322: begin
323: --dbms_output.put_line('UPDATE_ROUTE_RESULT: pre lock route result');
324: select item_id into l_item_id
325: from cct_qde_route_result
326: where item_id = p_item_id
327: for update NOWAIT;
328: --dbms_output.put_line('UPDATE_ROUTE_RESULT: post lock route result');
329: exception

Line 345: delete from cct_qde_route_result where item_id = p_item_id;

341:
342: --dbms_output.put_line('Match found...');
343: --dbms_output.put_line('Matched item_id = ' || p_item_id || ' , agent_id = ' || r1_rec. agent_id);
344:
345: delete from cct_qde_route_result where item_id = p_item_id;
346: --dbms_output.put_line('UPDATE_ROUTE_RESULT: post delete route result');
347:
348:
349: delete from cct_qde_data where item_id = p_item_id;

Line 522: from cct_qde_route_result_vw

518: --dbms_output.put_line('GET_NEXT_ITEM: post select l_raw_agent_index= ' || l_raw_agent_index);
519: -- $$$$ change no NO_DATA_FOUND
520: declare cursor r1 is
521: select item_id, item_type, classification, route_result, is_route_to_all
522: from cct_qde_route_result_vw
523: where (item_type = p_item_type)
524: and ((p_classification is null) or (p_classification is not null
525: and classification = p_classification))
526: and ((is_route_to_all = 'Y') or

Line 561: from cct_qde_route_result

557:
558: begin
559: select item_id,item_type,classification
560: into x_item_id, x_item_type, x_classification
561: from cct_qde_route_result
562: where item_id = r1_rec.item_id
563: for update nowait;
564: exception
565: when NO_DATA_FOUND then

Line 576: delete from cct_qde_route_result where item_id = r1_rec.item_id;

572: --- $$$$ change to N0_DATA_FOUND
573: -- if sql%notfound then raise RESULT_NOT_FOUND;
574: -- end if;
575: --dbms_output.put_line('GET_NEXT_ITEM: pre delete route result');
576: delete from cct_qde_route_result where item_id = r1_rec.item_id;
577: --dbms_output.put_line('GET_NEXT_ITEM: post delete route result');
578: select item_kvp into x_kvp from cct_qde_data
579: where item_id = r1_rec.item_id;
580: delete from cct_qde_data where item_id = r1_rec.item_id;

Line 731: from cct_qde_route_result_vw

727: -- end if;
728:
729: declare cursor r1 is
730: select item_id, item_type, classification, route_result, is_route_to_all
731: from cct_qde_route_result_vw
732: where (item_type = p_item_type)
733: order by classification;
734: begin
735: --dbms_output.put_line('UPDATE_AGENT_QUEUES: post declare cursor');