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_ROUTINGACTIVITIES_PUB dependencies on CCT_ROUTINGWORKFLOW_UTL

Line 562: l_agents_tbl CCT_RoutingWorkflow_UTL.agent_tbl_type;

558: , funmode in varchar2
559: , resultout in out nocopy varchar2)
560: IS
561: l_proc_name VARCHAR2(30) := 'Set_Lang_Comp_Filter';
562: l_agents_tbl CCT_RoutingWorkflow_UTL.agent_tbl_type;
563: l_num_agents NUMBER := 0;
564: l_competency_name VARCHAR2(32);
565: l_call_ID VARCHAR2(32);
566: i INTEGER;

Line 591: CCT_RoutingWorkflow_UTL.InsertResults

587: return;
588: END IF;
589:
590: -- insert the agents into the CCT_TEMPAGENTS table
591: CCT_RoutingWorkflow_UTL.InsertResults
592: (l_call_ID, 'CCT_COMPETENCY_LANG_FILTER' , l_agents_tbl);
593:
594: end if;
595: EXCEPTION

Line 627: l_agents_tbl CCT_RoutingWorkflow_UTL.agent_tbl_type;

623: , funmode in varchar2
624: , resultout in out nocopy varchar2)
625: IS
626: l_proc_name VARCHAR2(30) := 'Set_Know_Comp_Filter';
627: l_agents_tbl CCT_RoutingWorkflow_UTL.agent_tbl_type;
628: l_num_agents NUMBER := 0;
629: l_competency_name VARCHAR2(32);
630: l_call_ID VARCHAR2(32);
631: i INTEGER;

Line 657: CCT_RoutingWorkflow_UTL.InsertResults

653: return;
654: END IF;
655:
656: -- insert the agents into the CCT_TEMPAGENTS table
657: CCT_RoutingWorkflow_UTL.InsertResults
658: (l_call_ID, 'CCT_COMPETENCY_KNOW_FILTER' , l_agents_tbl);
659:
660: end if;
661: EXCEPTION

Line 694: l_agents_tbl CCT_RoutingWorkflow_UTL.agent_tbl_type;

690: , funmode in varchar2
691: , resultout in out nocopy varchar2)
692: IS
693: l_proc_name VARCHAR2(30) := 'Set_Prod_Comp_Filter';
694: l_agents_tbl CCT_RoutingWorkflow_UTL.agent_tbl_type;
695: l_num_agents NUMBER := 0;
696: l_competency_name VARCHAR2(32);
697: l_call_ID VARCHAR2(32);
698: i INTEGER;

Line 723: CCT_RoutingWorkflow_UTL.InsertResults

719: return;
720: END IF;
721:
722: -- insert the agents into the CCT_TEMPAGENTS table
723: CCT_RoutingWorkflow_UTL.InsertResults
724: (l_call_ID, 'CCT_COMPETENCY_PROD_FILTER' , l_agents_tbl);
725:
726: end if;
727: EXCEPTION

Line 759: l_agents_tbl CCT_RoutingWorkflow_UTL.agent_tbl_type;

755: , funmode in varchar2
756: , resultout in out nocopy varchar2)
757: IS
758: l_proc_name VARCHAR2(30) := 'Set_DNIS_Comp_Filter';
759: l_agents_tbl CCT_RoutingWorkflow_UTL.agent_tbl_type;
760: l_num_agents NUMBER := 0;
761: l_competency_name VARCHAR2(32);
762: l_call_ID VARCHAR2(32);
763: i INTEGER;

Line 788: CCT_RoutingWorkflow_UTL.InsertResults

784: return;
785: END IF;
786:
787: -- insert the agents into the CCT_TEMPAGENTS table
788: CCT_RoutingWorkflow_UTL.InsertResults
789: (l_call_ID, 'CCT_COMPETENCY_PROD_FILTER' , l_agents_tbl);
790:
791: end if;
792: EXCEPTION

