APPS.CCT_JTFRESOURCEROUTING_PUB dependencies on CCT_ROUTINGWORKFLOW_UTL

Line 13: -- x_agent_tbl OUT CCT_ROUTINGWORKFLOW_UTL.agent_tbl_type

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

Line 24: , x_agent_tbl out nocopy CCT_ROUTINGWORKFLOW_UTL.agent_tbl_type

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:

Line 31: ,p_agent_tbl out nocopy CCT_ROUTINGWORKFLOW_UTL.agent_tbl_type

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 (

Line 37: ,p_agent_tbl out nocopy CCT_ROUTINGWORKFLOW_UTL.agent_tbl_type

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 (

Line 43: ,p_agent_tbl out nocopy CCT_ROUTINGWORKFLOW_UTL.agent_tbl_type

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 (

Line 49: ,p_agent_tbl out nocopy CCT_ROUTINGWORKFLOW_UTL.agent_tbl_type

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 (

Line 55: ,p_agent_tbl out nocopy CCT_ROUTINGWORKFLOW_UTL.agent_tbl_type

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 (

Line 61: ,p_agent_tbl out nocopy CCT_ROUTINGWORKFLOW_UTL.agent_tbl_type

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 (

Line 67: ,p_agent_tbl out nocopy CCT_ROUTINGWORKFLOW_UTL.agent_tbl_type

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 (

Line 73: ,p_agent_tbl out nocopy CCT_ROUTINGWORKFLOW_UTL.agent_tbl_type

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;