APPS.CCT_ROUTINGWORKFLOW_PUB dependencies on CCT_TEMPAGENTS

Line 525: -- The dynamic sql statement is run on the table CCT_TEMPAGENTS

521: --
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 (

Line 553: select FILTER_TYPE from CCT_TEMPAGENTS

549: l_apos VARCHAR2(4) := '''';
550: l_reroute VARCHAR2(20);
551:
552: CURSOR l_filters_csr IS
553: select FILTER_TYPE from CCT_TEMPAGENTS
554: where call_id = l_call_id
555: and agent_id = '-1' ;
556:
557:

Line 577: 'Select distinct(A.agent_id) from cct_tempagents a '||

573: 'OCCTMEDIAITEMID');
574: l_MCM_ID := WF_ENGINE.GetItemAttrNumber(itemtype, itemkey,
575: 'MCM_ID');
576: l_default_select :=
577: 'Select distinct(A.agent_id) from cct_tempagents a '||
578: 'where a.call_id ='||l_apos||l_call_ID||l_apos||
579: ' and a.agent_id <> '||l_apos||-1||l_apos;
580:
581: -- Start the dynamic string

Line 587: ' AND A.agent_ID IN (SELECT agent_ID from CCT_TEMPAGENTS ' ||

583:
584:
585: FOR l_filter IN l_filters_csr LOOP
586: l_dynamic_select := l_dynamic_select ||
587: ' AND A.agent_ID IN (SELECT agent_ID from CCT_TEMPAGENTS ' ||
588: ' WHERE CALL_ID = ' || l_apos || l_call_ID || l_apos ||
589: ' AND FILTER_TYPE = ' || l_apos || l_filter.FILTER_TYPE || l_apos || ')';
590: END LOOP;
591:

Line 644: -- delete the entries for this call from CCT_TEMPAGENTS

640:
641: -- Close the cursor
642: DBMS_SQL.CLOSE_CURSOR(l_select_csr);
643:
644: -- delete the entries for this call from CCT_TEMPAGENTS
645: -- delete the entries for this call from CCT_TEMPAGENTS
646: -- Donot delete if in testmode, then need to explicitly delete this table later
647: IF G_TEST_MODE <> 'ON' THEN
648: DELETE from CCT_TEMPAGENTS

Line 645: -- delete the entries for this call from CCT_TEMPAGENTS

641: -- Close the cursor
642: DBMS_SQL.CLOSE_CURSOR(l_select_csr);
643:
644: -- delete the entries for this call from CCT_TEMPAGENTS
645: -- delete the entries for this call from CCT_TEMPAGENTS
646: -- Donot delete if in testmode, then need to explicitly delete this table later
647: IF G_TEST_MODE <> 'ON' THEN
648: DELETE from CCT_TEMPAGENTS
649: WHERE CALL_ID = l_call_ID;

Line 648: DELETE from CCT_TEMPAGENTS

644: -- delete the entries for this call from CCT_TEMPAGENTS
645: -- delete the entries for this call from CCT_TEMPAGENTS
646: -- Donot delete if in testmode, then need to explicitly delete this table later
647: IF G_TEST_MODE <> 'ON' THEN
648: DELETE from CCT_TEMPAGENTS
649: WHERE CALL_ID = l_call_ID;
650: END IF;
651:
652: -- do the randomization to reduce number of agents returned to TEN

Line 1077: select FILTER_TYPE from CCT_TEMPAGENTS

1073: l_apos VARCHAR2(4) := '''';
1074: l_reroute VARCHAR2(20);
1075:
1076: CURSOR l_filters_csr IS
1077: select FILTER_TYPE from CCT_TEMPAGENTS
1078: where call_id = l_call_id
1079: and agent_id = '-1' ;
1080:
1081:

Line 1101: 'Select distinct(A.agent_id) from cct_tempagents a '||

1097: 'OCCTMEDIAITEMID');
1098: l_MCM_ID := WF_ENGINE.GetItemAttrNumber(itemtype, itemkey,
1099: 'MCM_ID');
1100: l_default_select :=
1101: 'Select distinct(A.agent_id) from cct_tempagents a '||
1102: 'where a.call_id ='||l_apos||l_call_ID||l_apos||
1103: ' and a.agent_id <> '||l_apos||-1||l_apos;
1104:
1105: -- Start the dynamic string

Line 1111: ' AND A.agent_ID IN (SELECT agent_ID from CCT_TEMPAGENTS ' ||

1107:
1108:
1109: FOR l_filter IN l_filters_csr LOOP
1110: l_dynamic_select := l_dynamic_select ||
1111: ' AND A.agent_ID IN (SELECT agent_ID from CCT_TEMPAGENTS ' ||
1112: ' WHERE CALL_ID = ' || l_apos || l_call_ID || l_apos ||
1113: ' AND FILTER_TYPE = ' || l_apos || l_filter.FILTER_TYPE || l_apos || ')';
1114: END LOOP;
1115:

Line 1188: -- delete the entries for this call from CCT_TEMPAGENTS

1184:
1185: -- Close the cursor
1186: DBMS_SQL.CLOSE_CURSOR(l_select_csr);
1187:
1188: -- delete the entries for this call from CCT_TEMPAGENTS
1189: DELETE from CCT_TEMPAGENTS
1190: WHERE CALL_ID = l_call_ID;
1191:
1192:

Line 1189: DELETE from CCT_TEMPAGENTS

1185: -- Close the cursor
1186: DBMS_SQL.CLOSE_CURSOR(l_select_csr);
1187:
1188: -- delete the entries for this call from CCT_TEMPAGENTS
1189: DELETE from CCT_TEMPAGENTS
1190: WHERE CALL_ID = l_call_ID;
1191:
1192:
1193: -- do the randomization to reduce number of agents returned to TEN