1 PACKAGE CCT_CUSTOMERINIT_PUB as
2 /* $Header: cctcusts.pls 120.0 2005/06/02 09:41:26 appldev noship $ */
3
4 /*------------------------------------------------------------------------
5 Customer Initiation Routing Workflow Activities
6 *------------------------------------------------------------------------*/
7
8 /*------------------------------------------------------------------------
9 Group : Customer Initialization Phase
10 *------------------------------------------------------------------------*/
11
12 /* -----------------------------------------------------------------------
13 1 Activity Name : WF_PartyID_Exists (branch node)
14 To check if the Party ID already exists
15 IN
16 itemtype - item type
17 itemkey - item key
18 actid - process activity instance id
19 funmode - execution mode
20 OUT
21 comparison result (WFSTD_YES_NO lookup code)
22 ITEM ATTRIBUTES REFERENCED
23 PartyID - the party ID
24 *-----------------------------------------------------------------------*/
25 procedure WF_PartyIDExists (
26 itemtype in varchar2
27 , itemkey in varchar2
28 , actid in number
29 , funmode in varchar2
30 , resultout in out nocopy varchar2) ;
31
32 /* -----------------------------------------------------------------------
33 2a Activity Name : WF_Get_PartyID_From_ANI (branch node)
34
35 To Check if the Party ID can be derived from the ANI
36 If multiple matches exist then this does not derive the PartyID.
37 Used by TeleSales application
38 IN
39 itemtype - item type
40 itemkey - item key
41 actid - process activity instance id
42 funmode - execution mode
43 OUT
44 comparison result (WFSTD_YES_NO lookup code)
45 ITEM ATTRIBUTES REFERENCED
46 ANI - the originating phone num
47 PARTYID - the customer ID
48 *-----------------------------------------------------------------------*/
49 procedure WF_PartyIDFromANI (
50 itemtype in varchar2
51 , itemkey in varchar2
52 , actid in number
53 , funmode in varchar2
54 , resultout in out nocopy varchar2) ;
55
56
57 /* -----------------------------------------------------------------------
58
59
60 2b Activity Name : WF_PartyIDFromANI_Multiple (branch node)
61
62 To Check if the Party ID can be derived from the ANI. If multiple
63 matches exist then this derives the first PartyID that matches.
64 Used by Teleservice application
65 IN
66 itemtype - item type
67 itemkey - item key
68 actid - process activity instance id
69 funmode - execution mode
70 OUT
71 comparison result (WFSTD_YES_NO lookup code)
72 ITEM ATTRIBUTES REFERENCED
73 ANI - the originating phone num
74 PARTYID - the PARTY ID
75 *-----------------------------------------------------------------------*/
76 procedure WF_PartyIDFromANI_Multiple (
77 itemtype in varchar2
78 , itemkey in varchar2
79 , actid in number
80 , funmode in varchar2
81 , resultout in out nocopy varchar2) ;
82
83
84 /* -----------------------------------------------------------------------
85 3 Activity Name : WF_PartyIDFromPartyNumber (branch node)
86
87 To Check if the Customer ID can be derived from the Party Number
88 IN
89 itemtype - item type
90 itemkey - item key
91 actid - process activity instance id
92 funmode - execution mode
93 OUT
94 comparison result (WFSTD_YES_NO lookup code)
95 ITEM ATTRIBUTES REFERENCED
96 Party Number - the originating party number
97 PartyID - the customer/party ID
98 *-----------------------------------------------------------------------*/
99
100 procedure WF_PartyIDFromPartyNumber (
101 itemtype in varchar2
102 , itemkey in varchar2
103 , actid in number
104 , funmode in varchar2
105 , resultout in out nocopy varchar2) ;
106
107 /* -----------------------------------------------------------------------
108 3 Activity Name : WF_PartyIDFromQuoteNumber (branch node)
109
110 To Check if the Customer ID can be derived from the Party Number
111 IN
112 itemtype - item type
113 itemkey - item key
114 actid - process activity instance id
115 funmode - execution mode
116 OUT
117 comparison result (WFSTD_YES_NO lookup code)
118 ITEM ATTRIBUTES REFERENCED
119 Quote Number - the originating quote number
120 PartyID - the customer/party ID
121 *-----------------------------------------------------------------------*/
122
123 procedure WF_PartyIDFromQuoteNumber (
124 itemtype in varchar2
125 , itemkey in varchar2
126 , actid in number
127 , funmode in varchar2
128 , resultout in out nocopy varchar2) ;
129
130 /* -----------------------------------------------------------------------
131 4 Activity Name : WF_PartyIDFromOrderNumber (branch node)
132
133 To Check if the Customer ID can be derived from the Party Number
134 IN
135 itemtype - item type
136 itemkey - item key
137 actid - process activity instance id
138 funmode - execution mode
139 OUT
140 comparison result (WFSTD_YES_NO lookup code)
141 ITEM ATTRIBUTES REFERENCED
142 ORDER Number - the originating ORDER number
143 PartyID - the customer/party ID
144 *-----------------------------------------------------------------------*/
145
146 procedure WF_PartyIDFromOrderNumber (
147 itemtype in varchar2
148 , itemkey in varchar2
149 , actid in number
150 , funmode in varchar2
151 , resultout in out nocopy varchar2) ;
152
153 /* -----------------------------------------------------------------------
154 5 Activity Name : WF_PartyIDFromCollateralReq (branch node)
155
156 To Check if the Customer ID can be derived from the Party Number
157 IN
158 itemtype - item type
159 itemkey - item key
160 actid - process activity instance id
161 funmode - execution mode
162 OUT
163 comparison result (WFSTD_YES_NO lookup code)
164 ITEM ATTRIBUTES REFERENCED
165 CollateralRequestNumber - the originating Collateral Request number
166 PartyID - the customer/party ID
167 *-----------------------------------------------------------------------*/
168
169 procedure WF_PartyIDFromCollateralReq (
170 itemtype in varchar2
171 , itemkey in varchar2
172 , actid in number
173 , funmode in varchar2
174 , resultout in out nocopy varchar2) ;
175
176
177 /* -----------------------------------------------------------------------
178 5 Activity Name : WF_PartyIDFromAccountNumber (branch node)
179
180 To Check if the Customer ID can be derived from the Party Number
181 IN
182 itemtype - item type
183 itemkey - item key
184 actid - process activity instance id
185 funmode - execution mode
186 OUT
187 comparison result (WFSTD_YES_NO lookup code)
188 ITEM ATTRIBUTES REFERENCED
189 AccountNumber - the originating Account number
190 PartyID - the customer/party ID
191 *-----------------------------------------------------------------------*/
192
193 procedure WF_PartyIDFromAccountNumber (
194 itemtype in varchar2
195 , itemkey in varchar2
196 , actid in number
197 , funmode in varchar2
198 , resultout in out nocopy varchar2) ;
199
200 /* -----------------------------------------------------------------------
201 5 Activity Name : WF_PartyIDFromEventCode (branch node)
202
203 To Check if the Customer ID can be derived from the Party Number
204 IN
205 itemtype - item type
206 itemkey - item key
207 actid - process activity instance id
208 funmode - execution mode
209 OUT
210 comparison result (WFSTD_YES_NO lookup code)
211 ITEM ATTRIBUTES REFERENCED
212 EventCode - the originating Event Registration Code
213 PartyID - the customer/party ID
214 *-----------------------------------------------------------------------*/
215
216 procedure WF_PartyIDFromEventCode (
217 itemtype in varchar2
218 , itemkey in varchar2
219 , actid in number
220 , funmode in varchar2
221 , resultout in out nocopy varchar2) ;
222
223 /* -----------------------------------------------------------------------
224 5 Activity Name : WF_PartyIDFromMarketingPIN (branch node)
225
226 To Check if the Customer ID can be derived from the Party Number
227 IN
228 itemtype - item type
229 itemkey - item key
230 actid - process activity instance id
231 funmode - execution mode
232 OUT
233 comparison result (WFSTD_YES_NO lookup code)
234 ITEM ATTRIBUTES REFERENCED
235 MarketingPIN - the originating Marketing PIN
236 PartyID - the customer/party ID
237 *-----------------------------------------------------------------------*/
238
239 procedure WF_PartyIDFromMarketingPIN (
240 itemtype in varchar2
241 , itemkey in varchar2
242 , actid in number
243 , funmode in varchar2
244 , resultout in out nocopy varchar2) ;
245
246 /* -----------------------------------------------------------------------
247 5 Activity Name : WF_PartyIDFromContractNum (branch node)
248
249 To Check if the Customer ID can be derived from the Contract Number
250 IN
251 itemtype - item type
252 itemkey - item key
253 actid - process activity instance id
254 funmode - execution mode
255 OUT
256 comparison result (WFSTD_YES_NO lookup code)
257 ITEM ATTRIBUTES REFERENCED
258 ContractNum - the originating ContractNumber
259 ContractNumModifier - the originating Contract Number Modifier
260 PartyID - the customer/party ID
261 *-----------------------------------------------------------------------*/
262
263 procedure WF_PartyIDFromContractNum (
264 itemtype in varchar2
265 , itemkey in varchar2
266 , actid in number
267 , funmode in varchar2
268 , resultout in out nocopy varchar2) ;
269
270 /* -----------------------------------------------------------------------
271 5 Activity Name : WF_PartyIDFromServiceKey (branch node)
272
273 To Check if the Customer ID can be derived from the Party Number
274 IN
275 itemtype - item type
276 itemkey - item key
277 actid - process activity instance id
278 funmode - execution mode
279 OUT
280 comparison result (WFSTD_YES_NO lookup code)
281 ITEM ATTRIBUTES REFERENCED
282 ServiceKey - the originating Service Key
283 PartyID - the customer/party ID
284 *-----------------------------------------------------------------------*/
285
286 procedure WF_PartyIDFromServiceKey (
287 itemtype in varchar2
288 , itemkey in varchar2
289 , actid in number
290 , funmode in varchar2
291 , resultout in out nocopy varchar2) ;
292
293 /* -----------------------------------------------------------------------
294 5 Activity Name : WF_PartyIDFromServiceReqNum (branch node)
295
296 To Check if the Party ID can be derived from the Service Request Number
297 IN
298 itemtype - item type
299 itemkey - item key
300 actid - process activity instance id
301 funmode - execution mode
302 OUT
303 comparison result (WFSTD_YES_NO lookup code)
304 ITEM ATTRIBUTES REFERENCED
305 ServiceRequestNumber- the originating ServiceRequestNumber
306 PartyID - the customer/party ID
307 *-----------------------------------------------------------------------*/
308
309 procedure WF_PartyIDFromServiceReqNum (
310 itemtype in varchar2
311 , itemkey in varchar2
312 , actid in number
313 , funmode in varchar2
314 , resultout in out nocopy varchar2) ;
315
316 /* -----------------------------------------------------------------------
317 5 Activity Name : WF_PartyIDFromInvoiceNum (branch node)
318
319 To Check if the Party ID can be derived from the Invoice Number
320 IN
321 itemtype - item type
322 itemkey - item key
323 actid - process activity instance id
324 funmode - execution mode
325 OUT
326 comparison result (WFSTD_YES_NO lookup code)
327 ITEM ATTRIBUTES REFERENCED
328 InvoiceNumber- the originating InvoiceNumber
329 PartyID - the customer/party ID
330 *-----------------------------------------------------------------------*/
331
332 procedure WF_PartyIDFromInvoiceNum (
333 itemtype in varchar2
334 , itemkey in varchar2
335 , actid in number
336 , funmode in varchar2
337 , resultout in out nocopy varchar2) ;
338
339 /* -----------------------------------------------------------------------
340 Activity Name : WF_PartyIDFromSerialNum (branch node)
341
342 To Check if the Party ID can be derived from the Serial Number
343 IN
344 itemtype - item type
345 itemkey - item key
346 actid - process activity instance id
347 funmode - execution mode
348 OUT
349 comparison result (WFSTD_YES_NO lookup code)
350 ITEM ATTRIBUTES REFERENCED
351 SerialNumber- the originating SerialNumber
352 PartyID - the customer/party ID
353 *-----------------------------------------------------------------------*/
354
355 procedure WF_PartyIDFromSerialNum (
356 itemtype in varchar2
357 , itemkey in varchar2
358 , actid in number
359 , funmode in varchar2
360 , resultout in out nocopy varchar2) ;
361
362 /* -----------------------------------------------------------------------
363 Activity Name : WF_PartyIDFromSystemName (branch node)
364
365 To Check if the Party ID can be derived from the System Name
366 IN
367 itemtype - item type
368 itemkey - item key
369 actid - process activity instance id
370 funmode - execution mode
371 OUT
372 comparison result (WFSTD_YES_NO lookup code)
373 ITEM ATTRIBUTES REFERENCED
374 System Name- the originating System Name
375 PartyID - the customer/party ID
376 *-----------------------------------------------------------------------*/
377
378 procedure WF_PartyIDFromSystemName (
379 itemtype in varchar2
380 , itemkey in varchar2
381 , actid in number
382 , funmode in varchar2
383 , resultout in out nocopy varchar2) ;
384
385 /* -----------------------------------------------------------------------
386 Activity Name : WF_PartyNameFromPartyID (branch node)
387
388 To Check if the Party Name can be derived from the Party ID
389 IN
390 itemtype - item type
391 itemkey - item key
392 actid - process activity instance id
393 funmode - execution mode
394 OUT
395 comparison result (WFSTD_YES_NO lookup code)
396 ITEM ATTRIBUTES REFERENCED
397 PartyID - the customer/party ID
398 Party Name - the customer/party name
399 *-----------------------------------------------------------------------*/
400
401 procedure WF_PartyNameFromPartyID (
402 itemtype in varchar2
403 , itemkey in varchar2
404 , actid in number
405 , funmode in varchar2
406 , resultout in out nocopy varchar2) ;
407
408
409 END CCT_CUSTOMERINIT_PUB;