DBA Data[Home] [Help]

APPS.XNP_WF_STANDARD dependencies on STANDARD

Line 1: PACKAGE XNP_WF_STANDARD AUTHID CURRENT_USER AS

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:

Line 56: -- Item Type: NP Standard (XNPWFSTD)

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

Line 150: -- Item Type: NP Standard (XNPWFSTD)

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

Line 199: -- Item Type: NP Standard (XNPWFSTD)

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

Line 233: -- Item Type: SFM Standard (XDPWFSTD)

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

Line 272: -- 1. XNP_STANDARD.SUBSCRIBE_FOR_EVENT

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: --

Line 292: -- Item Type: SFM Standard (XDPWFSTD)

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

Line 333: -- 1. XNP_STANDARD.SUBSCRIBE_FOR_ACKS

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: --

Line 359: -- Item Type: NP Standard (XNPWFSTD)

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

Line 400: -- Item Type: SFM Standard (XDPWFSTD)

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

Line 455: -- 1. XNP_STANDARD.PUBLISH_EVENT

451: -- ...
452: --
453: --
454: -- Relevant Procedures Invoked:
455: -- 1. XNP_STANDARD.PUBLISH_EVENT
456: -- 2. XNP_UTILS.CHECK_TO_GET_REF_ID
457: -- 3. .PUBLISH
458: --
459: --

Line 479: -- Item Type: SFM Standard (XDPWFSTD)

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

Line 528: -- Item Type: NP Standard (XNPWFSTD)

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

Line 593: -- the activity must be SFM Standard's Wait For Flow. This

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)

Line 597: -- Item Type: NP Standard (XNPWFSTD)

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

Line 637: -- the activity must be SFM Standard's 'Wait For Flow'. This

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

Line 644: -- Item Type: NP Standard (XNPWFSTD)

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

Line 675: -- Item Type: SFM Standard (XDPWFSTD)

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

Line 730: -- Item Type: SFM Standard (XDPWFSTD)

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

Line 740: -- XNP_STANDARD.SOA_CHECK_ORDER_STATUS

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

Line 759: -- Item Type: NP Standard (XNPWFSTD)

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

Line 787: -- Item Type: NP Standard (XNPWFSTD)

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

Line 793: -- Relevant Procedures Invoked: XNP_STANDARD.SOA_IS_SUBSEQUENT_PORT

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

Line 812: -- Item Type: SFM Standard (XDPWFSTD)

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

Line 902: -- 1. XNP_STANDARD.SEND_MESSAGE - to dynamically invoke the send

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. .SEND
905: --
906: --

Line 1001: -- Item Type: SFM Standard (XDPWFSTD)

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

Line 1026: -- Item Type: SFM Standard (XDPWFSTD)

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

Line 1054: -- Item Type: SFM Standard (XDPWFSTD)

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

Line 1072: -- Item Type: SFM Standard (XDPWFSTD)

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

Line 1146: -- Item Type: NP Standard (XNPWFSTD)

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

Line 1174: -- Item Type: NP Standard (XNPWFSTD)

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

Line 1212: -- the activity must be SFM Standard's Wait For Flow. This

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

Line 1219: -- Item Type: SFM Standard (XDPWFSTD)

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

Line 1319: -- Item Type: NP Standard (XNPWFSTD)

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

Line 1341: -- Item Type: NP Standard (XNPWFSTD)

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

Line 1402: -- Item Type: NP Standard (XNPWFSTD)

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

Line 1438: -- Item Type: NP Standard (XNPWFSTD)

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

Line 1477: -- Item Type: NP Standard (XNPWFSTD)

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

Line 1522: -- Item Type: NP Standard (XNPWFSTD)

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

Line 1551: -- Item Type: NP Standard (XNPWFSTD)

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

Line 1579: -- Item Type: NP Standard (XNPWFSTD)

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

Line 1605: -- Item Type: NP Standard (XNPWFSTD)

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

Line 1638: -- Item Type: NP Standard (XNPWFSTD)

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

Line 1695: -- Item Type: SFM Standard (XDPWFSTD)

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: --
1699: -- Display Name: Prepare Customized Notification

Line 1731: -- Item Type: NP Standard (XNPWFSTD)

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

Line 1759: -- Item Type: NP Standard (XNPWFSTD)

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

Line 1786: -- Item Type: NP STANDARD (XNPWFSTD)

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

Line 1811: -- Item Type: SFM STANDARD (XNPWFSTD)

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

Line 1835: -- Item Type: SFM STANDARD (XNPWFSTD)

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

Line 1858: -- Item Type: SFM STANDARD (XNPWFSTD)

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

Line 1883: -- Item Type: SFM STANDARD (XNPWFSTD)

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

Line 1909: -- Item Type: SFM STANDARD (XNPWFSTD)

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

Line 1934: END XNP_WF_STANDARD;

1930:
1931:
1932:
1933:
1934: END XNP_WF_STANDARD;