1 PACKAGE CCT_JTFRESOURCEROUTING_PUB AUTHID CURRENT_USER as
2 /* $Header: cctjtfrs.pls 120.0 2005/06/02 10:07:12 appldev noship $ */
3
4 ------------------------------------------------------------------------------
5 -- Function : Get_Agents_For_Competency
6 -- Usage : Used by the Routing module to get the agents assigned to
7 -- the language
8 -- Description : This function retrieves a collection of agent IDs from
9 -- the competency tables given a competency.
10 -- Parameters :
11 -- p_competency_type IN VARCHAR2 Required
12 -- p_competency_name IN VARCHAR2 Required
13 -- x_agent_tbl OUT 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
18 -- to the competency_name).
19 ------------------------------------------------------------------------------
20
21 FUNCTION Get_Agents_For_Competency (
22 p_competency_type IN VARCHAR2
23 , p_competency_name IN VARCHAR2
24 , x_agent_tbl out nocopy CCT_ROUTINGWORKFLOW_UTL.agent_tbl_type
25 )
26 RETURN NUMBER;
27
28
29 FUNCTION Get_agents_from_stat_grp_nam (
30 p_group_name IN VARCHAR2
31 ,p_agent_tbl out nocopy CCT_ROUTINGWORKFLOW_UTL.agent_tbl_type
32 )
33 RETURN number;
34
35 FUNCTION Get_agents_from_stat_grp_num (
36 p_group_number IN VARCHAR2
37 ,p_agent_tbl out nocopy CCT_ROUTINGWORKFLOW_UTL.agent_tbl_type
38 )
39 RETURN number;
40
41 FUNCTION Get_agents_from_dyn_grp_nam (
42 p_group_name IN VARCHAR2
43 ,p_agent_tbl out nocopy CCT_ROUTINGWORKFLOW_UTL.agent_tbl_type
44 )
45 RETURN number;
46
47 FUNCTION Get_agents_from_dyn_grp_num (
48 p_group_number IN VARCHAR2
49 ,p_agent_tbl out nocopy CCT_ROUTINGWORKFLOW_UTL.agent_tbl_type
50 )
51 RETURN number;
52
53 FUNCTION Get_agents_not_in_stat_grp_nam (
54 p_group_name IN VARCHAR2
55 ,p_agent_tbl out nocopy CCT_ROUTINGWORKFLOW_UTL.agent_tbl_type
56 )
57 RETURN number;
58
59 FUNCTION Get_agents_not_in_stat_grp_num (
60 p_group_number IN VARCHAR2
61 ,p_agent_tbl out nocopy CCT_ROUTINGWORKFLOW_UTL.agent_tbl_type
62 )
63 RETURN number;
64
65 FUNCTION Get_agents_not_in_dyn_grp_nam (
66 p_group_name IN VARCHAR2
67 ,p_agent_tbl out nocopy CCT_ROUTINGWORKFLOW_UTL.agent_tbl_type
68 )
69 RETURN number;
70
71 FUNCTION Get_agents_not_in_dyn_grp_num (
72 p_group_number IN VARCHAR2
73 ,p_agent_tbl out nocopy CCT_ROUTINGWORKFLOW_UTL.agent_tbl_type
74 )
75 RETURN number;
76
77 END CCT_JTFRESOURCEROUTING_PUB;