eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CCT_ROUTINGWORKFLOW_PUB dependencies on CCT_ROUTING_RESULTS

Line 157: FROM CCT_ROUTING_RESULTS

153: l_no_result_Exception EXCEPTION;
154:
155: CURSOR l_results_csr IS
156: SELECT agent_ID
157: FROM CCT_ROUTING_RESULTS
158: WHERE call_ID = p_call_ID
159: ORDER BY sort_num;
160:
161: err_name VARCHAR2(30);

Line 329: Retreive results from CCT_ROUTING_RESULTS tables

325: p_email_icntr_map_id := WF_ENGINE.GetItemAttrText(l_itemtype, l_itemkey
326: , 'EMAILICENTERMAPID');
327:
328: /* ***************************************************************
329: Retreive results from CCT_ROUTING_RESULTS tables
330: *************************************************************** */
331: begin
332:
333: open l_results_csr;

Line 352: -- delete the results for this call from the CCT_ROUTING_RESULTS

348: WHEN l_no_result_exception THEN
349: CLOSE l_results_csr;
350: -- p_return_val := p_return_val || l_delimiter || p_agent_list;
351: p_return_val := p_agent_list;
352: -- delete the results for this call from the CCT_ROUTING_RESULTS
353: begin
354: DELETE from CCT_ROUTING_RESULTS
355: WHERE call_ID = p_call_ID;
356: --commit work;

Line 354: DELETE from CCT_ROUTING_RESULTS

350: -- p_return_val := p_return_val || l_delimiter || p_agent_list;
351: p_return_val := p_agent_list;
352: -- delete the results for this call from the CCT_ROUTING_RESULTS
353: begin
354: DELETE from CCT_ROUTING_RESULTS
355: WHERE call_ID = p_call_ID;
356: --commit work;
357: exception
358: WHEN OTHERS THEN

Line 375: -- delete the results for this call from the CCT_ROUTING_RESULTS

371: else
372: l_return_status := 'WF ERROR : err_name is ' ||
373: err_name || ' and err_msg is ' || err_msg;
374: end if;
375: -- delete the results for this call from the CCT_ROUTING_RESULTS
376: begin
377: DELETE from CCT_ROUTING_RESULTS
378: WHERE call_ID = p_call_ID;
379: --commit work;

Line 377: DELETE from CCT_ROUTING_RESULTS

373: err_name || ' and err_msg is ' || err_msg;
374: end if;
375: -- delete the results for this call from the CCT_ROUTING_RESULTS
376: begin
377: DELETE from CCT_ROUTING_RESULTS
378: WHERE call_ID = p_call_ID;
379: --commit work;
380: exception
381: WHEN OTHERS THEN

Line 526: -- and the resulting agents are inserted into CCT_ROUTING_RESULTS

