1 PACKAGE CCT_SERVERGROUPROUTING_PUB AUTHID CURRENT_USER as
2 /* $Header: cctsvgrs.pls 120.0 2005/06/02 09:25:57 appldev noship $ */
3
4 ------------------------------------------------------------------------------
5 -- Function : Get_Srv_Group_from_MCMID
6 -- Usage : Used by the Routing module to get the Name of the Server Group
7 -- Center to which the given MCM is associated
8 -- Parameters :
9 -- p_MCMID IN NUMBER Required
10 --
11 -- Return : VARCHAR2
12 -- This function returns the Name of the Server Group to
13 -- which the given MCM is associated
14 ------------------------------------------------------------------------------
15 FUNCTION Get_Srv_Group_from_MCMID (
16 p_MCMID IN NUMBER
17 )
18 RETURN VARCHAR2;
19
20 FUNCTION Get_Agents_logged_in (
21 p_mcm_id IN NUMBER
22 ,p_agent_tbl OUT nocopy CCT_ROUTINGWORKFLOW_UTL.agent_tbl_type
23 )
24 RETURN number ;
25
26 Procedure Get_AppForClassification(
27 p_classification IN VARCHAR2
28 ,p_mediaTypeUUID IN VARCHAR2
29 ,p_app_id out nocopy NUMBER
30 ,p_app_name out nocopy VARCHAR2);
31
32 END CCT_SERVERGROUPROUTING_PUB;