APPS.CCT_BANKROUTING_PUB dependencies on CCT_ROUTINGWORKFLOW_UTL

Line 16: l_agents_tbl CCT_RoutingWorkflow_UTL.agent_tbl_type;

12:
13: l_proc_name VARCHAR2(30) := 'Get_Group_from_Profitability';
14: l_customer_id NUMBER;
15: -- l_group_tbl FPT_ROUTING_UTIL.resource_tbl_type;
16: l_agents_tbl CCT_RoutingWorkflow_UTL.agent_tbl_type;
17: l_num_agents NUMBER := 0;
18: l_call_ID VARCHAR2(32);
19: l_num_groups NUMBER :=0;
20: BEGIN

Line 43: l_num_agents := CCT_RoutingWorkflow_UTL.Get_Agents_From_Group_Id(

39: IF (l_num_groups = 0) THEN
40: return;
41: END IF;
42:
43: l_num_agents := CCT_RoutingWorkflow_UTL.Get_Agents_From_Group_Id(
44: l_group_tbl, l_agents_tbl);
45:
46: */
47: IF (l_num_agents = 0) THEN

Line 52: CCT_RoutingWorkflow_UTL.InsertResults

48: return;
49: END IF;
50:
51: -- insert the agents into the CCT_TEMPAGENTS table
52: CCT_RoutingWorkflow_UTL.InsertResults
53: (l_call_ID, 'BNK_AGENT_FROM_PROFITABILITY' , l_agents_tbl);
54:
55: END IF;
56:

Line 74: l_agents_tbl CCT_RoutingWorkflow_UTL.agent_tbl_type;

70:
71: l_proc_name VARCHAR2(30) := 'Get_Group_from_Bank_Id';
72: l_customer_id NUMBER;
73: --l_group_tbl FPT_ROUTING_UTIL.resource_tbl_type;
74: l_agents_tbl CCT_RoutingWorkflow_UTL.agent_tbl_type;
75: l_num_agents NUMBER := 0;
76: l_call_ID VARCHAR2(32);
77: l_num_groups NUMBER :=0;
78:

Line 103: l_num_agents := CCT_RoutingWorkflow_UTL.Get_Agents_From_Group_Id(

99: IF (l_num_groups = 0) THEN
100: return;
101: END IF;
102:
103: l_num_agents := CCT_RoutingWorkflow_UTL.Get_Agents_From_Group_Id(
104: l_group_tbl, l_agents_tbl);
105: */
106:
107: IF (l_num_agents = 0) THEN

Line 112: CCT_RoutingWorkflow_UTL.InsertResults

108: return;
109: END IF;
110:
111: -- insert the agents into the CCT_TEMPAGENTS table
112: CCT_RoutingWorkflow_UTL.InsertResults
113: (l_call_ID, 'BNK_AGENT_FROM_BANK_ID' , l_agents_tbl);
114:
115: END IF;
116:

Line 135: l_agents_tbl CCT_RoutingWorkflow_UTL.agent_tbl_type;

131:
132: l_proc_name VARCHAR2(30) := 'Get_Group_from_Bank_Branch';
133: l_customer_id NUMBER;
134: --l_group_tbl FPT_ROUTING_UTIL.resource_tbl_type;
135: l_agents_tbl CCT_RoutingWorkflow_UTL.agent_tbl_type;
136: l_num_agents NUMBER := 0;
137: l_call_ID VARCHAR2(32);
138: l_num_groups NUMBER :=0;
139:

Line 165: l_num_agents := CCT_RoutingWorkflow_UTL.Get_Agents_From_Group_Id(

161: IF (l_num_groups = 0) THEN
162: return;
163: END IF;
164:
165: l_num_agents := CCT_RoutingWorkflow_UTL.Get_Agents_From_Group_Id(
166: l_group_tbl, l_agents_tbl);
167: */
168: IF (l_num_agents = 0) THEN
169: return;

Line 173: CCT_RoutingWorkflow_UTL.InsertResults

169: return;
170: END IF;
171:
172: -- insert the agents into the CCT_TEMPAGENTS table
173: CCT_RoutingWorkflow_UTL.InsertResults
174: (l_call_ID, 'BNK_AGENT_FROM_BANK_BRANCH' , l_agents_tbl);
175:
176: END IF;
177: