1 PACKAGE XNP_STANDARD AUTHID CURRENT_USER AS
2 /* $Header: XNPSTACS.pls 120.1 2005/06/24 04:46:11 appldev ship $ */
3
4
5 -- BUG # 1500177
6 -- used by publish in the generated code to pass correct fe_name to push()
7
8 FE_NAME VARCHAR2(40) := NULL;
9
10 -- Extracts the order information from SFM
11 -- WI params
12 -- Called when: There is a Create Ported Number
13 -- request from NRC
14 -- Called by: XNP_STANDARD.SMS_CREATE_PORTED_NUMBER
15 -- Mandatory WI Params: Gets the PORTING_ID, STARTING_NUMBER, ENDING_NUMBER,
16 -- PORTING_TIME,ROUTING_NUMBER
17 -- Optional WI Params: CNAM_ADDRESS, CNAM_SUBSYSTEM,
18 -- ISVM_ADDRESS, ISVM_SUBSYSTEM, LIDB_ADDRESS, LIDB_SUBSYSTEM,
19 -- CLASS_ADDRESS, CLASS_SUBSYSTEM, WSMSC_ADDRESS, WSMSC_SUBSYSTEM,
20 -- RN_ADDRESS, RN_SUBSYSTEM , SUBSCRIPTION_TYPE
21 -- Creates an entry in SMS table for each TN in the range
22
23 PROCEDURE SMS_CREATE_PORTED_NUMBER
24 (
25 p_ORDER_ID IN NUMBER,
26 p_LINEITEM_ID IN NUMBER,
27 p_WORKITEM_INSTANCE_ID IN NUMBER,
28 p_FA_INSTANCE_ID IN NUMBER,
29 x_ERROR_CODE OUT NOCOPY NUMBER,
30 x_ERROR_MESSAGE OUT NOCOPY VARCHAR2
31 );
32
33 -- Extracts the order information from SFM Workitem params table
34 -- Gets the STARTING_NUMBER, ENDING_NUMBER
35 -- and calls XNP_CORE.SMS_DELETE_PORTED_NUMBER
36 -- Called when: There is a Delete Ported Number
37 -- request from NRC
38 -- Called by: XNP_STANDARD.SMS_DELETE_PORTED_NUMBER
39 --
40 PROCEDURE SMS_DELETE_PORTED_NUMBER
41 (p_WORKITEM_INSTANCE_ID IN NUMBER
42 ,x_ERROR_CODE OUT NOCOPY NUMBER
43 ,x_ERROR_MESSAGE OUT NOCOPY VARCHAR2
44 );
45
46 -- Updates SV in SOA table for each TN in the range
47 -- with the invoice infomation
48 -- Mandatory WI Params : STARTING_NUMBER ENDING_NUMBER, SP_NAME
49 -- Optional WI Params : INVOICE_DUE_DATE, CHARGING_INFO, BILLING_ID,
50 -- USER_LOCTN_VALUE, USER_LOCTN_TYPE
51 --
52 -- Called when: Recipient requested port succeeds
53 -- Called by: XNP_STANDARD.SOA_UPDATE_CHARGING_INFO
54
55 PROCEDURE SOA_UPDATE_CHARGING_INFO
56 (p_ORDER_ID IN NUMBER,
57 p_LINEITEM_ID IN NUMBER,
58 p_WORKITEM_INSTANCE_ID IN NUMBER,
59 p_FA_INSTANCE_ID IN NUMBER,
60 p_CUR_STATUS_TYPE_CODE VARCHAR2,
61 x_ERROR_CODE OUT NOCOPY NUMBER,
62 x_ERROR_MESSAGE OUT NOCOPY VARCHAR2
63 );
64
65 -- Extracts the order information from SFM Workitem params table
66 -- namely STARTING_NUMBER,
67 -- ENDING_NUMBER, OLD_SP_CUTOFF_DUE_DATE
68 --
69 -- Calls XNP_CORE.SOA_UPDATE_CUTOFF_DATE to update the
70 -- cutoff date and the new status of each TN in the range
71 -- Called by: XNP_WF_STANDARD.SOA_UPDATE_CUTOFF_DATE
72
73 PROCEDURE SOA_UPDATE_CUTOFF_DATE
74 (p_ORDER_ID IN NUMBER,
75 p_LINEITEM_ID IN NUMBER,
76 p_WORKITEM_INSTANCE_ID IN NUMBER,
77 p_FA_INSTANCE_ID IN NUMBER,
78 p_CUR_STATUS_TYPE_CODE VARCHAR2,
79 x_ERROR_CODE OUT NOCOPY NUMBER,
80 x_ERROR_MESSAGE OUT NOCOPY VARCHAR2
81 );
82
83 -- Updates corresponding rows in the the SOA table based on SP type (i.e. donor or recipient)
84 -- All necessary values are got from the workitems table
85 -- Mandatory WI params : STARTING_NUMBER, ENDING_NUMBER,
86 -- DONOR_SP_ID,RECIPIENT_SP_ID,NEW_SP_DUE_DATE,ROUTING_NUMBER
87 -- Optional WI Params: OLD_SP_CUTOFF_DUE_DATE,CUSTOMER_ID,
88 -- CUSTOMER_NAME,ADDRESS_LINE1,CITY,PHONE,FAX,EMAIL,ZIP_CODE,
89 -- RETAIN_TN_FLAG,CUSTOMER_CONTACT_REQ_FLAG,
90 -- RETAIN_DIR_INFO_FLAG,CONTACT_NAME, CNAM_ADDRESS,
91 -- CNAM_SUBSYSTEM, ISVM_ADDRESS, ISVM_SUBSYSTEM, LIDB_ADDRESS,
92 -- LIDB_SUBSYSTEM, CLASS_ADDRESS, CLASS_SUBSYSTEM, WSMSC_ADDRESS,
93 -- WSMSC_SUBSYSTEM, RN_ADDRESS, RN_SUBSYSTEM, PAGER, PAGER_PIN,
94 -- INTERNET_ADDRESS, PREORDER_AUTHORIZATION_CODE, ACTIVATION_DUE_DATE
95 -- SUBSCRIPTION_TYPE
96 -- Called when: There is a order Peer's Porting
97 -- Order or OMS porting order
98 -- Called by: XNP_WF_STANDARD.SOA_CREATE_PORTING_ORDER
99 -- SV Status: Status with initial flag as true
100
101 PROCEDURE SOA_CREATE_PORTING_ORDER
102 (p_ORDER_ID IN NUMBER,
103 p_LINEITEM_ID IN NUMBER,
104 p_WORKITEM_INSTANCE_ID IN NUMBER,
105 p_FA_INSTANCE_ID IN NUMBER,
106 p_SP_ROLE VARCHAR2,
107 x_ERROR_CODE OUT NOCOPY NUMBER,
108 x_ERROR_MESSAGE OUT NOCOPY VARCHAR2
109 );
110
111 -- Gets the WI parameter PORTING_ID
112 -- and calls XNP_CORE.SOA_CHECK_NOTIFY_DIR_SVS
113 -- Called by:Donor's XNP_WF_STANDARD.SOA_CHECK_NOTIFY_DIR_SVS
114 -- @return 'Y' if true
115
116 PROCEDURE SOA_CHECK_NOTIFY_DIR_SVS
117 (
118 p_WORKITEM_INSTANCE_ID IN NUMBER
119 ,x_CHECK_STATUS OUT NOCOPY VARCHAR2
120 ,x_ERROR_CODE OUT NOCOPY NUMBER
121 ,x_ERROR_MESSAGE OUT NOCOPY VARCHAR2
122 );
123
124 -- Extracts the (LOCAL)SP_NAME and compares it to donor,recipient
125 -- If either of them don't match checks
126 -- if its INITIAL DONOR.
127 -- WI parameters are referenced STARTING_NUMBER,
128 -- ENDING_NUMBER, DONOR_SP_ID,SP_NAME,RECIPIENT_SP_ID
129 -- Returns: DONOR, ORIG_DONOR, RECIPIENT
130 -- Called at: donor sp when need to check if its the
131 -- initial donor
132 -- Called by:Donor XNP_WF_STANDARD.DETERMINE_SP_ROLE
133
134 PROCEDURE DETERMINE_SP_ROLE
135 (p_WORKITEM_INSTANCE_ID IN NUMBER
136 ,x_SP_ROLE OUT NOCOPY VARCHAR2
137 ,x_ERROR_CODE OUT NOCOPY NUMBER
138 ,x_ERROR_MESSAGE OUT NOCOPY VARCHAR2
139 );
140
141
142 -- Procedure used to update the status of a SV
143 -- in XNP_SV_SOA to the given status
144 -- Using the WI_ID the starting and ending TN
145 -- is found to derive the SV
146 -- The foll WI parameters are checked STARTING_NUMBER,
147 -- ENDING_NUMBER, PORTING_ID
148
149 PROCEDURE SOA_UPDATE_SV_STATUS
150 (p_ORDER_ID IN NUMBER,
151 p_LINEITEM_ID IN NUMBER,
152 p_WORKITEM_INSTANCE_ID IN NUMBER,
153 p_FA_INSTANCE_ID IN NUMBER,
154 p_CUR_STATUS_TYPE_CODE VARCHAR2,
155 p_NEW_STATUS_TYPE_CODE VARCHAR2,
156 p_STATUS_CHANGE_CAUSE_CODE VARCHAR2,
157 x_ERROR_CODE OUT NOCOPY NUMBER,
158 x_ERROR_MESSAGE OUT NOCOPY VARCHAR2
159 );
160
161 -- Update the status of the Porting Order Records to the new status
162 -- for the given PORTING_ID
163 -- (a.k.a OBJECT_REFERENCE) and
164 -- belonging to the (local) SP ID.
165 -- Called when: need to update the SV status according
166 -- to the activity parameter SV_STATUS
167 -- Gets the Item Attributes WORKITEM_INSTANCE
168 -- Calls XNP_CORE.SOA_UPDATE_SV_STATUS
169
170 PROCEDURE SOA_UPDATE_SV_STATUS
171 (p_ORDER_ID IN NUMBER,
172 p_LINEITEM_ID IN NUMBER,
173 p_WORKITEM_INSTANCE_ID IN NUMBER,
174 p_FA_INSTANCE_ID IN NUMBER,
175 p_NEW_STATUS_TYPE_CODE VARCHAR2,
176 p_STATUS_CHANGE_CAUSE_CODE VARCHAR2,
177 x_ERROR_CODE OUT NOCOPY NUMBER,
178 x_ERROR_MESSAGE OUT NOCOPY VARCHAR2
179 );
180
181 -- Gets the TN range and calls XNP_CORE.SOA_CHECK_ORDER_STATUS
182 -- References the following WI parameter
183 -- ORDER_STATUS
184 -- Called when: Inquiry or Order response is awaited
185
186 PROCEDURE SOA_CHECK_ORDER_STATUS
187 (p_WORKITEM_INSTANCE_ID IN NUMBER
188 ,x_ORDER_STATUS OUT NOCOPY VARCHAR2
189 ,x_error_code OUT NOCOPY NUMBER
190 ,x_error_message OUT NOCOPY VARCHAR2
191 );
192
193 -- Checks if the records in the given status
194 -- @return 'Y' if true
195 --
196
197 PROCEDURE CHECK_SOA_STATUS_EXISTS
198 (p_WORKITEM_INSTANCE_ID NUMBER
199 ,p_STATUS_TYPE_CODE VARCHAR2
200 ,x_CHECK_STATUS OUT NOCOPY VARCHAR2
201 ,x_error_code OUT NOCOPY NUMBER
202 ,x_error_message OUT NOCOPY VARCHAR2
203 );
204
205
206 -- Sets the ORDER_RESULT work item parameter value to give one
207
208 PROCEDURE SET_ORDER_RESULT
209 (p_WORKITEM_INSTANCE_ID NUMBER
210 ,p_ORDER_RESULT VARCHAR2
211 ,p_ORDER_REJECT_CODE VARCHAR2
212 ,p_ORDER_REJECT_EXPLN VARCHAR2
213 ,x_error_code OUT NOCOPY NUMBER
214 ,x_error_message OUT NOCOPY VARCHAR2
215 );
216
217 -- Publishes a single business event
218 -- The recipients of this event should have
219 -- already subscribed for it incase of
220 -- internal events
221 --
222 -- Note:
223 -- EVENT TYPE: The message/event type to send
224 -- PARAM LIST: gives names of the
225 -- workitem parameters which contain the values.
226 -- E.g. of format could be
227 -- S=$STARTING_NUMBER,E=$ENDING_NUMBER
228 --
229 -- CALLBACK_REF_ID: Gives the callback handle.
230
231 PROCEDURE PUBLISH_EVENT
232 (p_ORDER_ID NUMBER
233 ,p_WORKITEM_INSTANCE_ID NUMBER
234 ,p_FA_INSTANCE_ID NUMBER
235 ,p_EVENT_TYPE VARCHAR2
236 ,p_PARAM_LIST VARCHAR2
237 ,p_CALLBACK_REF_ID VARCHAR2
238 ,x_error_code OUT NOCOPY NUMBER
239 ,x_error_message OUT NOCOPY VARCHAR2
240 );
241
242 -- Sends a message to a single recipient
243 -- The recipients of this event should have
244 -- already subscribed for it incase of
245 -- internal events
246 -- WI Params:
247 -- ORDER ID: order id of this SFM order
248 -- EVENT TYPE: The message/event type to send
249 -- PARAM LIST: gives names of the
250 -- workitem parameters which contain the values.
251 -- E.g. of format could be
252 -- S=$STARTING_NUMBER,E=$ENDING_NUMBER
253 -- WORKITEM INSTANCE ID:gives the handle to fetch
254 -- the values.
255 -- CONSUMER: gives the procedure to get the fe name
256 -- (or adapter name) of the receiver
257 -- CALLBACK_REF_ID: Gives the callback handle.
258 -- RECEIVER: gives the procedure to get the recipient name
259 -- VERSION: Version number of the message
260 -- Mandatory WI params : Whatever parameter mentioned
261 -- in the 'PARAM LIST' and additional workitem parameter which
262 -- are configured as part of the message type definition.
263 --
264 -- The send procedure first checks if an adapter is available for
265 -- the recipient of the message and then goes ahead with the send.
266 -- If the adapter is not ready, an callback is registered to get
267 -- notified once the adapter is available.
268 --
269 -- @return XNP_ERRORS.G_ADAPTER_NOT_READY if ADAPTER is not ready
270 --
271 PROCEDURE SEND_MESSAGE
272 (p_ORDER_ID NUMBER
273 ,p_WORKITEM_INSTANCE_ID NUMBER
274 ,p_FA_INSTANCE_ID NUMBER
275 ,p_EVENT_TYPE VARCHAR2
276 ,p_PARAM_LIST VARCHAR2
277 ,p_CALLBACK_REF_ID VARCHAR2
278 ,p_CONSUMER VARCHAR2
279 ,p_RECEIVER VARCHAR2
280 ,p_VERSION NUMBER
281 ,x_error_code OUT NOCOPY NUMBER
282 ,x_error_message OUT NOCOPY VARCHAR2
283 );
284
285 -- Calls XNP_CORE.SMS_DELETE_FE_MAP
286 -- References WI params STARTING_NUMBER, ENDING_NUMBER
287 -- Called when: During provisioning phase of the order
288 --
289 PROCEDURE SMS_DELETE_FE_MAP
290 (p_WORKITEM_INSTANCE_ID IN NUMBER
291 ,p_FE_ID IN NUMBER
292 ,p_FEATURE_TYPE VARCHAR2
293 ,x_ERROR_CODE OUT NOCOPY NUMBER
294 ,x_ERROR_MESSAGE OUT NOCOPY VARCHAR2
295 );
296
297 -- Gets the TN range for the given order
298 -- and checks if There exists a TN in the
299 -- given phase with the local SP performing
300 -- the given role
301 -- Mandatory WI params: STARTING_NUMBER,
302 -- ENDING_NUMBER, SP_NAME, PORTING_ID
303 --
304 PROCEDURE CHECK_PHASE_FOR_ROLE
305 (p_WORKITEM_INSTANCE_ID IN NUMBER
306 ,p_SP_ROLE IN VARCHAR2
307 ,p_PHASE_INDICATOR IN VARCHAR2
308 ,x_CHECK_STATUS OUT NOCOPY VARCHAR2
309 ,x_ERROR_CODE OUT NOCOPY NUMBER
310 ,x_ERROR_MESSAGE OUT NOCOPY VARCHAR2
311 );
312
313 -- Wrapper function for XDP_ENGINE package
314 -- Catches execptions incase of undefined
315 -- values. Ignores NO_DATA_FOUND errors
316 --
317 FUNCTION GET_WORKITEM_PARAM_VALUE
318 (p_WORKITEM_INSTANCE_ID NUMBER
319 ,p_PARAMETER_NAME VARCHAR2
320 )
321 RETURN VARCHAR2;
322
323 -- Wrapper function for XDP_ENGINE package
324 -- Catches execptions incase of undefined
325 -- values. A workflow notification is sent
326 -- in case of exceptions
327 --
328 PROCEDURE SET_MANDATORY_WI_PARAM_VALUE
329 (p_WORKITEM_INSTANCE_ID NUMBER
330 ,p_PARAMETER_NAME VARCHAR2
331 ,p_PARAMETER_VALUE VARCHAR2
332 ,p_PARAMETER_REFERENCE_VALUE IN VARCHAR2 DEFAULT NULL
333 );
334
335 -- Wrapper function for XDP_ENGINE package
336 -- Catches execptions incase of undefined
337 -- values. raises NO_DATA_FOUND errors and
338 -- logs it in the wf_core.context information
339 --
340 FUNCTION GET_MANDATORY_WI_PARAM_VALUE
341 (p_WORKITEM_INSTANCE_ID NUMBER
342 ,p_PARAMETER_NAME VARCHAR2
343 )
344 RETURN VARCHAR2;
345
346 -- Wrapper function for XDP_ENGINE package
347 -- Catches execptions incase of undefined
348 -- values
349 --
350 PROCEDURE SET_WORKITEM_PARAM_VALUE
351 (p_WORKITEM_INSTANCE_ID NUMBER
352 ,p_PARAMETER_NAME VARCHAR2
353 ,p_PARAMETER_VALUE VARCHAR2
354 ,p_PARAMETER_REFERENCE_VALUE IN VARCHAR2 DEFAULT NULL
355 );
356
357
358 -- Registers a callback for the given event
359 -- from the remote or local system.
360 -- Calls XNP_EVENT.SUBSCRIBE
361 --
362 PROCEDURE SUBSCRIBE_FOR_EVENT
363 (p_MESSAGE_TYPE IN VARCHAR2
364 ,p_WORKITEM_INSTANCE_ID IN NUMBER
365 ,p_CALLBACK_REF_ID VARCHAR2
366 ,p_PROCESS_REFERENCE IN VARCHAR2
367 ,p_ORDER_ID NUMBER
368 ,p_FA_INSTANCE_ID NUMBER
369 ,x_ERROR_CODE OUT NOCOPY NUMBER
370 ,x_ERROR_MESSAGE OUT NOCOPY VARCHAR2
371 );
372
373 -- Checks if this is a subsequent porting request
374 -- @return Y or N
375 -- Expects the WI paramter 'SUBSEQUENT_PORT'
376 --
377 PROCEDURE SOA_IS_SUBSEQUENT_PORT
378 (p_WORKITEM_INSTANCE_ID IN NUMBER
379 ,x_CHECK_STATUS OUT NOCOPY VARCHAR2
380 ,x_ERROR_CODE OUT NOCOPY NUMBER
381 ,x_ERROR_MESSAGE OUT NOCOPY VARCHAR2
382 );
383
384 -- Updates the SMS_FE_MAP status for the SVs corresponding to the given TNs
385 -- to the new PROVISION_STATUS
386 --
387 PROCEDURE SMS_UPDATE_FE_MAP_STATUS
388 (p_ORDER_ID IN NUMBER,
389 p_LINEITEM_ID IN NUMBER,
390 p_WORKITEM_INSTANCE_ID IN NUMBER,
391 p_FA_INSTANCE_ID IN NUMBER,
392 p_FEATURE_TYPE VARCHAR2,
393 p_FE_ID NUMBER,
394 p_PROV_STATUS VARCHAR2,
395 x_ERROR_CODE OUT NOCOPY NUMBER,
396 x_ERROR_MESSAGE OUT NOCOPY VARCHAR2
397 );
398
399 -- Extracts the order information from SFM WI parameters
400 -- Mandatory WI Params: Gets the PORTING_ID, STARTING_NUMBER, ENDING_NUMBER,
401 -- PORTING_TIME,ROUTING_NUMBER
402 -- Optional WI Params: CNAM_ADDRESS, CNAM_SUBSYSTEM,
403 -- ISVM_ADDRESS, ISVM_SUBSYSTEM, LIDB_ADDRESS, LIDB_SUBSYSTEM,
404 -- CLASS_ADDRESS, CLASS_SUBSYSTEM, WSMSC_ADDRESS, WSMSC_SUBSYSTEM,
405 -- RN_ADDRESS, RN_SUBSYSTEM, SUBSCRIPTION_TYPE
406 -- Modifies entry in SMS table for each TN in the range
407 -- Called when: There is a Modify Ported Number
408 -- request from NRC
409 --
410 PROCEDURE SMS_MODIFY_PORTED_NUMBER
411 (p_ORDER_ID IN NUMBER,
412 p_LINEITEM_ID IN NUMBER,
413 p_WORKITEM_INSTANCE_ID IN NUMBER,
414 p_FA_INSTANCE_ID IN NUMBER,
415 x_ERROR_CODE OUT NOCOPY NUMBER,
416 x_ERROR_MESSAGE OUT NOCOPY VARCHAR2
417 );
418
422 -- with the given status type code
419 -- Calls xnp_core.check_donor_status_exists to check for a porting record
420 -- It checks if the record exists
421 -- for the number range and created by the donor
423 -- Mandatory WI Params: STARTING_NUMBER,ENDING_NUMBER,DONOR_SP_ID
424 --
425 PROCEDURE SOA_CHECK_DON_STATUS_EXISTS
426 (p_WORKITEM_INSTANCE_ID IN NUMBER
427 ,P_STATUS_TO_CHECK_WITH IN VARCHAR2
428 ,x_CHECK_STATUS OUT NOCOPY VARCHAR2
429 ,x_ERROR_CODE OUT NOCOPY NUMBER
430 ,x_ERROR_MESSAGE OUT NOCOPY VARCHAR2
431 );
432
433 -- Calls xnp_core.check_recipient_status_exists
434 -- to check if there exists a porting record
435 -- for the number range and created by the donor
436 -- with the given stxatus type code
437 -- Mandatory WI Params: STARTING_NUMBER,ENDING_NUMBER,RECIPIENT_SP_ID
438 --
439 PROCEDURE SOA_CHECK_REC_STATUS_EXISTS
440 (p_WORKITEM_INSTANCE_ID IN NUMBER
441 ,P_STATUS_TO_CHECK_WITH IN VARCHAR2
442 ,x_CHECK_STATUS OUT NOCOPY VARCHAR2
443 ,x_ERROR_CODE OUT NOCOPY NUMBER
444 ,x_ERROR_MESSAGE OUT NOCOPY VARCHAR2
445 );
446
447 -- Updates the Notes info
448 -- Mandatory WI Params: PORTING_ID
449 -- Optional WI Params COMMETS,NOTES,PREORDER_AUTHORIZATION_CODE
450 --
451 PROCEDURE SOA_UPDATE_NOTES_INFO
452 (p_ORDER_ID IN NUMBER,
453 p_LINEITEM_ID IN NUMBER,
454 p_WORKITEM_INSTANCE_ID IN NUMBER,
455 p_FA_INSTANCE_ID IN NUMBER,
456 x_ERROR_CODE OUT NOCOPY NUMBER,
457 x_ERROR_MESSAGE OUT NOCOPY VARCHAR2
458 );
459
460 -- Updates the Network information for the given Porting ID in XNP_SV_SOA
461 -- Mandatory WI Params: ROUTING_NUMBER
462 -- Optional WI Params: ROUTING_NUMBER,
463 -- CNAM_ADDRESS, CNAM_SUBSYSTEM, ISVM_ADDRESS
464 -- ISVM_SUBSYSTEM, LIDB_ADDRESS, LIDB_SUBSYSTEM
465 -- CLASS_ADDRESS,CLASS_SUBSYSTEM,WSMSC_ADDRESS,
466 -- WSMSC_SUBSYSTEM, RN_ADDRESS, RN_SUBSYSTEM
467 --
468 PROCEDURE SOA_UPDATE_NETWORK_INFO
469 (p_ORDER_ID IN NUMBER,
470 p_LINEITEM_ID IN NUMBER,
471 p_WORKITEM_INSTANCE_ID IN NUMBER,
472 p_FA_INSTANCE_ID IN NUMBER,
473 x_ERROR_CODE OUT NOCOPY NUMBER,
474 x_ERROR_MESSAGE OUT NOCOPY VARCHAR2
475 );
476
477
478 -- Updates the Customer information for the Porting ID
479 -- Mandatory WI Params: PORTING_ID
480 -- Optional WI Params: PAGER, PAGER_PIN,INTERNET_ADDRESS, CUSTOMER_ID,
481 -- CUSTOMER_NAME,ADDRESS_LINE1,CITY,PHONE,FAX,EMAIL,ZIP_CODE,
482 -- CUSTOMER_CONTACT_REQ_FLAG,CONTACT_NAME
483 --
484 PROCEDURE SOA_UPDATE_CUSTOMER_INFO
485 (p_ORDER_ID IN NUMBER,
486 p_LINEITEM_ID IN NUMBER,
487 p_WORKITEM_INSTANCE_ID IN NUMBER,
488 p_FA_INSTANCE_ID IN NUMBER,
489 x_ERROR_CODE OUT NOCOPY NUMBER,
490 x_ERROR_MESSAGE OUT NOCOPY VARCHAR2
491 );
492
493 -- Runtime Validation for NP Work item
494 -- Calls XNP_CORE.Runtime_validation
495 -- Optional WI Params: STARTING_NUMBER,ENDING_NUMBER,ROUTING_NUMBER,
496 -- DONOR_SP_ID,RECIPIENT_SP_ID
497
498 PROCEDURE RUNTIME_VALIDATION
499 ( p_ORDER_ID IN NUMBER
500 ,p_LINE_ITEM_ID IN NUMBER
501 ,p_WORKITEM_INSTANCE_ID IN NUMBER
502 ,x_ERROR_CODE OUT NOCOPY NUMBER
503 ,x_ERROR_MESSAGE OUT NOCOPY VARCHAR2
504 );
505
506 -- Remove all Waiting/Active Timers and Expire all Waiting/Activ
507 -- Callback Events
508 PROCEDURE DEREGISTER_ALL
509 ( p_order_id IN NUMBER
510 ,x_error_code OUT NOCOPY NUMBER
511 ,x_error_message OUT NOCOPY VARCHAR2
512 );
513
514 END XNP_STANDARD;