1 PACKAGE XNP_WF_STANDARD AUTHID CURRENT_USER AS
2 /* $Header: XNPWFACS.pls 120.0 2005/05/30 11:48:52 appldev noship $ */
3
4
5
6 -- Global variables to maintain the SFM context information
7 --
8 g_ORDER_ID NUMBER := NULL;
9 g_WORKITEM_INSTANCE_ID NUMBER := NULL;
10 g_FA_INSTANCE_ID NUMBER := NULL;
11
12
13 -- Sets the SFM workitem and order context information
14 -- into the package global variables
15 -- g_ORDER_ID and g_WORKITEM_INSTANCE_ID. This ensures
16 -- proper order to workitem mapping.
17 --
18 -- Internal Name: None - Not a workflow activity
19 --
20 -- Display Name: None - Not a workflow activity
21 --
22 -- Called By:
23 -- Workflow directly if included as the selector
24 -- function for the item type
25 --
26 -- Called when:
27 -- The itemtype is initiated and before executing
28 -- each workflow activity
29 --
30 -- Caution: Each item type containing customized workflow
31 -- processes must have this function as the selector function.
32 --
33 PROCEDURE SET_SDP_CONTEXT
34 (ITEMTYPE IN VARCHAR2
35 ,ITEMKEY IN VARCHAR2
36 ,ACTID IN NUMBER
37 ,COMMAND IN VARCHAR2
38 ,RESULT OUT NOCOPY VARCHAR2
39 );
40
41 -- Comments:
42 -- Procedure to complete workitem and update status
43 -- Item Type: XDPWFSTD
44 -- Internal Name: COMPLETE_WI_UPDATE_STATUS
45 -- Display Name : Complete work item and update status
46 -- Relevant Core Procedure Invoked: RESUME_SDP
47 -- Activity Attributes: None
48 -- Mandatory WI Params: None
49 -- Optional WI Params: None
50
51 -- Creates a record of numbers being provisioned
52 -- to enable porting. Called during the Provisioning
53 -- Phase of the business process. If an entry existed then
54 -- only the Network info and porting ID is updated for that entry
55 --
56 -- Item Type: NP Standard (XNPWFSTD)
57 --
58 -- Internal Name: CREATE_SMS_PORTING_RECORD
59 --
60 -- Display Name: Create or Moidify SMS Porting Records
61 --
62 -- Relevant Core Procedures Invoked: SMS_CREATE_PORTED_NUMBER
63 --
64 -- Item Attributes: WORKITEM_INSTANCE_ID
65 --
66 -- Activity Attributes: None
67 --
68 -- Mandatory WI Params: PORTING_ID, STARTING_NUMBER,
69 -- ENDING_NUMBER, PORTING_TIME, ROUTING_NUMBER
70 --
71 -- PORTING_TIME - is the time when the number is provisioned
72 --
73 -- Optional WI Params: CNAM_ADDRESS, CNAM_SUBSYSTEM,
74 -- ISVM_ADDRESS, ISVM_SUBSYSTEM, LIDB_ADDRESS, LIDB_SUBSYSTEM,
75 -- CLASS_ADDRESS, CLASS_SUBSYSTEM, WSMSC_ADDRESS, WSMSC_SUBSYSTEM,
76 -- RN_ADDRESS, RN_SUBSYSTEM, SUBSCRIPTION_TYPE
77 --
78 PROCEDURE SMS_CREATE_PORTED_NUMBER
79 (ITEMTYPE IN VARCHAR2
80 ,ITEMKEY IN VARCHAR2
81 ,ACTID IN NUMBER
82 ,FUNCMODE IN VARCHAR2
83 ,RESULTOUT OUT NOCOPY VARCHAR2
84 ) ;
85
86
87
88 -- Called during the deprovisioning of the number range.
89 -- This procedure deletes the network provisioning information
90 -- from the NP tables.
91 --
92 -- Internal Name: Not used currently
93 --
94 -- Display Name: Not used currently
95 --
96 -- Relevant Core Procedures Invoked: SMS_DELETE_PORTED_NUMBER
97 --
98 -- Item Attributes: WORKITEM_INSTANCE_ID
99 --
100 -- Activity Attributes: None
101 --
102 -- Mandatory WI Params: STARTING_NUMBER, ENDING_NUMBER
103 --
104 -- Optional WI Params: None
105 --
106 PROCEDURE SMS_DELETE_PORTED_NUMBER
107 (ITEMTYPE IN VARCHAR2
108 ,ITEMKEY IN VARCHAR2
109 ,ACTID IN NUMBER
110 ,FUNCMODE IN VARCHAR2
111 ,RESULTOUT OUT NOCOPY VARCHAR2
112 );
113
114
115
116 -- Updates the Cutoff Due date in the NP Soa tables
117 -- for each number in the range. The entries to update are
118 -- identified based on either the porting ID or current status
119 -- of the number range.
120 --
121 -- Internal Name: Not used currently
122 --
123 -- Display Name: Not used currently
124 --
125 -- Relevant Core Procedures Invoked: SOA_UPDATE_CUTOFF_DATE
126 --
127 -- Item Attributes: WORKITEM_INSTANCE_ID
128 --
129 -- Activity Attributes: CUR_STATUS_TYPE_CODE
130 --
131 -- Mandatory WI Params: STARTING_NUMBER, ENDING_NUMBER,
132 -- OLD_SP_CUTOFF_DUE_DATE, SP_NAME
133 --
134 -- Optional WI Params: PORTING_ID
135 --
136 -- Note: Its is recommended that SOA_UPDATE_DATE be used
137 --
138 PROCEDURE SOA_UPDATE_CUTOFF_DATE
139 (ITEMTYPE IN VARCHAR2
140 ,ITEMKEY IN VARCHAR2
141 ,ACTID IN NUMBER
142 ,FUNCMODE IN VARCHAR2
143 ,RESULTOUT OUT NOCOPY VARCHAR2
144 );
145
146
147
148 -- Creates a porting order based on the SP role
149 --
150 -- Item Type: NP Standard (XNPWFSTD)
151 --
152 -- Internal Name: CREATE_PORTING_ORDER
153 --
154 -- Display Name: Create Porting Order
155 --
156 -- Relevant Core Procedures Invoked:
157 -- SOA_CREATE_DON_PORT_ORDER or SOA_CREATE_NRC_PORT_ORDER
158 -- or SOA_CREATE_REC_PORT_ORDER
159 --
160 -- Item Attributes: WORKITEM_INSTANCE_ID
161 --
162 -- Activity Attributes: SP_ROLE
163 -- The SP_ROLE should say if its a DONOR,ORIGNAL_DONOR,
164 -- RECIPIENT,NRC or NRC_WITHOUT_VALIDATION
165 --
166 -- Mandatory WI Params: STARTING_NUMBER, ENDING_NUMBER,
167 -- DONOR_SP_ID,RECIPIENT_SP_ID,NEW_SP_DUE_DATE, PORTING_ID
168 --
169 -- Optional WI Params: OLD_SP_CUTOFF_DUE_DATE,CUSTOMER_ID,
170 -- CUSTOMER_NAME, CUSTOMER_TYPE, ADDRESS_LINE1, ADDRESS_LINE2, CITY,PHONE,FAX,EMAIL,
171 -- ZIP_CODE, COUNTRY, RETAIN_TN_FLAG,CUSTOMER_CONTACT_REQ_FLAG,
172 -- RETAIN_DIR_INFO_FLAG,CONTACT_NAME, CNAM_ADDRESS,
173 -- CNAM_SUBSYSTEM, ISVM_ADDRESS, ISVM_SUBSYSTEM, LIDB_ADDRESS,
174 -- LIDB_SUBSYSTEM, CLASS_ADDRESS, CLASS_SUBSYSTEM, WSMSC_ADDRESS,
175 -- WSMSC_SUBSYSTEM, RN_ADDRESS, RN_SUBSYSTEM, PAGER, PAGER_PIN,
176 -- INTERNET_ADDRESS, PREORDER_AUTHORIZATION_CODE, ACTIVATION_DUE_DATE,
177 -- SUBSCRIPTION_TYPE,COMMENTS,NOTES, ROUTING_NUMBER, SUBSEQUENT_PORT,ORDER_PRIORITY
178 --
179 -- The Status Type code is set to the status configured with
180 -- initial flag = 'Y'
181 --
182 PROCEDURE SOA_CREATE_PORTING_ORDER
183 (ITEMTYPE IN VARCHAR2
184 ,ITEMKEY IN VARCHAR2
185 ,ACTID IN NUMBER
186 ,FUNCMODE IN VARCHAR2
187 ,RESULTOUT OUT NOCOPY VARCHAR2
188 );
189
190
191 -- Updates the status type code in the XNP_SV_SOA with the new status type code
192 -- All records with the porting ID and belonging
193 -- to the current SP are updated to th new status.
194 -- If the new status belongs to the ACTIVE phase, and if there
195 -- exists records for this number range already in ACTIVE phase,
196 -- then they first are reset to OLD phase. The actual updation of
197 -- the records with the given porting ID is done next.
198 --
199 -- Item Type: NP Standard (XNPWFSTD)
200 --
201 -- Internal Name: UPDATE_PORTING_STATUS
202 --
203 -- Display Name: Update Porting Status
204 --
205 -- Relevant Core Procedures Invoked: SOA_UPDATE_SV_STATUS,
206 -- SOA_RESET_SV_STATUS
207 --
208 -- Item Attributes: WORKITEM_INSTANCE_ID
209 --
210 -- Activity Attributes: NEW_STATUS_TYPE_CODE, STATUS_CHANGE_CAUSE_CODE
211 --
212 -- Mandatory WI Params: PORTING_ID, STARTING_NUMBER,
213 -- ENDING_NUMBER, SP_NAME
214 --
215 -- Optional WI Params: None
216 --
217 --
218 PROCEDURE SOA_UPDATE_SV_STATUS
219 (ITEMTYPE IN VARCHAR2
220 ,ITEMKEY IN VARCHAR2
221 ,ACTID IN NUMBER
222 ,FUNCMODE IN VARCHAR2
223 ,RESULTOUT OUT NOCOPY VARCHAR2
224 );
225
226
227
228 -- Subscribes for the mentioned business event with the given reference i
229 -- and halts the workflow till it arrives.
230 -- The state of the workflow at the end of this activity is
231 -- NOTIFIED.
232 --
233 -- Item Type: SFM Standard (XDPWFSTD)
234 --
235 -- Internal Name: SUBSCRIBE_TO_BUSINESS_EVENTS
236 --
237 -- Display Name: Subscribe to Business Events
238 --
239 -- Item Attributes: WORKITEM_INSTANCE_ID,
240 -- If CALLBACK_REF_ID_NAME is chosen as CUSTOM then this
241 -- activity would require an item attribute from which
242 -- the value for the REFERENCE_ID is determined.
243 --
244 -- Activity Attributes: EVENT_TYPE, CALLBACK_REF_ID_NAME,
245 -- CUSTOM_CALLBACK_REFERENCE_ID
246 --
247 -- Mandatory WI Params: The workitem parameter
248 -- chosen from the CALLBACK_REF_ID_NAME LOV is mandatory.
249 -- The LOV is seeded with PORTING_ID and STARTING_NUMBER
250 --
251 -- Optional WI Params: None
252 -- The Event Type can be chosen from the LOV associated
253 --
254 -- Choice of Reference Id: The reference ID is the value
255 -- to be chosen so that, when the message/event subscribed
256 -- for arrives into the SFM system, the workflow waiting
257 -- for this message is uniquely identified.
258 -- The reference ID value can be a workitem paramter or a
259 -- customized value stored in an item attribute.
260 -- If the Reference Id is a Workitem parameter, then the
261 -- name of this parameter must be chosen from the LOV
262 -- provided for CALLBACK_REF_ID_NAME. Else, if the ref ID
263 -- is a customized Item attribute then, choose CUSTOM as
264 -- the value for CALLBACK_REF_ID_NAME and then choose
265 -- then associate the item attribute with the
266 -- CUSTOM_CALLBACK_REFERENCE_ID. Alternatively, even a constant
267 -- value can be typed into the CUSTOM_CALLBACK_REFERENCE_ID
268 -- when one wishes to customize the value.
269 --
270 --
271 -- Relevant Procedures Invoked:
272 -- 1. XNP_STANDARD.SUBSCRIBE_FOR_EVENT
273 -- 2. XNP_UTILS.CHECK_TO_GET_REF_ID
274 --
275 --
276 --
277 PROCEDURE SUBSCRIBE_FOR_EVENT
278 (ITEMTYPE IN VARCHAR2
279 ,ITEMKEY IN VARCHAR2
280 ,ACTID IN NUMBER
281 ,FUNCMODE IN VARCHAR2
282 ,RESULTOUT OUT NOCOPY VARCHAR2
283 );
284
285
286
287 -- Subscribes to all the acks for this business event with the given reference ID
288 -- and halts the workflow till it arrives.
289 -- The state of the workflow at the end of this activity is
290 -- NOTIFIED.
291 --
292 -- Item Type: SFM Standard (XDPWFSTD)
293 --
294 -- Internal Name: SUBSCRIBE_TO_ACKS
295 --
296 -- Display Name: Subscribe to Acknowledgements
297 --
298 -- Item Attributes: WORKITEM_INSTANCE_ID,
299 -- If CALLBACK_REF_ID_NAME is chosen as CUSTOM then this
300 -- activity would require an item attribute from which
301 -- the value for the REFERENCE_ID is determined.
302 --
303 -- Activity Attributes: EVENT_TYPE, CALLBACK_REF_ID_NAME,
304 -- CUSTOM_CALLBACK_REFERENCE_ID
305 --
306 -- Mandatory WI Params: The workitem parameter
307 -- chosen from the CALLBACK_REF_ID_NAME LOV is mandatory.
308 -- The LOV is seeded with PORTING_ID and STARTING_NUMBER
309 -- The Event type chosen serves to group all the responses
310 -- that can be expected for the chosen event type. One or
311 -- more events can be grouped under a user defined event type
312 -- using the Event Subscribers tab in iMessageStudio
313 --
314 -- The Event Type can be chosen from the LOV associated
315 --
316 -- Choice of Reference ID: The reference ID is the value
317 -- to be chosen so that, when the message/event subscribed
318 -- for arrives into the SFM system, the workflow waiting
319 -- for this message is uniquely IDentified.
320 -- The reference ID value can be a workitem paramter or a
321 -- customized value stored in an item attribute.
322 -- If the Reference ID is a Workitem parameter, then the
323 -- name of this parameter must be chosen from the LOV
324 -- provided for CALLBACK_REF_ID_NAME. Else, if the ref ID
325 -- is a customized Item attribute then, choose CUSTOM as
326 -- the value for CALLBACK_REF_ID_NAME and then choose
327 -- then associate the item attribute with the
328 -- CUSTOM_CALLBACK_REFERENCE_ID. Alternatively, even a constant
329 -- value can be typed into the CUSTOM_CALLBACK_REFERENCE_ID
330 -- when one wishes to customize the value.
331 --
332 -- Relevant Procedures Invoked:
333 -- 1. XNP_STANDARD.SUBSCRIBE_FOR_ACKS
334 -- 2. XNP_UTILS.CHECK_TO_GET_REF_ID
335 -- 3. XNP_EVENT.SUBSCRIBE_FOR_ACKS
336 --
337 --
338 --
339 PROCEDURE SUBSCRIBE_FOR_ACKS
340 (ITEMTYPE IN VARCHAR2
341 ,ITEMKEY IN VARCHAR2
342 ,ACTID IN NUMBER
343 ,FUNCMODE IN VARCHAR2
344 ,RESULTOUT OUT NOCOPY VARCHAR2
345 );
346
347
348 -- Prepares a default notification document.
349 -- The procedures to genereate the pl/sql documents are
350 -- part of NP seed data.
351 -- The roles which could get the notification NP_CUST_CARE_ADMIN,
352 -- NP_SYSADMIN are also seeded. Their values are stored in
353 -- the item attributes CUST_CARE_ADMIN and SYS_ADMIN respectively
354 --
355 -- The user needs to choose the notification into DOC_PROC_NAME.
356 -- If the user chooses one of the seeded (in NP Activities) notifns
357 -- then, this activity must be preceed the notification activity.
358 --
359 -- Item Type: NP Standard (XNPWFSTD)
360 --
361 -- Internal Name: PREPARE_NOTIF_MESSAGE
362 --
363 -- Display Name: Prepare Notification Message
364 --
365 -- Prepares a default notification document.
366 -- The procedures to genereate the pl/sql documents are
367 -- part of NP seed data.
368 -- The roles which could get the notification NP_CUST_CARE_ADMIN,
369 -- NP_SYSADMIN are also seeded. Their values are stored in
370 -- the item attributes CUST_CARE_ADMIN and SYS_ADMIN respectively
371 --
372 -- The user needs to choose the notification into DOC_PROC_NAME.
373 -- If the user chooses one of the seeded (in NP Activities) notifns
374 -- then, this activity must be preceed the notification activity.
375 --
376 -- Relevant Procedures Invoked: Procedures in XNP_DOCUMENTS
377 --
378 -- Item Attributes: WORKITEM_INSTANCE_ID, MSG_ID,
379 -- CUST_CARE_ADMIN, SYS_ADMIN, DOC_REFERENCE
380 --
381 -- Activity Attributes: DOC_PROC_NAME
382 -- DOC_PROC_NAME gives the name of the document to prepare
383 --
384 -- Mandatory WI Params: PORTING_ID, STARTING_NUMBER,
385 -- ENDING_NUMBER, PORTING_TIME, NEW_SP_DUE_DATE
386 --
387 -- Optional WI Params: None
388 --
389 PROCEDURE PREPARE_NOTIFICATION
390 (ITEMTYPE IN VARCHAR2
391 ,ITEMKEY IN VARCHAR2
392 ,ACTID IN NUMBER
393 ,FUNCMODE IN VARCHAR2
394 ,RESULTOUT OUT NOCOPY VARCHAR2
395 );
396
397
398 -- Publishes for the mentioned business event with the given reference ID.
399 --
400 -- Item Type: SFM Standard (XDPWFSTD)
401 --
402 -- Internal Name: PUBLISH
403 --
404 -- Display Name: Publish Message
405 --
406 -- Item Attributes: WORKITEM_INSTANCE_ID,
407 -- If CALLBACK_REF_ID_NAME is chosen as CUSTOM then this
408 -- activity would require an item attribute from which
409 -- the value for the REFERENCE_ID is determined.
410 --
411 -- Activity Attributes: EVENT_TYPE, CALLBACK_REF_ID_NAME,
415 -- chosen from the CALLBACK_REF_ID_NAME LOV is mandatory.
412 -- CUSTOM_CALLBACK_REFERENCE_ID, PARAM_LIST
413 --
414 -- Mandatory WI Params: The workitem parameter
416 -- The LOV is seeded with PORTING_ID and STARTING_NUMBER.
417 -- The workitem parameters referred to in the PARAM_LIST are
418 -- also mandatory.
419 --
420 -- Optional WI Params: None
421 -- The Event Type can be chosen from the LOV associated
422 --
423 -- Choice of Reference Id: The reference ID is the value
424 -- to be chosen so that, when the message/event subscribed
425 -- for arrives into the SFM system, the workflow waiting
426 -- for this message is uniquely identified.
427 -- The reference ID value can be a workitem paramter or a
428 -- customized value stored in an item attribute.
429 -- If the Reference ID is a Workitem parameter, then the
430 -- name of this parameter must be chosen from the LOV
431 -- provided for CALLBACK_REF_ID_NAME. Else, if the ref ID
432 -- is a customized Item attribute then, choose CUSTOM as
433 -- the value for CALLBACK_REF_ID_NAME and then choose
434 -- then associate the item attribute with the
435 -- CUSTOM_CALLBACK_REFERENCE_ID. Alternatively, even a constant
436 -- value can be typed into the CUSTOM_CALLBACK_REFERENCE_ID
437 -- when one wishes to customize the value.
438 --
439 -- PARAM_LIST gives the list of parameters for the event
440 -- in the name value format. For eg. if the event is MY_EVT
441 -- and the 'IN' parameters for MY_EVT.PUBLISH is
442 -- XNP$SNO, XNP$DON_NAME then the user defined
443 -- param list should look like
444 -- 'SNO=$STARTING_NUMBER,DON_NAME=$DONOR_SP_ID'.
445 -- The string following the '=$' should mention the workitem parameter
446 -- from which the workflow must get the value from at runtime.
447 -- During runtime the invokation would look like
448 -- MY_EVT.PUBLISH
449 -- XNP$SNO => <value in STARTING_NUMBER workitem parameter>
450 -- XNP$DON_NAME => <value in DONOR_SP_ID workitem parameter>
451 -- ...
452 --
453 --
454 -- Relevant Procedures Invoked:
455 -- 1. XNP_STANDARD.PUBLISH_EVENT
456 -- 2. XNP_UTILS.CHECK_TO_GET_REF_ID
457 -- 3. <EVENT_TYPE chosen>.PUBLISH
458 --
459 --
460 --
461 PROCEDURE PUBLISH_EVENT
462 (ITEMTYPE IN VARCHAR2
463 ,ITEMKEY IN VARCHAR2
464 ,ACTID IN NUMBER
465 ,FUNCMODE IN VARCHAR2
466 ,RESULTOUT OUT NOCOPY VARCHAR2
467 );
468
469
470
471 -- Executes the fulfillment action to provision or deprovision or modify a network element
472 -- At the end it registers for an FA_DONE message with the FA_INSTANCE_ID
473 -- as the reference id.
474 -- The FA_DONE message is a message sent by the SFM system
475 -- once the provisioning operation is compeleted. The
476 -- success, aborted and error scenarios must be handled by
477 -- this user defined workflow.
478 --
479 -- Item Type: SFM Standard (XDPWFSTD)
480 --
481 -- Internal Name: EXECUTE_FA
482 --
483 -- Display Name: Execute Fulfillment Action
484 --
485 -- Executes the fulfillment action to provision or
486 -- deprovision or modify a network element. At the end
487 -- it registers for an FA_DONE message with the FA_INSTANCE_ID
488 -- as the reference ID.
489 -- The FA_DONE message is a message sent by the SFM system
490 -- once the provisioning operation is compeleted. The
491 -- success, aborted and error scenarios must be handled by
492 -- this user defined workflow.
493 --
494 -- Relevant Procedures Invoked: xdp_eng_util.execute_fa
495 --
496 -- Item Attributes: WORKITEM_INSTANCE_ID, ORDER_ID
497 --
498 -- Activity Attributes: FA_NAME, FE_NAME
499 --
500 PROCEDURE EXECUTE_FA
501 (ITEMTYPE IN VARCHAR2
502 ,ITEMKEY IN VARCHAR2
503 ,ACTID IN NUMBER
504 ,FUNCMODE IN VARCHAR2
505 ,RESULTOUT OUT NOCOPY VARCHAR2
506 );
507
508
509 PROCEDURE EXECUTE_FA_N_SYNC_WI_PAR
510 (ITEMTYPE IN VARCHAR2
511 ,ITEMKEY IN VARCHAR2
512 ,ACTID IN NUMBER
513 ,FUNCMODE IN VARCHAR2
514 ,RESULTOUT OUT NOCOPY VARCHAR2
515 );
516
517 Procedure DownloadWIParams(itemtype in varchar2, itemkey in varchar2);
518
519 Procedure uploadFAParams( itemtype IN VARCHAR2,
520 itemkey IN VARCHAR2,
521 actid IN NUMBER,
522 p_FAInstanceID IN NUMBER );
523
524
525 -- Updates the Billing and Charging information
526 -- for the given Porting Id
527 --
528 -- Item Type: NP Standard (XNPWFSTD)
529 --
530 -- Internal Name: UPDATE_CHARGING_INFO
531 --
532 -- Display Name: Update Charging Information
533 --
534 -- Relevant Core Procedures Invoked: SOA_UPDATE_CHARGING_INFO
535 --
536 -- Item Attributes: WORKITEM_INSTANCE_ID
537 --
538 -- Activity Attributes: None
539 --
540 -- Mandatory WI Params: PORTING_ID, SP_NAME
541 --
542 -- Optional WI Params: INVOICE_DUE_DATE, CHARGING_INFO
543 -- BILLING_ID, USER_LOCTN_VALUE, USER_LOCTN_TYPE,
544 -- PRICE_CODE, PRICE_PER_MINUTE, PRICE_PER_CALL
545 --
546 PROCEDURE SOA_UPDATE_CHARGING_INFO
547 (ITEMTYPE IN VARCHAR2
548 ,ITEMKEY IN VARCHAR2
549 ,ACTID IN NUMBER
550 ,FUNCMODE IN VARCHAR2
551 ,RESULTOUT OUT NOCOPY VARCHAR2
555
552 );
553
554
556 -- Called during the deprovisioning of the number range.
557 -- Purpose: Checks if order requires directory services that need to be notified
558 --
559 -- Internal Name: Not used currently
560 --
561 -- Display Name: Not used currently
562 --
563 -- Relevant Core Procedures Invoked: SOA_CHECK_NOTIFY_DIR_SVS
564 --
565 -- Item Attributes: WORKITEM_INSTANCE_ID
566 --
567 -- Activity Attributes: None
568 --
569 -- Mandatory WI Params: PORTING_ID, SP_NAME
570 --
571 -- Optional WI Params: None
572 --
573 --
574 PROCEDURE SOA_CHECK_NOTIFY_DIR_SVS
575 (ITEMTYPE IN VARCHAR2
576 ,ITEMKEY IN VARCHAR2
577 ,ACTID IN NUMBER
578 ,FUNCMODE IN VARCHAR2
579 ,RESULTOUT OUT NOCOPY VARCHAR2
580 );
581
582
583 -- Gets the FEs to be provisioned for this feature type and number range
584 -- For each FE the SFM's provisioning
585 -- procedure (execute fa) is invoked. At the end of this activty
586 -- the control passes on to the Provisioning subsystem which
587 -- executes the fulfillment procedure. An FA_DONE message is
588 -- subscribed for each FA being executed which gives the execution
589 -- result of the fulfillment procedure. The callback procedure
590 -- associated with the FA_DONE handles the responses received.
591 --
592 -- In must ensured that the immediate next activity following
593 -- the activity must be SFM Standard's Wait For Flow. This
594 -- is to ensure proper handoff from the provisioning system
595 -- back to the NP System.
596 --
597 -- Item Type: NP Standard (XNPWFSTD)
598 --
599 -- Internal Name: PROVISION_FES
600 --
601 -- Display Name: Provision or Modify FEs
602 --
603 -- Relevant Procedures Invoked:
604 -- XNP_CORE.SMS_INSERT_FE_MAP,
605 -- XDP_ENG_UTIL.ADD_FA_TOWI - returns fa instance ID
606 -- XDP_ENG_UTIL.EXECUTE_FA - with INTERNAL option
607 -- XNP_EVENT.SUBSCRIBE with
608 -- - callback procedure XNP_FA_CP.PROCESS_FA_DONE
609 -- - reference ID as the returned fa instance ID
610 --
611 -- Item Attributes: ORDER_ID, WORKITEM_INSTANCE_ID
612 --
613 -- Activity Attributes: FEATURE_TYPE
614 --
615 -- Mandatory WI Params: STARTING_NUMBER, ENDING_NUMBER
616 --
617 --
618 PROCEDURE SMS_PROVISION_NES
619 (ITEMTYPE IN VARCHAR2
620 ,ITEMKEY IN VARCHAR2
621 ,ACTID IN NUMBER
622 ,FUNCMODE IN VARCHAR2
623 ,RESULTOUT OUT NOCOPY VARCHAR2
624 );
625
626
627 -- Purpose: Gets the fes to be Deprovisioned for this feature type and number range.
628 -- For each FE the SFM's provisioning
629 -- procedure (execute fa) is invoked. At the end of this activty
630 -- the control passes on to the Provisioning subsystem which
631 -- executes the fulfillment procedure. An FA_DONE message is
632 -- subscribed for each FA being executed which gives the execution
633 -- result of the fulfillment procedure. The callback procedure
634 -- associated with the FA_DONE handles the responses received.
635 --
636 -- In must ensured that the immediate next activity following
637 -- the activity must be SFM Standard's 'Wait For Flow'. This
638 -- is to ensure proper handoff from the provisioning system
639 -- back to the NP System.
640 --
641 -- Note: Only FEs which were earlier provisioned by this SP
642 -- can be modified. Otherwise the FEs will be ignored.
643 --
644 -- Item Type: NP Standard (XNPWFSTD)
645 --
646 -- Internal Name: DEPROVISION_FES
647 --
648 -- Display Name: Deprovision FEs
649 --
650 -- Relevant Procedures Invoked:
651 -- XDP_ENG_UTIL.ADD_FA_TOWI - returns fa instance id
652 -- XDP_ENG_UTIL.EXECUTE_FA - with INTERNAL option
653 -- XNP_EVENT.SUBSCRIBE with
654 -- - callback procedure XNP_FA_CP.PROCESS_FA_DONE
655 -- - reference id as the returned fa instance ID
656 --
657 -- Item Attributes: ORDER_ID, WORKITEM_INSTANCE_ID
658 --
659 -- Activity Attributes: FEATURE_TYPE
660 --
661 -- Mandatory WI Params: STARTING_NUMBER, ENDING_NUMBER
662 --
663 PROCEDURE SMS_DEPROVISION_NES
664 (ITEMTYPE IN VARCHAR2
665 ,ITEMKEY IN VARCHAR2
666 ,ACTID IN NUMBER
667 ,FUNCMODE IN VARCHAR2
668 ,RESULTOUT OUT NOCOPY VARCHAR2
669 );
670
671
672
673 -- Completes the activity based on the value in the ORDER_RESULT workitem parameter.
674 --
675 -- Item Type: SFM Standard (XDPWFSTD)
676 --
677 -- Internal Name: CHECK_RESULT
678 --
679 -- Display Name: Check Order Workitem Result
680 --
681 -- Relevant Procedures Invoked:
682 --
683 -- Item Attributes: WORKITEM_INSTANCE_ID
684 --
685 -- Activity Attributes: None
686 --
687 -- Mandatory WI Params: ORDER_RESULT
688 --
689 PROCEDURE SOA_CHECK_ORDER_STATUS
690 (ITEMTYPE IN VARCHAR2
691 ,ITEMKEY IN VARCHAR2
692 ,ACTID IN NUMBER
693 ,FUNCMODE IN VARCHAR2
694 ,RESULTOUT OUT NOCOPY VARCHAR2
695 );
696
697
698 -- Checks if the records are in the given status
699 -- and if 'Y' then completes the 'YES' path
700 -- else completes the 'NO' path
701 --
702 -- Internal Name: Not used currently
706 -- Relevant Procedures Invoked: XNP_CORE.CHECK_SOA_STATUS_EXISTS
703 --
704 -- Display Name: Not used currently
705 --
707 --
708 --
709 -- Item Attributes: WORKITEM_INSTANCE_ID
710 --
711 -- Activity Attributes: None
712 --
713 -- Mandatory WI Params: SP_NAME, STARTING_NUMBER
714 -- ENDING_NUMBER
715 --
716 PROCEDURE CHECK_SOA_STATUS_EXISTS
717 (ITEMTYPE IN VARCHAR2
718 ,ITEMKEY IN VARCHAR2
719 ,ACTID IN NUMBER
720 ,FUNCMODE IN VARCHAR2
721 ,RESULTOUT OUT NOCOPY VARCHAR2
722 );
723
724
725
726 -- Sets the ORDER_RESULT to the value passed in the activity attribute ORDER_STATUS
727 -- The order result may be set to indicate the current
728 -- status of the workitem transaction.
729 --
730 -- Item Type: SFM Standard (XDPWFSTD)
731 --
732 -- Internal Name: UPDATE_ORDER_STATUS
733 --
734 -- Display Name: Set Order Workitem Result
735 --
736 -- For e.g. it could indicate the notification response
737 -- or a message response if its positive(Y) or negative(N)
738 --
739 -- Relevant Procedures Invoked:
740 -- XNP_STANDARD.SOA_CHECK_ORDER_STATUS
741 --
742 -- Item Attributes: WORKITEM_INSTANCE_ID
743 --
744 -- Activity Attributes: None
745 --
746 -- Mandatory WI Params: ORDER_RESULT
747 --
748 PROCEDURE SET_ORDER_RESULT
749 (ITEMTYPE IN VARCHAR2
750 ,ITEMKEY IN VARCHAR2
751 ,ACTID IN NUMBER
752 ,FUNCMODE IN VARCHAR2
753 ,RESULTOUT OUT NOCOPY VARCHAR2
754 );
755
756
757 -- Determines if the current SP is a DONOR,or RECIPIENT or Original Donor.
758 --
759 -- Item Type: NP Standard (XNPWFSTD)
760 --
761 -- Internal Name: DETERMINE_SP_ROLE
762 --
763 -- Display Name: Determine Current Service Provider Role
764 --
765 -- Relevant Procedures Invoked:
766 -- XNP_CORE.SOA_CHECK_IF_INITIAL_DONOR
767 --
768 -- Item Attributes: WORKITEM_INSTANCE_ID
769 --
770 -- Activity Attributes: None
771 --
772 -- Mandatory WI Params: STARTING_NUMBER, ENDING_NUMBER
773 -- DONOR_SP_ID, RECIPIENT_SP_ID, SP_NAME
774 --
775 PROCEDURE DETERMINE_SP_ROLE
776 (ITEMTYPE IN VARCHAR2
777 ,ITEMKEY IN VARCHAR2
778 ,ACTID IN NUMBER
779 ,FUNCMODE IN VARCHAR2
780 ,RESULTOUT OUT NOCOPY VARCHAR2
781 );
782
783
784
785 -- Checks if it is a subsequent porting request and returns Y/N accordingly
786 --
787 -- Item Type: NP Standard (XNPWFSTD)
788 --
789 -- Internal Name: IS_SUBSEQUENT_PORTING_REQUEST
790 --
791 -- Display Name: Determine if Subsequent Porting Request
792 --
793 -- Relevant Procedures Invoked: XNP_STANDARD.SOA_IS_SUBSEQUENT_PORT
794 --
795 -- Item Attributes: WORKITEM_INSTANCE_ID
796 --
797 -- Activity Attributes: None
798 --
799 -- Mandatory WI Params: SUBSEQUENT_PORT
800 --
801 PROCEDURE SOA_IS_SUBSEQUENT_PORT
802 (ITEMTYPE IN VARCHAR2
803 ,ITEMKEY IN VARCHAR2
804 ,ACTID IN NUMBER
805 ,FUNCMODE IN VARCHAR2
806 ,RESULTOUT OUT NOCOPY VARCHAR2
807 );
808
809 -- Sends for the mentioned business event
810 -- with the given reference id.
811 --
812 -- Item Type: SFM Standard (XDPWFSTD)
813 --
814 -- Internal Name: EXECUTE_FA_MSG
815 --
816 -- Display Name: Send Message
817 --
818 -- Item Attributes: WORKITEM_INSTANCE_ID, ORDER_ID,
819 -- If CALLBACK_REF_ID_NAME is chosen as CUSTOM then this
820 -- activity would require an item attribute from which
821 -- the value for the REFERENCE_ID is determined.
822 --
823 -- Activity Attributes: EVENT_TYPE, CALLBACK_REF_ID_NAME,
824 -- CUSTOM_CALLBACK_REFERENCE_ID, PARAM_LIST, CONSUMER, RECEIVER
825 --
826 -- Mandatory WI Params: The workitem parameter
827 -- chosen from the CALLBACK_REF_ID_NAME LOV is mandatory.
828 -- The LOV is seeded with PORTING_ID and STARTING_NUMBER.
829 -- The workitem parameters referred to in the PARAM_LIST are
830 -- also mandatory.
831 -- The Event Type can be chosen from the LOV associated
832 --
833 -- Choice of Reference ID: The reference ID is the value
834 -- to be chosen so that, when the message/event subscribed
835 -- for arrives into the SFM system, the workflow waiting
836 -- for this message is uniquely identified.
837 -- The reference ID value can be a workitem paramter or a
838 -- customized value stored in an item attribute.
839 -- If the Reference ID is a Workitem parameter, then the
840 -- name of this parameter must be chosen from the LOV
841 -- provided for CALLBACK_REF_ID_NAME. Else, if the ref ID
842 -- is a customized Item attribute then, choose CUSTOM as
843 -- the value for CALLBACK_REF_ID_NAME and then choose
844 -- then associate the item attribute with the
845 -- CUSTOM_CALLBACK_REFERENCE_ID. Alternatively, even a constant
846 -- value can be typed into the CUSTOM_CALLBACK_REFERENCE_ID
847 -- when one wishes to customize the value.
848 --
849 -- PARAM_LIST gives the list of parameters for the event
850 -- in the name value format. For eg. if the event is MY_EVT
851 -- and the 'IN' parameters for MY_EVT.PUBLISH is
852 -- XNP$SNO, XNP$DON_NAME then the user defined
853 -- param list should look like
857 -- During runtime the invokation would look like
854 -- 'SNO=$STARTING_NUMBER,DON_NAME=$DONOR_SP_ID'.
855 -- The string following the '=$' should mention the workitem parameter
856 -- from which the workflow must get the value from at runtime.
858 -- MY_EVT.SEND
859 -- XNP$SNO => <value in STARTING_NUMBER workitem parameter>
860 -- XNP$DON_NAME => <value in DONOR_SP_ID workitem parameter>
861 -- ...
862 --
863 -- CONSUMER gives the procedure which when executed returns
864 -- the adapter name. The consumer can be thought of as the
865 -- immediate recipient of the message incase the message needs
866 -- to make a FEw routing hops before reaching the intended
867 -- recipient
868 -- The API for this packaged procudure should look as follows
869 -- <package>.<procedure>
870 -- (p_order_id in number
871 -- ,p_wi_instance_id in number
872 -- ,p_fa_instance_id in number
873 -- ,x_fe_name out NOCOPY varchar2
874 -- ,x_return_code OUT NOCOPY number
875 -- ,x_error_description OUT NOCOPY varchar2
876 -- );
877 --
878 -- The procedure can be user defined but the <package>.<procedure> must be loaded as lookup values
879 -- against the fnd lookup code 'GET_CONSUMER_FE'.
880 -- NP is seeded with procedures to get the donor, recipient
881 -- NRC, original donor service provider's adapter.
882 --
883 -- RECEIVER gives the procedure which when executed returns
884 -- the reciever name. The reciever can be thought of as the
885 -- final recipient of the message
886 -- The API for this packaged procudure should look as follows
887 -- <package>.<procedure>
888 -- (p_order_id in number
889 -- ,p_wi_instance_id in number
890 -- ,p_fa_instance_id in number
891 -- ,x_recipient_name OUT NOCOPY varchar2
892 -- ,x_return_code OUT NOCOPY number
893 -- ,x_error_description OUT NOCOPY varchar2
894 -- );
895 --
896 -- The procedure can be user defined but the <package>.<procedure>must be loaded as lookup values
897 -- against the fnd lookup code 'GET_RECEIVER_NAME'.
898 -- NP is seeded with procedures to get the donor, recipient
899 -- NRC, original donor service provider's name.
900 --
901 -- Relevant Procedures Invoked:
902 -- 1. XNP_STANDARD.SEND_MESSAGE - to dynamically invoke the send
903 -- 2. XNP_UTILS.CHECK_TO_GET_REF_ID
904 -- 3. <EVENT_TYPE>.SEND
905 --
906 --
907 PROCEDURE SEND_MESSAGE
908 (ITEMTYPE IN VARCHAR2
909 ,ITEMKEY IN VARCHAR2
910 ,ACTID IN NUMBER
911 ,FUNCMODE IN VARCHAR2
912 ,RESULTOUT OUT NOCOPY VARCHAR2
913 );
914
915
916
917 -- Deletes the FE Maps for the number range and feature type
918 --
919 -- Internal Name: Not used currently
920 --
921 -- Display Name: Not used currently
922 --
923 -- Relevant Procedures Invoked:
924 -- XNP_CORE.SMS_DELETE_FE_MAP
925 --
926 -- Item Attributes: WORKITEM_INSTANCE_ID
927 --
928 -- Activity Attributes: None
929 --
930 -- Mandatory WI Params: STARTING_NUMBER, ENDING_NUMBER
931 --
932 PROCEDURE SMS_DELETE_FE_MAP
933 (ITEMTYPE IN VARCHAR2
934 ,ITEMKEY IN VARCHAR2
935 ,ACTID IN NUMBER
936 ,FUNCMODE IN VARCHAR2
937 ,RESULTOUT OUT NOCOPY VARCHAR2
938 );
939
940 -- Checks if there exists a SV for the given TN range
941 -- in that phase and in for the given SP Role i.e. as donor
942 -- or recipient
943 --
944 -- Internal Name: Not being used
945 --
946 -- Display Name: Not being used
947 --
948 -- Note: Phase is not exposed to user. So this
949 -- procedure shouldn't be used
950 --
951 -- Relevant Cores Invoked: CHECK_DONOR_PHASE,
952 -- CHECK_RECIPIENT_PHASE
953 --
954 -- Item Attributes: WORKITEM_INSTANCE_ID
955 --
956 -- Activity Attributes: SP_ROLE, PHASE
957 --
958 -- Mandatory WI Params: STARTING_NUMBER,
959 -- ENDING_NUMBER, SP_NAME
960 --
961 -- Optional Workitem parameters: None
962 --
963 PROCEDURE CHECK_PHASE_FOR_ROLE
964 (ITEMTYPE IN VARCHAR2
965 ,ITEMKEY IN VARCHAR2
966 ,ACTID IN NUMBER
967 ,FUNCMODE IN VARCHAR2
968 ,RESULTOUT OUT NOCOPY VARCHAR2
969 );
970
971
972 -- Updates the FE map status for the given FEs and number range.
973 --
974 -- Internal Name: Not being used
975 --
976 -- Display Name: Not being used
977 --
978 -- Relevant Cores Invoked: SMS_UPDATE_FE_MAP_STATUS
979 --
980 -- Item Attributes: WORKITEM_INSTANCE_ID
981 --
982 -- Activity Attributes: None
983 --
984 -- Mandatory WI Params s: STARTING_NUMBER,
985 -- ENDING_NUMBER
986 --
987 -- Optional Workitem parameters: None
988 --
989 PROCEDURE SMS_UPDATE_FE_MAP_STATUS
990 (ITEMTYPE IN VARCHAR2
991 ,ITEMKEY IN VARCHAR2
992 ,ACTID IN NUMBER
993 ,FUNCMODE IN VARCHAR2
994 ,RESULTOUT OUT NOCOPY VARCHAR2
995 );
996
997
998
999 -- Relevant Procedures Invoked: Update the status of the message to be rejected
1000 --
1001 -- Item Type: SFM Standard (XDPWFSTD)
1002 --
1003 -- Internal Name: REJECT_MESSAGE
1004 --
1005 -- Display Name: Reject Message
1006 --
1010 --
1007 -- Item Attributes: MSG_ID, COMMENT, REJECTED
1008 --
1009 -- Activity Attributes: None
1011 -- Mandatory WI Params: None
1012 --
1013 -- Optional WI Params: None
1014 --
1015 PROCEDURE REJECT_MESSAGE
1016 (ITEMTYPE IN VARCHAR2
1017 ,ITEMKEY IN VARCHAR2
1018 ,ACTID IN NUMBER
1019 ,FUNCMODE IN VARCHAR2
1020 ,RESULTOUT OUT NOCOPY VARCHAR2
1021 ) ;
1022
1023
1024 -- Attempts to Retry the message
1025 --
1026 -- Item Type: SFM Standard (XDPWFSTD)
1027 --
1028 -- Internal Name: RETRY_MESSAGE
1029 --
1030 -- Display Name: Retry Message
1031 --
1032 -- Relevant Procedures Invoked: XNP_MESSAGE.FIX
1033 --
1034 -- Item Attributes: MSG_ID
1035 --
1036 -- Activity Attributes: None
1037 --
1038 -- Mandatory WI Params: None
1039 --
1040 -- Optional WI Params: None
1041 --
1042 PROCEDURE RETRY_MESSAGE
1043 (ITEMTYPE IN VARCHAR2
1044 ,ITEMKEY IN VARCHAR2
1045 ,ACTID IN NUMBER
1046 ,FUNCMODE IN VARCHAR2
1047 ,RESULTOUT OUT NOCOPY VARCHAR2
1048 ) ;
1049
1050 -- SFM's Version of WAITFORFLOW
1051 -- Make sure this procedure is invoked immediately after a
1052 -- PROVISION_NES, DEPROVISION_NES and MODIFY_NES
1053 --
1054 -- Item Type: SFM Standard (XDPWFSTD)
1055 --
1056 -- Internal Name: WAITFORFLOW
1057 --
1058 -- Display Name: Wait For Flow
1059 --
1060 --
1061 PROCEDURE WAITFORFLOW
1062 (ITEMTYPE IN VARCHAR2
1063 ,ITEMKEY IN VARCHAR2
1064 ,ACTID IN NUMBER
1065 ,FUNCMODE IN VARCHAR2
1066 ,RESULTOUT OUT NOCOPY VARCHAR2
1067 ) ;
1068
1069
1070 -- SFM's Version of CONTINUEFLOW
1071 --
1072 -- Item Type: SFM Standard (XDPWFSTD)
1073 --
1074 -- Internal Name: CONTINUEFLOW
1075 --
1076 -- Display Name: Continue Flow
1077 --
1078 --
1079 PROCEDURE CONTINUEFLOW
1080 (ITEMTYPE IN VARCHAR2
1081 ,ITEMKEY IN VARCHAR2
1082 ,ACTID IN NUMBER
1083 ,FUNCMODE IN VARCHAR2
1084 ,RESULTOUT OUT NOCOPY VARCHAR2
1085 ) ;
1086
1087
1088 -- Sets the Locked flag to the given value for the enties in xnp_sv_soa
1089 -- for the given PORTING_ID workitem paramter.
1090 --
1091 -- Internal Name: Not being used - Use SET_FLAG_VALUE
1092 --
1093 -- Display Name: Not being used
1094 --
1095 -- Relevant Cores Invoked: SOA_SET_LOCKED_FLAG
1096 --
1097 -- Item Attributes: WORKITEM_INSTANCE_ID
1098 --
1099 -- Activity Attributes: None
1100 --
1101 -- Mandatory WI Params: None
1102 --
1103 -- Optional WI Params: None
1104 --
1105 PROCEDURE SOA_SET_LOCKED_FLAG
1106 (ITEMTYPE IN VARCHAR2
1107 ,ITEMKEY IN VARCHAR2
1108 ,ACTID IN NUMBER
1109 ,FUNCMODE IN VARCHAR2
1110 ,RESULTOUT OUT NOCOPY VARCHAR2
1111 );
1112
1113
1114
1115 -- Gets the Locked flag for the given PORTING_ID workitem paramter
1116 -- The activity is completed with the flag value
1117 --
1118 -- Internal Name: Not being used - USE SET_FLAG_VALUE
1119 --
1120 -- Display Name: Not being used - USE SET_FLAG_VALUE
1121 --
1122 -- Relevant Cores Invoked: XNP_CORE.SOA_GET_LOCKED_FLAG
1123 --
1124 -- Item Attributes: WORKITEM_INSTANCE_ID
1125 --
1126 -- Activity Attributes: FLAG_VALUE
1127 --
1128 -- Mandatory WI Params: None
1129 --
1130 -- Optional WI Params: None
1131 --
1132 PROCEDURE SOA_GET_LOCKED_FLAG
1133 (ITEMTYPE IN VARCHAR2
1134 ,ITEMKEY IN VARCHAR2
1135 ,ACTID IN NUMBER
1136 ,FUNCMODE IN VARCHAR2
1137 ,RESULTOUT OUT NOCOPY VARCHAR2
1138 );
1139
1140
1141
1142 -- Checks if the STATUS_TYPE_CODE from xnp_sv_soa for the PORTING ID is same as the given status.
1143 -- (in STATUS_TO_COMPARE_WITH)
1144 -- @return 'T' if statuses match, 'F' if they don't
1145 --
1146 -- Item Type: NP Standard (XNPWFSTD)
1147 --
1148 -- Internal Name: CHECK_SV_STATUS
1149 --
1150 -- Display Name: Verify Porting Status
1151 --
1152 -- Relevant Core Invoked: SOA_CHECK_SV_STATUS
1153 --
1154 -- Item Attributes: WORKITEM_INSTANCE_ID
1155 --
1156 -- Activity Attributes: STATUS_TO_COMPARE_WITH
1157 --
1158 -- Mandatory WI Params: PORTING_ID, SP_NAME
1159 --
1160 -- Optional WI Params: None
1161 --
1162 PROCEDURE SOA_CHECK_SV_STATUS
1163 (ITEMTYPE IN VARCHAR2
1164 ,ITEMKEY IN VARCHAR2
1165 ,ACTID IN NUMBER
1166 ,FUNCMODE IN VARCHAR2
1167 ,RESULTOUT OUT NOCOPY VARCHAR2
1168 );
1169
1170
1171
1172 -- Gets the Status for the porting record for the PORTING_ID
1173 --
1174 -- Item Type: NP Standard (XNPWFSTD)
1175 --
1176 -- Internal Name: GET_PORTING_STATUS
1177 --
1178 -- Display Name: Get Porting Status
1179 --
1180 -- Relevant Cores Invoked: SOA_GET_SV_STATUS
1181 --
1182 -- Item Attributes: WORKITEM_INSTANCE_ID
1183 --
1184 -- Activity Attributes: None
1185 --
1186 -- Mandatory WI Params: PORTING_ID, SP_NAME
1187 --
1188 -- Activity Attributes: None
1189 --
1190 -- Optional WI Params: None
1191 --
1192 PROCEDURE SOA_GET_SV_STATUS
1193 (ITEMTYPE IN VARCHAR2
1194 ,ITEMKEY IN VARCHAR2
1195 ,ACTID IN NUMBER
1196 ,FUNCMODE IN VARCHAR2
1200
1197 ,RESULTOUT OUT NOCOPY VARCHAR2
1198 );
1199
1201
1202 -- Gets the FEs to be Modified for the feature type and number range
1203 -- For each FE the SFM's provisioning
1204 -- procedure (execute fa) is invoked. At the end of this activty
1205 -- the control passes on to the Provisioning subsystem which
1206 -- executes the fulfillment procedure. An FA_DONE message is
1207 -- subscribed for each FA being executed which gives the execution
1208 -- result of the fulfillment procedure. The callback procedure
1209 -- associated with the FA_DONE handles the responses received.
1210 --
1211 -- In must ensured that the immediate next activity following
1212 -- the activity must be SFM Standard's Wait For Flow. This
1213 -- is to ensure proper handoff from the provisioning system
1214 -- back to the NP System.
1215 --
1216 -- Note: Only FEs which were earlier provisioned by this SP
1217 -- can be modified. Otherwise the FEs will be ignored.
1218 --
1219 -- Item Type: SFM Standard (XDPWFSTD)
1220 --
1221 -- Internal Name: MODIFY_FES
1222 --
1223 -- Display Name: Modify FEs
1224 --
1225 -- Relevant Procedures Invoked:
1226 -- XDP_ENG_UTIL.ADD_FA_TOWI - returns fa instance id
1227 -- XDP_ENG_UTIL.EXECUTE_FA - with INTERNAL option
1228 -- XNP_EVENT.SUBSCRIBE with
1229 -- - callback procedure XNP_FA_CP.PROCESS_FA_DONE
1230 -- - reference ID as the returned fa instance ID
1231 --
1232 -- Item Attributes: ORDER_ID, WORKITEM_INSTANCE_ID
1233 --
1234 -- Activity Attributes: FEATURE_TYPE
1235 --
1236 -- Mandatory WI Params: STARTING_NUMBER, ENDING_NUMBER
1237 --
1238 -- Optional WI Params: None
1239 --
1240 PROCEDURE SMS_MODIFY_NES
1241 (ITEMTYPE IN VARCHAR2
1242 ,ITEMKEY IN VARCHAR2
1243 ,ACTID IN NUMBER
1244 ,FUNCMODE IN VARCHAR2
1245 ,RESULTOUT OUT NOCOPY VARCHAR2
1246 );
1247
1248
1249
1250
1251 -- Updates the New SP Due date for the porting record for the current SP
1252 --
1253 -- Internal Name: Not used - Use UPDATE_DATE
1254 --
1255 -- Display Name: Not used - Use UPDATE_DATE
1256 --
1257 -- Relevant Procedures Invoked:
1258 --
1259 -- Item Attributes: WORKITEM_INSTANCE_ID
1260 --
1261 -- Activity Attributes: None
1262 --
1263 -- Mandatory WI Params: SP_NAME, NEW_SP_DUE_DATE
1264 -- PORTING_ID
1265 --
1266 -- Optional WI Params: None
1267 --
1268 PROCEDURE SOA_UPDATE_NEW_SP_DUE_DATE
1269 (ITEMTYPE IN VARCHAR2
1270 ,ITEMKEY IN VARCHAR2
1271 ,ACTID IN NUMBER
1272 ,FUNCMODE IN VARCHAR2
1273 ,RESULTOUT OUT NOCOPY VARCHAR2
1274 );
1275
1276
1277 -- Updates the New SP Due date for the porting record for the current SP
1278 --
1279 -- Internal Name: Not used - Use UPDATE_DATE
1280 --
1281 -- Display Name: Not used - Use UPDATE_DATE
1282 --
1283 -- Relevant Procedures Invoked:
1284 --
1285 -- Item Attributes: WORKITEM_INSTANCE_ID
1286 --
1287 -- Activity Attributes: None
1288 --
1289 -- Mandatory WI Params: SP_NAME, OLD_SP_DUE_DATE
1290 -- PORTING_ID
1291 --
1292 -- Optional WI Params: None
1293 --
1294 PROCEDURE SOA_UPDATE_OLD_SP_DUE_DATE
1295 (ITEMTYPE IN VARCHAR2
1296 ,ITEMKEY IN VARCHAR2
1297 ,ACTID IN NUMBER
1298 ,FUNCMODE IN VARCHAR2
1299 ,RESULTOUT OUT NOCOPY VARCHAR2
1300 );
1301
1302
1303 -- Procedure to check if there exists a Porting record in the given status
1304 -- for this TN range and beloging to the
1305 -- with the given DONOR's SP ID
1306 -- Completes with 'Y' or 'N'
1307 --
1308 -- Relevant Cores Invoked: SOA_CHECK_DON_STATUS_EXISTS
1309 --
1310 -- Item Attributes: WORKITEM_INSTANCE_ID
1311 --
1312 -- Activity Attributes: None
1313 --
1314 -- Mandatory WI Params: STARTING_NUMBER,ENDING_NUMBER,
1315 -- DONOR_SP_ID
1316 --
1317 -- Optional WI Params: None
1318 --
1319 -- Item Type: NP Standard (XNPWFSTD)
1320 --
1321 -- Internal Name: CHECK_DON_STATUS_EXISTS
1322 --
1323 -- Display Name: Does Porting Record Exist for the Donor
1324 --
1325 PROCEDURE SOA_CHECK_DON_STATUS_EXISTS
1326 (ITEMTYPE IN VARCHAR2
1327 ,ITEMKEY IN VARCHAR2
1328 ,ACTID IN NUMBER
1329 ,FUNCMODE IN VARCHAR2
1330 ,RESULTOUT OUT NOCOPY VARCHAR2
1331 );
1332
1333
1334 -- Procedure to check if there exists a Porting record in the given status
1335 -- for this TN range and beloging to the
1336 -- with the given Recipient's SP ID
1337 -- Completes with 'Y' or 'N'
1338 --
1339 -- Relevant Cores Invoked: SOA_CHECK_REC_STATUS_EXISTS
1340 --
1341 -- Item Type: NP Standard (XNPWFSTD)
1342 --
1343 -- Internal Name: CHECK_REC_STATUS_EXISTS
1344 --
1345 -- Display Name: Does Porting Record Exist for the Recipient
1346 --
1347 -- Item Attributes: WORKITEM_INSTANCE_ID
1348 --
1349 -- Activity Attributes: None
1350 --
1351 -- Mandatory WI Params: STARTING_NUMBER,ENDING_NUMBER,
1352 -- RECIPIENT_SP_ID
1353 --
1354 -- Optional WI Params: None
1355 --
1356 PROCEDURE SOA_CHECK_REC_STATUS_EXISTS
1357 (ITEMTYPE IN VARCHAR2
1358 ,ITEMKEY IN VARCHAR2
1359 ,ACTID IN NUMBER
1360 ,FUNCMODE IN VARCHAR2
1361 ,RESULTOUT OUT NOCOPY VARCHAR2
1362 );
1363
1364
1368 -- (a.k.a OBJECT_REFERENCE) and
1365
1366 -- Procedure to update the status of the Porting Order Records to the new status
1367 -- for the given PORTING_ID
1369 -- belonging to the (local) SP ID.
1370 --
1371 -- Internal Name: Not being used - Use UPDATE_SV_STATUS
1372 --
1373 -- Display Name: Not being used - Use UPDATE_SV_STATUS
1374 --
1375 -- Relevant Cores Invoked: XNP_CORE.SOA_UPDATE_SV_STATUS
1376 --
1377 -- Item Attributes: WORKITEM_INSTANCE_ID
1378 --
1379 -- Activity Attributes:
1380 --
1381 -- Mandatory WI Params: SP_NAME,PORTING_ID
1382 --
1383 -- Optional WI Params: None
1384 --
1385 PROCEDURE SOA_UPD_PORTING_ID_STATUS
1386 (ITEMTYPE IN VARCHAR2
1387 ,ITEMKEY IN VARCHAR2
1388 ,ACTID IN NUMBER
1389 ,FUNCMODE IN VARCHAR2
1390 ,RESULTOUT OUT NOCOPY VARCHAR2
1391 );
1392
1393
1394
1395
1396 -- Sets the flag to the given value
1397 -- for the entries in xnp_sv_soa for the given
1398 -- PORTING_ID workitem paramter and FLAG_NAME
1399 -- for the current SP.
1400 -- Values: 'Y' or 'N'
1401 --
1402 -- Item Type: NP Standard (XNPWFSTD)
1403 --
1404 -- Internal Name: SET_FLAG_VALUE
1405 --
1406 -- Display Name: Set Flag Value
1407 --
1408 -- Relevant Procedures Invoked:
1409 -- Calls the core function to set the corresponding
1410 -- flag value
1411 -- SOA_SET_LOCKED_FLAG
1412 -- SOA_UPDATE_NEW_SP_AUTH_FLAG
1413 -- SOA_UPDATE_OLD_SP_AUTH_FLAG
1414 -- SOA_SET_BLOCKED_FLAG
1415 -- SOA_SET_CONCURRENCE_FLAG
1416 --
1417 -- Item Attributes: WORKITEM_INSTANCE_ID
1418 --
1419 -- Activity Attributes: FLAG_NAME
1420 --
1421 -- Mandatory WI Params: PORTING_ID, SP_NAME
1422 --
1423 -- Optional WI Params: None
1424 --
1425 PROCEDURE SOA_SET_FLAG_VALUE
1426 (ITEMTYPE IN VARCHAR2
1427 ,ITEMKEY IN VARCHAR2
1428 ,ACTID IN NUMBER
1429 ,FUNCMODE IN VARCHAR2
1430 ,RESULTOUT OUT NOCOPY VARCHAR2
1431 );
1432
1433
1434 -- Gets the Locked flag for the given PORTING_ID workitem paramter.
1435 -- The activity is completed with the flag value
1436 -- Values: 'Y' or 'N'
1437 --
1438 -- Item Type: NP Standard (XNPWFSTD)
1439 --
1440 -- Internal Name: GET_FLAG_VALUE
1441 --
1442 -- Display Name: Get Flag Value
1443 --
1444 -- Relevant Procedures Invoked:
1445 -- Calls the core function to set the corresponding
1446 -- flag value
1447 -- SOA_GET_LOCKED_FLAG
1448 -- SOA_GET_NEW_SP_AUTH_FLAG
1449 -- SOA_GET_OLD_SP_AUTH_FLAG
1450 -- SOA_GET_BLOCKED_FLAG
1451 -- SOA_GET_CONCURRENCE_FLAG
1452 --
1453 -- Item Attributes: WORKITEM_INSTANCE_ID
1454 --
1455 -- Activity Attributes: FLAG_NAME
1456 --
1457 -- Mandatory WI Params: PORTING_ID, SP_NAME
1458 --
1459 -- Optional WI Params: None
1460 --
1461 PROCEDURE SOA_GET_FLAG_VALUE
1462 (ITEMTYPE IN VARCHAR2
1463 ,ITEMKEY IN VARCHAR2
1464 ,ACTID IN NUMBER
1465 ,FUNCMODE IN VARCHAR2
1466 ,RESULTOUT OUT NOCOPY VARCHAR2
1467 );
1468
1469
1470 -- Updates the DATE for the given porting record
1471 -- given the PORTING_ID. The date to update i.e.
1472 -- NEW_SP_DUE_DATE, OLD_SP_DUE_DATE,ACTIVATION_DUE_DATE,etc
1473 --
1474 -- Note: The date format must is the workitem parameter
1475 -- must be 'YYYY/MM/DD HH24:MI:SS'
1476 --
1477 -- Item Type: NP Standard (XNPWFSTD)
1478 --
1479 -- Internal Name: UPDATE_DATE_VALUE
1480 --
1481 -- Display Name: Update with new date
1482 --
1483 -- Relevant Cores Invoked:
1484 -- Calls XNP_CORE.<function to update the right date>
1485 -- SOA_UPDATE_NEW_SP_DUE_DATE or
1486 -- SOA_UPDATE_ACTIVATION_DUE_DATE or
1487 -- SOA_UPDATE_NEW_SP_DUE_DATE
1488 -- SOA_UPDATE_DISCONNECT_DUE_DATE
1489 -- SOA_UPDATE_EFFECTIVE_RELEASE_DUE_DATE
1490 -- SOA_UPDATE_NUMBER_RETURNED_DUE_DATE
1491 --
1492 -- Item Attributes: WORKITEM_INSTANCE_ID
1493 --
1494 -- Activity Attributes: NEW_STATUS_TYPE_CODE,
1495 -- STATUS_CHANGE_CAUSE_CODE
1496 --
1497 -- Mandatory WI Params: PORTING_ID
1498 -- OLD_SP_DUE_DATE, NEW_SP_DUE_DATE, ACTIVATION_DUE_DATE,
1499 -- DISCONNECT_DUE_DATE, EFFECTIVE_RELEASE_DUE_DATE,
1500 -- NUMBER_RETURNED_DUE_DATE
1501 --
1502 -- Optional WI Params: None
1503 --
1504 --
1505 PROCEDURE SOA_UPDATE_DATE
1506 (ITEMTYPE IN VARCHAR2
1507 ,ITEMKEY IN VARCHAR2
1508 ,ACTID IN NUMBER
1509 ,FUNCMODE IN VARCHAR2
1510 ,RESULTOUT OUT NOCOPY VARCHAR2
1511 );
1512
1513
1514
1515 -- Checks if the donor SP of the porting transaction has provisioned the Number range
1516 -- or is assigned the number range
1517 -- If either of them is true then it completes the
1518 -- the activity with Y
1519 --
1520 -- Relevant Cores Invoked: XNP_CORE.CHECK_IF_SP_ASSIGNED
1521 --
1522 -- Item Type: NP Standard (XNPWFSTD)
1523 --
1524 -- Internal Name: CHECK_IF_DONOR_CAN_PORT_OUT
1525 --
1526 -- Display Name: Check if donor is eligible to port out
1527 --
1528 --
1529 -- Item Attributes: WORKITEM_INSTANCE_ID
1530 --
1531 -- Activity Attributes: None
1532 --
1533 -- Mandatory WI Params: STARTING_NUMBER,ENDING_NUMBER,
1534 -- DONOR_SP_ID
1535 --
1536 -- Optional WI Params: None
1537 --
1541 ,ACTID IN NUMBER
1538 PROCEDURE CHECK_IF_DONOR_CAN_PORT_OUT
1539 (ITEMTYPE IN VARCHAR2
1540 ,ITEMKEY IN VARCHAR2
1542 ,FUNCMODE IN VARCHAR2
1543 ,RESULTOUT OUT NOCOPY VARCHAR2
1544 );
1545
1546
1547 -- Checks if the DONOR_SP_ID (WI param) is the Initial donor
1548 --
1549 -- Relevant cores Invoked: XNP_CORE.SOA_CHECK_IF_INITIAL_DONOR
1550 --
1551 -- Item Type: NP Standard (XNPWFSTD)
1552 --
1553 -- Internal Name: CHECK_IF_DON_IS_INITIAL_DON
1554 --
1555 -- Display Name: Check if Donor is also the Initial Donor
1556 --
1557 -- Item Attributes: WORKITEM_INSTANCE_ID
1558 --
1559 -- Activity Attributes: None
1560 --
1561 -- Mandatory WI Params: STARTING_NUMBER,
1562 -- ENDING_NUMBER, DONOR_SP_ID
1563 --
1564 -- Optional WI Params: None
1565 --
1566 PROCEDURE CHECK_IF_DON_IS_INITIAL_DON
1567 (ITEMTYPE IN VARCHAR2
1568 ,ITEMKEY IN VARCHAR2
1569 ,ACTID IN NUMBER
1570 ,FUNCMODE IN VARCHAR2
1571 ,RESULTOUT OUT NOCOPY VARCHAR2
1572 );
1573
1574
1575 -- Updates the Comments and Notes for the Porting ID and for the current SP
1576 --
1577 -- Relevant Procedures Invoked: SOA_UPDATE_NOTES_INFO
1578 --
1579 -- Item Type: NP Standard (XNPWFSTD)
1580 --
1581 -- Internal Name: SOA_UPDATE_NOTES_INFO
1582 --
1583 -- Display Name: Update Comments and Notes Information
1584 --
1585 -- Item Attributes: WORKITEM_INSTANCE_ID
1586 --
1587 -- Activity Attributes: COMMENTS, NOTES
1588 --
1589 -- Mandatory WI Params: COMMENTS, NOTES, PORTING_ID
1590 -- PREORDER_AUTHORIZATION_CODE, SP_NAME
1591 --
1592 -- Optional WI Params: None
1593 --
1594 PROCEDURE SOA_UPDATE_NOTES_INFO
1595 (ITEMTYPE IN VARCHAR2
1596 ,ITEMKEY IN VARCHAR2
1597 ,ACTID IN NUMBER
1598 ,FUNCMODE IN VARCHAR2
1599 ,RESULTOUT OUT NOCOPY VARCHAR2
1600 );
1601
1602
1603 -- Updates the customer information for the current Porting ID and for the current SP
1604 --
1605 -- Item Type: NP Standard (XNPWFSTD)
1606 --
1607 -- Internal Name: SOA_UPDATE_CUSTOMER_INFO
1608 --
1609 -- Display Name: Update Customer Information
1610 --
1611 -- Relevant Procedures Invoked: SOA_UPDATE_CUSTOMER_INFO
1612 --
1613 -- Item Attributes: WORKITEM_INSTANCE_ID
1614 --
1615 -- Activity Attributes: None
1616 --
1617 -- Mandatory WI Params: PORTING_ID, SP_NAME
1618 --
1619 -- Optional WI Params: CUSTOMER_ID,
1620 -- CUSTOMER_NAME,CUSTOMER_TYPE, ADDRESS_LINE1,ADDRESS_LINE_2, CITY, PHONE, FAX, EMAIL,
1621 -- ZIP_CODE, COUNTRY, CUSTOMER_CONTACT_REQ_FLAG, CONTACT_NAME,
1622 -- PAGER, INTERNET_ADDRESS, SP_NAME
1623 --
1624 PROCEDURE SOA_UPDATE_CUSTOMER_INFO
1625 (ITEMTYPE IN VARCHAR2
1626 ,ITEMKEY IN VARCHAR2
1627 ,ACTID IN NUMBER
1628 ,FUNCMODE IN VARCHAR2
1629 ,RESULTOUT OUT NOCOPY VARCHAR2
1630 );
1631
1632
1633 -- Updates the Network information for the current Porting ID
1634 -- and for the current SP in the XNP_SV_SOA
1635 --
1636 -- Relevant Procedures Invoked: SOA_UPDATE_NETWORK_INFO
1637 --
1638 -- Item Type: NP Standard (XNPWFSTD)
1639 --
1640 -- Internal Name: SOA_UPDATE_NETWORK_INFO
1641 --
1642 -- Display Name: Update Network Info in SOA
1643 --
1644 -- Item Attributes: WORKITEM_INSTANCE_ID
1645 --
1646 -- Activity Attributes: None
1647 --
1648 -- Mandatory WI Params: PORTING_ID, SP_NAME
1649 --
1650 -- Optional Workitem parameters: CNAM_ADDRESS, CNAM_SUBSYSTEM
1651 -- ISVM_ADDRESS, ISVM_SUBSYSTEM, LIDB_ADDRESS, CLASS_ADDRESS,
1652 -- CLASS_SUBSYSTEM, WSMSC_ADDRESS, WSMSC_SUBSYSTEM, RN_ADDRESS
1653 -- RN_SUBSYSTEM, ROUTING_NUMBER,
1654 --
1655 PROCEDURE SOA_UPDATE_NETWORK_INFO
1656 (ITEMTYPE IN VARCHAR2
1657 ,ITEMKEY IN VARCHAR2
1658 ,ACTID IN NUMBER
1659 ,FUNCMODE IN VARCHAR2
1660 ,RESULTOUT OUT NOCOPY VARCHAR2
1661 );
1662
1663
1664 -- Prepares Customized Notification.
1665 -- The User can define the customized notification to be
1666 -- desplayed at runtime by defining his own message.
1667 -- The Message name should be of the format
1668 -- 'X%_NOTFN_%' - max 29 chars
1669 --
1670 -- An e.g. of the user define message would be
1671 --
1672 -- " Porting requested for &STARTING_NUMBER thru &ENDING_NUMBER
1673 -- on &NEW_SP_DUE_DATE "
1674 --
1675 -- The tokens after the "&" should be then name of the workitem
1676 -- parameter.
1677 -- This activity scans the message and replaces the tokens
1678 -- with the values in the workitem item parameters.
1679 --
1680 -- Once these messages are created, run the lookup loader
1681 -- script to load these user defined messages onto
1682 -- the workflow lookup code CUSTOMIZED_NOTN_MESSAGES.
1683 -- This activity would set the frist line of the notification
1684 -- message in the item attribute MSG_SUBJECT and the
1685 -- entire contents in MSG_BODY. The created notification
1686 -- would contain the message with all the referenced
1687 -- workitem parameters with the actual value.
1688 --
1689 -- The user can create a Notification with these item
1690 -- attributes for the subject and body.
1691 --
1692 -- Relevant Procedures Invoked:
1693 -- xnp_utils.get_interpreted_notification
1694 --
1695 -- Item Type: SFM Standard (XDPWFSTD)
1696 --
1697 -- Internal Name: PREPARE_CUSTOM_NOTIFICATION
1698 --
1702 -- MSG_SUBJECT, MSG_BODY
1699 -- Display Name: Prepare Customized Notification
1700 --
1701 -- Item Attributes: ORDER_ID, WORKITEM_INSTANCE_ID
1703 --
1704 -- Activity Attributes: NOTIFN_MSG_NAME
1705 --
1706 -- Optional WI Params: All wi parameters
1707 -- referenced in the user defined notification message
1708 --
1709 -- Mandatory WI Params: None
1710 --
1711 PROCEDURE PREPARE_CUSTOM_NOTIFN
1712 (ITEMTYPE IN VARCHAR2
1713 ,ITEMKEY IN VARCHAR2
1714 ,ACTID IN NUMBER
1715 ,FUNCMODE IN VARCHAR2
1716 ,RESULTOUT OUT NOCOPY VARCHAR2
1717 );
1718
1719
1720 -- Updates the status type code in the XNP_SV_SOA with the new status type code
1721 -- All records with the porting ID and belonging
1722 -- to the current SP are updated to th new status.
1723 -- If the new status belongs to the ACTIVE phase, and if there
1724 -- exists records for this number range already in ACTIVE phase,
1725 -- then they first are reset to OLD phase. The actual updation of
1726 -- the records with the given porting id is done next.
1727 --
1728 -- Relevant Core Procedures Invoked: SOA_UPDATE_SV_STATUS,
1729 -- SOA_RESET_SV_STATUS
1730 --
1731 -- Item Type: NP Standard (XNPWFSTD)
1732 --
1733 -- Internal Name: UPDATE_CUR_SV_STATUS
1734 --
1735 -- Display Name: Update Current SV Status
1736 --
1737 -- Item Attributes: WORKITEM_INSTANCE_ID
1738 --
1739 -- Activity Attributes: NEW_STATUS_TYPE_CODE, STATUS_CHANGE_CAUSE_CODE
1740 -- CUR_STATUS_TYPE_CODE
1741 --
1742 -- Mandatory WI Params: STARTING_NUMBER, ENDING_NUMBER, SP_NAME
1743 --
1744 -- Optional WI Params: None
1745 --
1746 PROCEDURE SOA_UPDATE_CUR_SV_STATUS
1747 (ITEMTYPE IN VARCHAR2
1748 ,ITEMKEY IN VARCHAR2
1749 ,ACTID IN NUMBER
1750 ,FUNCMODE IN VARCHAR2
1751 ,RESULTOUT OUT NOCOPY VARCHAR2
1752 );
1753
1754
1755 -- Updates the Provisioning done date for the given number range with the current date
1756 --
1757 -- Relevant Core Procedures Invoked: None
1758 --
1759 -- Item Type: NP Standard (XNPWFSTD)
1760 --
1761 -- Internal Name: UPDATE_PROV_DONE_DATE
1762 --
1763 -- Display Name: Update Provisioning Done Date
1764 --
1765 -- Item Attributes: WORKITEM_INSTANCE_ID
1766 --
1767 -- Activity Attributes: None
1768 --
1769 -- Mandatory WI Params: STARTING_NUMBER, ENDING_NUMBER
1770 --
1771 -- Optional WI Params: None
1772 --
1773 -- Tables: XNP_SV_SMS
1774 --
1775 --
1776 PROCEDURE SMS_UPDATE_PROV_DONE_DATE
1777 (ITEMTYPE IN VARCHAR2
1778 ,ITEMKEY IN VARCHAR2
1779 ,ACTID IN NUMBER
1780 ,FUNCMODE IN VARCHAR2
1781 ,RESULTOUT OUT NOCOPY VARCHAR2
1782 );
1783
1784 -- Runtime Validation checks for NP Workitem
1785 --
1786 -- Item Type: NP STANDARD (XNPWFSTD)
1787 --
1788 -- Internal Name: VALIDATE_RUNTIME_DATA
1789 --
1790 -- Diaplay Name: Validate Runtime Data
1791 --
1792 -- Item Attributes: WORKITEM_INSTANCE_ID
1793 --
1794 -- Activity Attributes: None
1795 --
1796 -- Mandatory WI Params:
1797 --
1798 -- Optional WI Params: STARTING_NUMBER,ENDING_NUMBER,ROUTING_NUMBER,
1799 -- DONOR_SP_CODE,RECIPIENT_SP_CODE
1800 --
1801 PROCEDURE RUNTIME_VALIDATION
1802 (ITEMTYPE IN VARCHAR2
1803 ,ITEMKEY IN VARCHAR2
1804 ,ACTID IN NUMBER
1805 ,FUNCMODE IN VARCHAR2
1806 ,RESULTOUT OUT NOCOPY VARCHAR2
1807 ) ;
1808
1809 -- Sync item parameter values with their corresponding work items.
1810 --
1811 -- Item Type: SFM STANDARD (XNPWFSTD)
1812 --
1813 -- Internal Name: SYNC_LI_PARAMETERS
1814 --
1815 -- Diaplay Name: Sync Line Item Parameters
1816 --
1817 -- Item Attributes: LINE_ITEM_ID
1818 --
1819 -- Activity Attributes: None
1820 --
1821 -- Mandatory WI Params:
1822 --
1823 -- Optional WI Params: None
1824 --
1825 --
1826
1827 Procedure SYNC_LI_PARAMETER_VALUES (itemtype in varchar2,
1828 itemkey in varchar2,
1829 actid in number,
1830 funcmode in varchar2,
1831 resultout OUT NOCOPY varchar2 );
1832 --
1833 -- To retrieve order fulfillment status.
1834 --
1835 -- Item Type: SFM STANDARD (XNPWFSTD)
1836 --
1837 -- Internal Name: GET_ORDER_FULFILLMENT_STATUS
1838 --
1839 -- Diaplay Name: Get Order Fulfillment Status
1840 --
1841 -- Item Attributes: ORDER_ID
1842 --
1843 -- Activity Attributes: None
1844 --
1845 -- Mandatory WI Params:
1846 --
1847 -- Optional WI Params: None
1848 --
1849 Procedure GET_ORD_FULFILLMENT_STATUS (itemtype in varchar2,
1850 itemkey in varchar2,
1851 actid in number,
1852 funcmode in varchar2,
1853 resultout OUT NOCOPY varchar2 );
1854
1855 --
1856 -- To set user defined order fulfillment status.
1857 --
1858 -- Item Type: SFM STANDARD (XNPWFSTD)
1859 --
1860 -- Internal Name: SET_ORDER_FULFILLMENT_STATUS
1861 --
1862 -- Diaplay Name: Set Order Fulfillment Status
1863 --
1864 -- Item Attributes: ORDER_ID
1865 --
1866 -- Activity Attributes:
1867 -- FULFILLMENT_STATUS
1868 -- FULFILLMENT_RESULT
1869 --
1870 -- Mandatory WI Params:
1871 --
1875 itemkey in varchar2,
1872 -- Optional WI Params: None
1873 --
1874 Procedure SET_ORD_FULFILLMENT_STATUS (itemtype in varchar2,
1876 actid in number,
1877 funcmode in varchar2,
1878 resultout OUT NOCOPY varchar2 );
1879
1880 --
1881 -- To set user defined WI fulfillment status.
1882 --
1883 -- Item Type: SFM STANDARD (XNPWFSTD)
1884 --
1885 -- Internal Name: SET_ORDER_FULFILLMENT_STATUS
1886 --
1887 -- Diaplay Name: Set Order Fulfillment Status
1888 --
1889 -- Item Attributes: WORKITEM_INSTANCE_ID
1890 --
1891 -- Activity Attributes:
1892 -- FULFILLMENT_STATUS
1893 -- FULFILLMENT_RESULT
1894 --
1895 -- Mandatory WI Params:
1896 --
1897 -- Optional WI Params: None
1898 --
1899
1900 Procedure SET_WI_FULFILLMENT_STATUS (itemtype in varchar2,
1901 itemkey in varchar2,
1902 actid in number,
1903 funcmode in varchar2,
1904 resultout OUT NOCOPY varchar2 ) ;
1905
1906 --
1907 -- To De register all Waiting Timers and Events for the Order
1908 --
1909 -- Item Type: SFM STANDARD (XNPWFSTD)
1910 --
1911 -- Internal Name: DEREGISTER_ALL
1912 --
1913 -- Diaplay Name: De-Register All Order Events and Timers
1914 --
1915 -- Item Attributes: ORDER_ID
1916 --
1917 -- Activity Attributes:
1918 --
1919 -- Mandatory WI Params:
1920 --
1921 -- Optional WI Params: None
1922 --
1923
1924 Procedure DEREGISTER_ALL (itemtype in varchar2,
1925 itemkey in varchar2,
1926 actid in number,
1927 funcmode in varchar2,
1928 resultout OUT NOCOPY varchar2 ) ;
1929
1930
1931
1932
1933
1934 END XNP_WF_STANDARD;