APPS.CCT_JTFRESOURCEROUTING_PUB dependencies on CCT_ROUTINGWORKFLOW_UTL

Line 13: -- x_agent_tbl out nocopy CCT_ROUTINGWORKFLOW_UTL.agent_tbl_type

9: -- the competency tables given a comp name and type.
10: -- Parameters :
11: -- p_competency_type IN VARCHAR2 Required
12: -- p_competency_name IN VARCHAR2 Required
13: -- x_agent_tbl out nocopy CCT_ROUTINGWORKFLOW_UTL.agent_tbl_type
14: --
15: -- Return : NUMBER
16: -- This function returns the number of agents assigned to
17: -- the given competency_name (0 if there is no agent assigned

Line 23: , x_agent_tbl out nocopy CCT_ROUTINGWORKFLOW_UTL.agent_tbl_type

19: ------------------------------------------------------------------------------
20: FUNCTION Get_Agents_For_Competency (
21: p_competency_type IN VARCHAR2
22: , p_competency_name IN VARCHAR2
23: , x_agent_tbl out nocopy CCT_ROUTINGWORKFLOW_UTL.agent_tbl_type
24: )
25: RETURN NUMBER IS
26:
27: v_total_num_of_emps NUMBER:=0;

Line 73: ,p_agent_tbl out nocopy CCT_ROUTINGWORKFLOW_UTL.agent_tbl_type

69:
70:
71: FUNCTION Get_agents_from_stat_grp_nam (
72: p_group_name IN VARCHAR2
73: ,p_agent_tbl out nocopy CCT_ROUTINGWORKFLOW_UTL.agent_tbl_type
74: )
75: RETURN number IS
76:
77: l_total_num_of_agents NUMBER:=0;

Line 123: ,p_agent_tbl out nocopy CCT_ROUTINGWORKFLOW_UTL.agent_tbl_type

119: END Get_agents_from_stat_grp_nam;
120:
121: FUNCTION Get_agents_from_stat_grp_num (
122: p_group_number IN VARCHAR2
123: ,p_agent_tbl out nocopy CCT_ROUTINGWORKFLOW_UTL.agent_tbl_type
124: )
125: RETURN number IS
126:
127: l_total_num_of_agents NUMBER:=0;

Line 171: ,p_agent_tbl out nocopy CCT_ROUTINGWORKFLOW_UTL.agent_tbl_type

167: END Get_agents_from_stat_grp_num;
168:
169: FUNCTION Get_agents_from_dyn_grp_nam (
170: p_group_name IN VARCHAR2
171: ,p_agent_tbl out nocopy CCT_ROUTINGWORKFLOW_UTL.agent_tbl_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;

Line 228: ,p_agent_tbl out nocopy CCT_ROUTINGWORKFLOW_UTL.agent_tbl_type

224: END Get_agents_from_dyn_grp_nam;
225:
226: FUNCTION Get_agents_from_dyn_grp_num (
227: p_group_number IN VARCHAR2
228: ,p_agent_tbl out nocopy CCT_ROUTINGWORKFLOW_UTL.agent_tbl_type
229: )
230: RETURN number IS
231: l_total_num_of_agents NUMBER:=0;
232: l_text jtf_rs_dynamic_groups_b.sql_text%TYPE;

Line 287: ,p_agent_tbl out nocopy CCT_ROUTINGWORKFLOW_UTL.agent_tbl_type

283: END Get_agents_from_dyn_grp_num;
284:
285: FUNCTION Get_agents_not_in_stat_grp_nam (
286: p_group_name IN VARCHAR2
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;

Line 364: ,p_agent_tbl out nocopy CCT_ROUTINGWORKFLOW_UTL.agent_tbl_type

360: END Get_agents_not_in_stat_grp_nam;
361:
362: FUNCTION Get_agents_not_in_stat_grp_num (
363: p_group_number IN VARCHAR2
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;

Line 443: ,p_agent_tbl out nocopy CCT_ROUTINGWORKFLOW_UTL.agent_tbl_type

439:
440:
441: FUNCTION Get_agents_not_in_dyn_grp_nam (
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);

Line 517: ,p_agent_tbl out nocopy CCT_ROUTINGWORKFLOW_UTL.agent_tbl_type

513: END Get_agents_not_in_dyn_grp_nam;
514:
515: FUNCTION Get_agents_not_in_dyn_grp_num (
516: p_group_number IN VARCHAR2
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;