522: -- Version : Initial Version 1.0
523: -- Notes : Create a dynamic sql statement by concatenating the clause(s)
524: -- needed for each flag that is set.
525: -- The dynamic sql statement is run on the table CCT_TEMPAGENTS
526: -- and the resulting agents are inserted into CCT_ROUTING_RESULTS
527: -- with sort order info added.
528: -- ------------------------------------------------------------------------
529: procedure Get_Agents (
530: itemtype in varchar2

Line 654: -- randomization needed insert all into CCT_ROUTING_RESULTS

650: END IF;
651:
652: -- do the randomization to reduce number of agents returned to TEN
653: if (l_sort_num <= G_MAXAGENTS) then
654: -- randomization needed insert all into CCT_ROUTING_RESULTS
655: Randomize_Agents(l_agents_tbl, l_sort_num);
656: FOR counter IN 1..l_sort_num
657: LOOP
658: INSERT INTO CCT_ROUTING_RESULTS

Line 658: INSERT INTO CCT_ROUTING_RESULTS

654: -- randomization needed insert all into CCT_ROUTING_RESULTS
655: Randomize_Agents(l_agents_tbl, l_sort_num);
656: FOR counter IN 1..l_sort_num
657: LOOP
658: INSERT INTO CCT_ROUTING_RESULTS
659: (call_id,itemkey,agent_id,sort_num,
660: routing_Result_id,last_update_date,last_updated_by,
661: creation_Date,created_by)
662: VALUES (l_call_ID, itemkey,l_agents_tbl(counter), counter,

Line 670: INSERT INTO CCT_ROUTING_RESULTS

666: -- do the randomization to reduce number of agents returned to TEN
667: Randomize_Agents(l_agents_tbl, l_sort_num);
668: FOR counter IN 1..G_MAXAGENTS
669: LOOP
670: INSERT INTO CCT_ROUTING_RESULTS
671: (call_id,itemkey,agent_id,sort_num,
672: routing_Result_id,last_update_date,last_updated_by,
673: creation_Date,created_by)
674: VALUES (l_call_ID, itemkey,l_agents_tbl(counter), counter,

Line 864: FROM CCT_ROUTING_RESULTS

860: FROM dual;
861:
862: CURSOR l_results_csr IS
863: SELECT agent_ID
864: FROM CCT_ROUTING_RESULTS
865: -- WHERE call_ID = p_call_ID
866: WHERE call_ID = p_call_ID
867: ORDER BY sort_num;
868:

Line 938: Retreive results from CCT_ROUTING_RESULTS tables

934: WF_ENGINE.StartProcess(l_itemtype, l_itemkey );
935:
936: --dbms_output.put_line('Getting Attribute value for ScreenpopApp:'||WF_ENGINE.GetItemAttrText(l_itemtype,l_itemkey,'SCREENPOPAPP'));
937: /* ***************************************************************
938: Retreive results from CCT_ROUTING_RESULTS tables
939: *************************************************************** */
940: begin
941:
942: open l_results_csr;

Line 966: -- delete the results for this call from the CCT_ROUTING_RESULTS

962: WHEN l_no_result_exception THEN
963: CLOSE l_results_csr;
964: -- p_return_val := p_return_val || l_delimiter || p_agent_list
965:
966: -- delete the results for this call from the CCT_ROUTING_RESULTS
967: begin
968: DELETE from CCT_ROUTING_RESULTS
969: WHERE call_ID = p_call_ID;
970:

Line 968: DELETE from CCT_ROUTING_RESULTS

964: -- p_return_val := p_return_val || l_delimiter || p_agent_list
965:
966: -- delete the results for this call from the CCT_ROUTING_RESULTS
967: begin
968: DELETE from CCT_ROUTING_RESULTS
969: WHERE call_ID = p_call_ID;
970:
971:
972: --commit work;

Line 993: -- delete the results for this call from the CCT_ROUTING_RESULTS

989: else
990: l_return_status := 'WF ERROR : err_name is ' ||
991: err_name || ' and err_msg is ' || err_msg;
992: end if;
993: -- delete the results for this call from the CCT_ROUTING_RESULTS
994:
995: begin
996: DELETE from CCT_ROUTING_RESULTS
997: WHERE call_ID = p_call_ID;

Line 996: DELETE from CCT_ROUTING_RESULTS

992: end if;
993: -- delete the results for this call from the CCT_ROUTING_RESULTS
994:
995: begin
996: DELETE from CCT_ROUTING_RESULTS
997: WHERE call_ID = p_call_ID;
998: --commit work;
999: exception
1000: WHEN OTHERS THEN

Line 1195: -- randomization needed insert all into CCT_ROUTING_RESULTS

1191:
1192:
1193: -- do the randomization to reduce number of agents returned to TEN
1194: if (l_sort_num <= G_MAXAGENTS) then
1195: -- randomization needed insert all into CCT_ROUTING_RESULTS
1196: Randomize_Agents(l_agents_tbl, l_sort_num);
1197: FOR counter IN 1..l_sort_num
1198: LOOP
1199: INSERT INTO CCT_ROUTING_RESULTS

Line 1199: INSERT INTO CCT_ROUTING_RESULTS

1195: -- randomization needed insert all into CCT_ROUTING_RESULTS
1196: Randomize_Agents(l_agents_tbl, l_sort_num);
1197: FOR counter IN 1..l_sort_num
1198: LOOP
1199: INSERT INTO CCT_ROUTING_RESULTS
1200: (call_id,itemkey,agent_id,sort_num,
1201: routing_Result_id,last_update_date,last_updated_by,
1202: creation_Date,created_by)
1203: VALUES (l_call_ID, itemkey,l_agents_tbl(counter), counter,

Line 1211: INSERT INTO CCT_ROUTING_RESULTS

1207: -- do the randomization to reduce number of agents returned to TEN
1208: Randomize_Agents(l_agents_tbl, l_sort_num);
1209: FOR counter IN 1..G_MAXAGENTS
1210: LOOP
1211: INSERT INTO CCT_ROUTING_RESULTS
1212: (call_id,itemkey,agent_id,sort_num,
1213: routing_Result_id,last_update_date,last_updated_by,
1214: creation_Date,created_by)
1215: VALUES (l_call_ID, itemkey,l_agents_tbl(counter), counter,