DBA Data[Home] [Help]

APPS.CCT_PERFTEST_PKG dependencies on CCT_ROUTINGWORKFLOW_UTL

Line 12: l_agents_tbl CCT_ROUTINGWORKFLOW_UTL.agent_tbl_type;

8: , funmode in varchar2
9: , resultout in out nocopy varchar2
10: ) IS
11: l_proc_name VARCHAR2(30) :='DNIS_STATICGROUP_FILTER';
12: l_agents_tbl CCT_ROUTINGWORKFLOW_UTL.agent_tbl_type;
13: l_num_agents Number:=0;
14: l_dnis VARCHAR2(32);
15: l_call_ID VARCHAR2(32);
16: l_static_group VARCHAR2(64);

Line 37: CCT_RoutingWorkflow_UTL.InsertResults

33: return;
34: END IF;
35:
36: -- insert the agents into the CCT_TEMPAGENTS table
37: CCT_RoutingWorkflow_UTL.InsertResults
38: (l_call_ID, 'CCT_DNIS_SG_FILTER' , l_agents_tbl);
39:
40: end if;
41:

Line 51: x_agent_tbl IN OUT nocopy CCT_ROUTINGWORKFLOW_UTL.agent_tbl_type

47:
48: END DNIS_STATICGROUP_FILTER;
49: Function Get_SGAgents_for_DNIS(
50: p_dnis IN VARCHAR2,
51: x_agent_tbl IN OUT nocopy CCT_ROUTINGWORKFLOW_UTL.agent_tbl_type
52: )
53: RETURN NUMBER is
54: l_total_num_of_agents NUMBER:=0;
55: l_group_name VARCHAR2(64);

Line 71: -- l_total_num_of_agents:=CCT_ROUTINGWORKFLOW_UTL.get_agents_from_stat_grp_nam(l_group_name,x_agent_tbl);

67: else
68: l_group_name:='60DNISGroup';
69: end if;
70: x_agent_tbl.delete;
71: -- l_total_num_of_agents:=CCT_ROUTINGWORKFLOW_UTL.get_agents_from_stat_grp_nam(l_group_name,x_agent_tbl);
72: l_total_num_of_agents:=0;
73: return l_total_num_of_agents;
74:
75: Exception