Line 840: l_resultcode := CCT_RoutingWorkflow_UTL.Get_Result_Code(

836: CCT_SERVERGROUPROUTING_PUB.Get_Srv_Group_From_MCMID
837: ( p_MCMID => l_MCM_ID ) ;
838:
839: IF (l_SrvGroup IS NOT NULL) THEN
840: l_resultcode := CCT_RoutingWorkflow_UTL.Get_Result_Code(
841: p_result_lookup_type => 'CCT_ServerGroup_Names'
842: , p_result_display_name => l_SrvGroup
843: );
844:

Line 888: l_agents_tbl CCT_RoutingWorkflow_UTL.agent_tbl_type;

884:
885: l_num_agents NUMBER := 0;
886: l_call_ID VARCHAR2(32);
887: l_MCM_ID VARCHAR2(32);
888: l_agents_tbl CCT_RoutingWorkflow_UTL.agent_tbl_type;
889: BEGIN
890: -- set default result
891: resultout := wf_engine.eng_completed ;
892:

Line 911: CCT_RoutingWorkflow_UTL.InsertResults

907: return;
908: END IF;
909:
910: -- insert the agents into the CCT_TEMPAGENTS table
911: CCT_RoutingWorkflow_UTL.InsertResults
912: (l_call_ID, 'CCT_AGENTS_LOGGED_IN_FILTER' , l_agents_tbl);
913: END IF;
914: END Get_Agents_logged_in;
915:

Line 941: l_agents_tbl CCT_RoutingWorkflow_UTL.agent_tbl_type;

937:
938: l_num_agents NUMBER := 0;
939: l_call_ID VARCHAR2(32);
940: l_group_name VARCHAR2(200);
941: l_agents_tbl CCT_RoutingWorkflow_UTL.agent_tbl_type;
942: BEGIN
943: -- set default result
944: resultout := wf_engine.eng_completed ;
945:

Line 966: CCT_RoutingWorkflow_UTL.InsertResults

962: return;
963: END IF;
964:
965: -- insert the agents into the CCT_TEMPAGENTS table
966: CCT_RoutingWorkflow_UTL.InsertResults
967: (l_call_ID, 'CCT_AGENTS_FROM_STAT_GRP_NAM_FILTER' , l_agents_tbl);
968: END IF;
969: END Get_agents_from_stat_grp_nam;
970:

Line 996: l_agents_tbl CCT_RoutingWorkflow_UTL.agent_tbl_type;

992:
993: l_num_agents NUMBER := 0;
994: l_group_number NUMBER default NULL;
995: l_call_ID VARCHAR2(32);
996: l_agents_tbl CCT_RoutingWorkflow_UTL.agent_tbl_type;
997: BEGIN
998: -- set default result
999: resultout := wf_engine.eng_completed ;
1000:

Line 1020: CCT_RoutingWorkflow_UTL.InsertResults

1016: return;
1017: END IF;
1018:
1019: -- insert the agents into the CCT_TEMPAGENTS table
1020: CCT_RoutingWorkflow_UTL.InsertResults
1021: (l_call_ID, 'CCT_AGENTS_FROM_STAT_GRP_NUM_FILTER' , l_agents_tbl);
1022: END IF;
1023: END Get_agents_from_stat_grp_num;
1024:

Line 1050: l_agents_tbl CCT_RoutingWorkflow_UTL.agent_tbl_type;

1046:
1047: l_group_name VARCHAR2(200);
1048: l_num_agents NUMBER := 0;
1049: l_call_ID VARCHAR2(32);
1050: l_agents_tbl CCT_RoutingWorkflow_UTL.agent_tbl_type;
1051: BEGIN
1052: -- set default result
1053: resultout := wf_engine.eng_completed ;
1054:

Line 1073: CCT_RoutingWorkflow_UTL.InsertResults

1069: return;
1070: END IF;
1071:
1072: -- insert the agents into the CCT_TEMPAGENTS table
1073: CCT_RoutingWorkflow_UTL.InsertResults
1074: (l_call_ID, 'CCT_AGENTS_FROM_DYN_GRP_NAM_FILTER' , l_agents_tbl);
1075: END IF;
1076: END Get_agents_from_dyn_grp_nam;
1077: /* -----------------------------------------------------------------------

Line 1102: l_agents_tbl CCT_RoutingWorkflow_UTL.agent_tbl_type;

1098:
1099: l_num_agents NUMBER := 0;
1100: l_group_number VARCHAR2(200);
1101: l_call_ID VARCHAR2(32);
1102: l_agents_tbl CCT_RoutingWorkflow_UTL.agent_tbl_type;
1103: BEGIN
1104: -- set default result
1105: resultout := wf_engine.eng_completed ;
1106:

Line 1125: CCT_RoutingWorkflow_UTL.InsertResults

1121: return;
1122: END IF;
1123:
1124: -- insert the agents into the CCT_TEMPAGENTS table
1125: CCT_RoutingWorkflow_UTL.InsertResults
1126: (l_call_ID, 'CCT_AGENTS_FROM_DYN_GRP_NUM_FILTER' , l_agents_tbl);
1127: END IF;
1128: END Get_agents_from_dyn_grp_num;
1129:

Line 1155: l_agents_tbl CCT_RoutingWorkflow_UTL.agent_tbl_type;

1151:
1152: l_group_name VARCHAR2(200);
1153: l_num_agents NUMBER := 0;
1154: l_call_ID VARCHAR2(32);
1155: l_agents_tbl CCT_RoutingWorkflow_UTL.agent_tbl_type;
1156: BEGIN
1157: -- set default result
1158: resultout := wf_engine.eng_completed ;
1159:

Line 1179: CCT_RoutingWorkflow_UTL.InsertResults

1175: return;
1176: END IF;
1177:
1178: -- insert the agents into the CCT_TEMPAGENTS table
1179: CCT_RoutingWorkflow_UTL.InsertResults
1180: (l_call_ID, 'CCT_AGENTS_NOT_IN_STAT_GRP_NAM_FILTER' , l_agents_tbl);
1181: END IF;
1182: END Get_agents_not_in_stat_grp_nam;
1183:

Line 1209: l_agents_tbl CCT_RoutingWorkflow_UTL.agent_tbl_type;

1205:
1206: l_num_agents NUMBER := 0;
1207: l_group_number VARCHAR2(200);
1208: l_call_ID VARCHAR2(32);
1209: l_agents_tbl CCT_RoutingWorkflow_UTL.agent_tbl_type;
1210: BEGIN
1211: -- set default result
1212: resultout := wf_engine.eng_completed ;
1213:

Line 1232: CCT_RoutingWorkflow_UTL.InsertResults

1228: return;
1229: END IF;
1230:
1231: -- insert the agents into the CCT_TEMPAGENTS table
1232: CCT_RoutingWorkflow_UTL.InsertResults
1233: (l_call_ID, 'CCT_AGENTS_NOT_IN_STAT_GRP_NUM_FILTER' , l_agents_tbl);
1234: END IF;
1235: END Get_agents_not_in_stat_grp_num;
1236:

Line 1262: l_agents_tbl CCT_RoutingWorkflow_UTL.agent_tbl_type;

1258:
1259: l_num_agents NUMBER := 0;
1260: l_group_name VARCHAR2(200);
1261: l_call_ID VARCHAR2(32);
1262: l_agents_tbl CCT_RoutingWorkflow_UTL.agent_tbl_type;
1263: BEGIN
1264: -- set default result
1265: resultout := wf_engine.eng_completed ;
1266:

Line 1284: CCT_RoutingWorkflow_UTL.InsertResults

1280: return;
1281: END IF;
1282:
1283: -- insert the agents into the CCT_TEMPAGENTS table
1284: CCT_RoutingWorkflow_UTL.InsertResults
1285: (l_call_ID, 'CCT_AGENTS_NOT_IN_DYN_GRP_NUM_FILTER' , l_agents_tbl);
1286: END IF;
1287: END Get_agents_not_in_dyn_grp_nam;
1288: /* -----------------------------------------------------------------------

Line 1313: l_agents_tbl CCT_RoutingWorkflow_UTL.agent_tbl_type;

1309:
1310: l_num_agents NUMBER := 0;
1311: l_group_number VARCHAR2(200);
1312: l_call_ID VARCHAR2(32);
1313: l_agents_tbl CCT_RoutingWorkflow_UTL.agent_tbl_type;
1314: BEGIN
1315: -- set default result
1316: resultout := wf_engine.eng_completed ;
1317:

Line 1336: CCT_RoutingWorkflow_UTL.InsertResults

1332: return;
1333: END IF;
1334:
1335: -- insert the agents into the CCT_TEMPAGENTS table
1336: CCT_RoutingWorkflow_UTL.InsertResults
1337: (l_call_ID, 'CCT_AGENTS_NOT_IN_DYN_GRP_NUM_FILTER' , l_agents_tbl);
1338: END IF;
1339: END Get_agents_not_in_dyn_grp_num;
1340: