1 PACKAGE CCT_RoutingWorkflow_PUB AUTHID CURRENT_USER as
2 /* $Header: cctprwfs.pls 120.0 2005/06/02 09:56:34 appldev noship $ */
3
4 ------------------------------------------------------------------------------
5 -- Type : emp_tbl_type
6 -- Usage : Used by the Get_Agent function to temporarily store the routing
7 -- results to faciliate sorting/randomization to limit the number
8 -- of agents returned by the Routing process to 10 agents.
9 ------------------------------------------------------------------------------
10 TYPE agent_tbl_type IS TABLE OF PER_ALL_PEOPLE_F.PERSON_ID%TYPE
11 INDEX BY BINARY_INTEGER;
12
13 TYPE ParamTable IS TABLE OF VARCHAR(200) INDEX BY BINARY_INTEGER;
14 paramHash ParamTable;
15
16 type vc_arr is table of varchar2(32600) index by binary_integer;
17 param_name vc_arr;
18 param_val vc_arr;
19 param_type vc_arr;
20 num_params number := 0;
21
22 procedure KevinTest (
23 p_number IN NUMBER
24 , p_varchar out nocopy VARCHAR2
25 , p_varchar2 IN out nocopy VARCHAR2
26
27 );
28
29
30 /* -----------------------------------------------------------------------
31 Start of comments
32 API Name : Launch_Workflow_Version2
33 Type : Public
34 Description : Launch a Workflow process to route the specified call
35 Wait for workflow completion
36 Get results and send back to Routing Module on Server
37 Parameters :
38 l_return_val is a concatenation of call_id, customer_name, product_name,
39 and the list of agents. The delimiter is ';:;'
40
41 Version : Initial Version 1.0
42
43 End of comments
44 * ----------------------------------------------------------------------*/
45
46 PROCEDURE Launch_Workflow_Version2 (
47 p_mcm_id IN NUMBER
48 , p_call_ID IN VARCHAR2
49 , p_ANI IN VARCHAR2
50 , p_contact_num IN out nocopy VARCHAR2
51 , p_customer_name IN out nocopy VARCHAR2
52 , p_product_name IN out nocopy VARCHAR2
53 , p_contract_num IN out nocopy VARCHAR2
54 , p_customer_ID IN out nocopy NUMBER
55 , p_customer_num IN out nocopy VARCHAR2
56 , p_DNIS IN VARCHAR2
57 , p_inventory_item_ID IN out nocopy NUMBER
58 , p_invoice_num IN out nocopy VARCHAR2
59 , p_lot_num IN out nocopy VARCHAR2
60 , p_order_num IN out nocopy NUMBER
61 , p_problem_code IN out nocopy VARCHAR2
62 , p_po_num IN out nocopy VARCHAR2
63 , p_reference_num IN out nocopy VARCHAR2
64 , p_revision_num IN out nocopy VARCHAR2
65 , p_rma_num IN out nocopy NUMBER
66 , p_screen_pop_type IN out nocopy VARCHAR2
67 , p_serial_num IN out nocopy VARCHAR2
68 , p_sr_num IN out nocopy VARCHAR2
69 , p_system_name IN out nocopy VARCHAR2
70 , p_datetime IN VARCHAR2
71 , p_account_code IN out nocopy VARCHAR2
72 , p_preferred_id IN out nocopy NUMBER
73 , p_promotion_code IN out nocopy VARCHAR2
74 , p_quote_num IN out nocopy VARCHAR2
75 , p_competency_lang IN VARCHAR2
76 , p_competency_know IN VARCHAR2
77 , p_competency_prod IN VARCHAR2
78 , p_customer_product_ID out nocopy NUMBER
79 , p_account_num IN out nocopy NUMBER
80 , p_site_num IN out nocopy NUMBER
81 , p_repair_num IN out nocopy NUMBER
82 , p_defect_num IN out nocopy NUMBER
83 , p_cust_status IN out nocopy VARCHAR2
84 , p_event_code IN out nocopy VARCHAR2
85 , p_coll_req IN out nocopy VARCHAR2
86 , p_classification IN out nocopy VARCHAR2
87 , p_email_icntr_map_id IN out nocopy NUMBER
88 , p_return_val out nocopy VARCHAR2
89 ) ;
90
91
92 -- -----------------------------------------------------------------------
93 -- Start of comments
94 -- API Name : Cancel_Workflow
95 -- Type : Public
96 -- Description : Abort an active Workflow process for the given call
97 -- request.
98 -- Pre-reqs :
99 -- Version : Initial Version 1.0
100 --
101 -- Notes :
102 --
103 -- End of comments
104 -- --------------------------------------------------------------------------
105
106 PROCEDURE Cancel_Workflow (
107 p_api_version IN NUMBER
108 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
109 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
110 , p_return_status out nocopy VARCHAR2
111 , p_msg_count out nocopy NUMBER
112 , p_msg_data out nocopy VARCHAR2
113 , p_call_ID IN NUMBER
114 , p_wf_process_id IN NUMBER
115 , p_user_id IN NUMBER
116 );
117
118
119 -- --------------------------------------------------------------------------
120 -- Start of comments
121 -- API Name : Selector
122 -- Type : Public
123 -- Description : Select a process from among the many possible processes
124 -- for the item.
125 -- Pre-reqs :
126 -- Version : Initial Version 1.0
127 --
128 -- Notes :
129 --
130 -- End of comments
131 -- --------------------------------------------------------------------------
132
133 PROCEDURE Selector (
134 itemtype in varchar2
135 , itemkey in varchar2
136 , actid in number
137 , funmode in varchar2
138 , resultout in out nocopy varchar2
139 );
140
141 -- --------------------------------------------------------------------------
142 -- Start of comments
143 -- API Name : Get_Agents
144 -- Type : Public
145 -- Description : Select the group of agents as determined by the Filter flags
146 -- set.
147 -- Pre-reqs :
148 -- Version : Initial Version 1.0
149 --
150 -- Notes :
151 --
152 -- End of comments
153 -- --------------------------------------------------------------------------
154
155 PROCEDURE Get_Agents (
156 itemtype in varchar2
157 , itemkey in varchar2
158 , actid in number
159 , funmode in varchar2
160 , resultout in out nocopy varchar2
161 );
162
163
164
165 -- --------------------------------------------------------------------------
166 -- Start of comments
167 -- API Name : Decode_Call_Itemkey
168 -- Type : Public
169 -- Description : Given an encoded Routing Request itemkey, this procedure
170 -- will return the components of the key - call ID, and
171 -- workflow process ID.
172 -- Pre-reqs : None
173 -- Parameters :
174 -- p_itemkey IN VARCHAR2 Requried
175 -- p_call_ID out nocopy VARCHAR2 Required
176 -- p_wf_process_id out nocopy NUMBER Required
177 --
178 -- Version : Initial Version 1.0
179 --
180 -- Notes: :
181 --
182 -- End of comments
183 -- ----------------------------------------------------------------------------
184
185 PROCEDURE Decode_Call_Itemkey(
186 p_itemkey IN VARCHAR2
187 , p_call_ID out nocopy VARCHAR2
188 , p_wf_process_ID out nocopy NUMBER
189 );
190
191
192 -- ---------------------------------------------------------------------------
193 -- Start of comments
194 -- API Name : Encode_Call_Itemkey
195 -- Type : Public
196 -- Description : Given a Call ID and a Workflow process
197 -- ID, this procedure will construct the corresponding
198 -- itemkey for the Call item type.
199 -- Pre-reqs : None
200 -- Parameters :
201 -- p_call_ID IN VARCHAR2 Required
202 -- p_wf_process_id IN NUMBER Required
203 -- Return Value
204 -- itemkey VARCHAR2
205 --
206 -- Version : Initial Version 1.0
207 --
208 -- End of comments
209 -- ---------------------------------------------------------------------------
210
211 FUNCTION Encode_Call_Itemkey(
212 p_call_ID IN VARCHAR2
213 , p_wf_process_id IN NUMBER
214 ) return VARCHAR2;
215
216
217 FUNCTION AddParam(
218 p_name VARCHAR2
219 , p_val varchar2
220 , p_type varchar2)
221 return integer;
222
223 procedure init_param_table;
224
225 FUNCTION getParamValue(
226 p_name varchar2)
227 return varchar2;
228
229 procedure setParamValue(
230 p_param varchar2,
231 p_val varchar2);
232
233 PROCEDURE Varchar2Table (
234 InString varchar2);
235
236 PROCEDURE fillParamArray;
237
238 FUNCTION Launch_Workflow_Version4
239 return varchar2;
240
241 FUNCTION Launch_Workflow_Version5(
242 InString varchar2)
243 return varchar2;
244
245 PROCEDURE reroute (
246 itemtype in varchar2
247 , itemkey in varchar2
248 , actid in number
249 , funmode in varchar2
250 , resultout in out nocopy varchar2
251 );
252
253 PROCEDURE number_of_reroutes (
254 itemtype in varchar2
255 , itemkey in varchar2
256 , actid in number
257 , funmode in varchar2
258 , resultout in out nocopy varchar2
259 );
260
261
262 END CCT_RoutingWorkflow_PUB;