APPS.CCT_JTFRESOURCEROUTING_PUB dependencies on CCT_AGENT_RT_STATS

Line 79: l_agent_id cct_agent_rt_stats.agent_id%TYPE;

75: RETURN number IS
76:
77: l_total_num_of_agents NUMBER:=0;
78: l_group_id jtf_rs_groups_vl.group_id%TYPE;
79: l_agent_id cct_agent_rt_stats.agent_id%TYPE;
80:
81:
82:
83: CURSOR csr_agents IS

Line 128: l_agent_id cct_agent_rt_stats.agent_id%TYPE;

124: )
125: RETURN number IS
126:
127: l_total_num_of_agents NUMBER:=0;
128: l_agent_id cct_agent_rt_stats.agent_id%TYPE;
129: l_group_id jtf_rs_groups_vl.group_id%TYPE;
130:
131:
132: CURSOR csr_agents IS

Line 176: l_agent_id cct_agent_rt_stats.agent_id%TYPE;

172: )
173: RETURN number IS
174: l_total_num_of_agents NUMBER:=0;
175: l_text jtf_rs_dynamic_groups_b.sql_text%TYPE;
176: l_agent_id cct_agent_rt_stats.agent_id%TYPE;
177: l_select_csr INTEGER;
178: l_sort_num NUMBER := 0;
179: l_dummy INTEGER;
180:

Line 234: l_agent_id cct_agent_rt_stats.agent_id%TYPE;

230: RETURN number IS
231: l_total_num_of_agents NUMBER:=0;
232: l_text jtf_rs_dynamic_groups_b.sql_text%TYPE;
233: l_dummy INTEGER;
234: l_agent_id cct_agent_rt_stats.agent_id%TYPE;
235: l_sort_num NUMBER := 0;
236:
237: l_select_csr INTEGER;
238:

Line 291: l_agent_id cct_agent_rt_stats.agent_id%TYPE;

287: ,p_agent_tbl out nocopy CCT_ROUTINGWORKFLOW_UTL.agent_tbl_type
288: )
289: RETURN number IS
290: l_total_num_of_agents NUMBER:=0;
291: l_agent_id cct_agent_rt_stats.agent_id%TYPE;
292:
293:
294: CURSOR csr_agents IS
295: select res.resource_id

Line 368: l_agent_id cct_agent_rt_stats.agent_id%TYPE;

364: ,p_agent_tbl out nocopy CCT_ROUTINGWORKFLOW_UTL.agent_tbl_type
365: )
366: RETURN number IS
367: l_total_num_of_agents NUMBER:=0;
368: l_agent_id cct_agent_rt_stats.agent_id%TYPE;
369:
370:
371: CURSOR csr_agents IS
372: select res.resource_id

Line 446: l_agent_id cct_agent_rt_stats.agent_id%TYPE;

442: p_group_name IN VARCHAR2
443: ,p_agent_tbl out nocopy CCT_ROUTINGWORKFLOW_UTL.agent_tbl_type
444: )
445: RETURN number IS
446: l_agent_id cct_agent_rt_stats.agent_id%TYPE;
447: l_default_select VARCHAR2(4000);
448: l_apos VARCHAR2(4) := '''';
449: l_query VARCHAR2(5000);
450: l_text jtf_rs_dynamic_groups_b.sql_text%TYPE;

Line 521: l_agent_id cct_agent_rt_stats.agent_id%TYPE;

517: ,p_agent_tbl out nocopy CCT_ROUTINGWORKFLOW_UTL.agent_tbl_type
518: )
519: RETURN number IS
520:
521: l_agent_id cct_agent_rt_stats.agent_id%TYPE;
522: l_default_select VARCHAR2(4000);
523: l_apos VARCHAR2(4) := '''';
524: l_query VARCHAR2(5000);
525: l_text jtf_rs_dynamic_groups_b.sql_text%TYPE;