1 PACKAGE CCT_RoutingWorkflow_UTL AUTHID CURRENT_USER as
2 /* $Header: cctucros.pls 115.18 2003/01/21 01:03:51 rajayara ship $ */
3
4
5 ------------------------------------------------------------------------------
6 -- Type : agent_tbl_type
7 -- Usage : Used by the Competency Routing functions to return a group
8 -- of agent IDs
9 -- Description : This pre-defined table type stores a collection of agent
10 -- IDs.
11 ------------------------------------------------------------------------------
12
13 TYPE agent_tbl_type IS TABLE OF PER_ALL_PEOPLE_F.PERSON_ID%TYPE
14 INDEX BY BINARY_INTEGER;
15 -----------------------------------------------------------------------------
16
17 ------------------------------------------------------------------------------
18 -- Function : Get_Result_Code
19 -- Usage : Used by the Routing module to get the internal result code
20 -- for a given result lookup type and display name
21 -- Parameters :
22 -- p_result_lookup_type IN VARCHAR2 Required
23 -- p_result_display_name IN VARCHAR2 Required
24 -- Return : VARCHAR2
25 ------------------------------------------------------------------------------
26 FUNCTION Get_Result_Code (
27 p_result_lookup_type IN VARCHAR2
28 , p_result_display_name IN VARCHAR2
29 )
30 RETURN VARCHAR2;
31
32 ------------------------------------------------------------------------------
33 -- PROCEDURE : InsertResults
34 -- Usage : Used by all the filter functions to insert agent results
35 -- into the CCT_TEMPAGENTS tables
36 -- Parameters :
37 -- p_call_ID IN VARCHAR2 Required
38 -- p_filter_type IN VARCHAR2 Required
39 -- p_agent_ID IN out nocopy VARCHAR2 Required
40 ------------------------------------------------------------------------------
41 PROCEDURE InsertResults (
42 p_call_ID IN VARCHAR2
43 , p_filter_type IN VARCHAR2
44 , p_agent_ID IN out nocopy VARCHAR2
45 ) ;
46
47
48 ------------------------------------------------------------------------------
49 -- PROCEDURE : InsertResults
50 -- Usage : Used by all the filter functions to insert agent results
51 -- into the CCT_TEMPAGENTS tables
52 -- Parameters :
53 -- p_call_ID IN VARCHAR2 Required
54 -- p_filter_type IN VARCHAR2 Required
55 -- p_agents_tbl IN out nocopy agent_tbl_type Required
56 ------------------------------------------------------------------------------
57 PROCEDURE InsertResults (
58 p_call_ID IN VARCHAR2
59 , p_filter_type IN VARCHAR2
60 , p_agents_tbl IN out nocopy agent_tbl_type
61 ) ;
62
63
64 ------------------------------------------------------------------------------
65 -- PROCEDURE : InsertResults
66 -- Usage : Used by all the CS filter functions to insert agent results
67 -- into the CCT_TEMPAGENTS tables
68 -- Parameters :
69 -- p_call_ID IN VARCHAR2 Required
70 -- p_filter_type IN VARCHAR2 Required
71 -- p_agents_tbl IN out nocopy CS_ROUTING_UTL.emp_tbl_type Required
72 ------------------------------------------------------------------------------
73 PROCEDURE InsertResults (
74 p_call_ID IN VARCHAR2
75 , p_filter_type IN VARCHAR2
76 , p_agents_tbl IN out nocopy CS_ROUTING_UTL.emp_tbl_type
77 ) ;
78
79 ------------------------------------------------------------------------------
80 -- PROCEDURE : InsertResults
81 -- Usage : Used by all the CS filter functions to insert agent results
82 -- into the CCT_TEMPAGENTS tables
83 -- Parameters :
84 -- p_call_ID IN VARCHAR2 Required
85 -- p_filter_type IN VARCHAR2 Required
86 -- p_agents_tbl IN out nocopy AS_ROUTING_UTIL.emp_tbl_type Required
87 ------------------------------------------------------------------------------
88 --PROCEDURE InsertResults (
89 -- p_call_ID IN VARCHAR2
90 -- , p_filter_type IN VARCHAR2
91 -- , p_agents_tbl IN out nocopy AS_ROUTING_UTIL.emp_tbl_type
92 --) ;
93
94 ------------------------------------------------------------------------------
95 -- PROCEDURE : InsertResults
96 -- Usage : Used by all the AST filter functions to insert agent results
97 -- into the CCT_TEMPAGENTS tables
98 -- Parameters :
99 -- p_call_ID IN VARCHAR2 Required
100 -- p_filter_type IN VARCHAR2 Required
101 -- p_agents_tbl IN out nocopy AST_Routing_PUB.resource_id_tbl_type Required
102 ------------------------------------------------------------------------------
103 PROCEDURE InsertResults (
104 p_call_ID IN VARCHAR2
105 , p_filter_type IN VARCHAR2
106 , p_agents_tbl IN out nocopy AST_Routing_PUB.resource_access_tbl_type) ;
107 ------------------------------------------------------------------------------
108 ------------------------------------------------------------------------------
109
110 -- PROCEDURE : InsertResults
111 -- Usage : Used by all the JTF filter functions to insert agent results
112 -- into the CCT_TEMPAGENTS tables
113 -- Parameters :
114 -- p_call_ID IN VARCHAR2 Required
115 -- p_filter_type IN VARCHAR2 Required
116 -- p_agents_tbl IN out nocopy JTF_TERRITORY_PUB.WinningTerrMember_tbl_type;
117
118 PROCEDURE InsertResults (
119 p_call_ID IN VARCHAR2
120 , p_filter_type IN VARCHAR2
121 , p_agents_tbl IN out nocopy JTF_TERRITORY_PUB.WinningTerrMember_tbl_type
122 ) ;
123
124 END CCT_RoutingWorkflow_UTL;