Search Results xnp_standard

Overview

XNP_STANDARD is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite, delivered as part of the Oracle Communications / Telecommunications service fulfillment stack (the XNP family of packages). It is a foundational utility package within the number portability and service-order orchestration layer, acting as a shared library that other XNP packages call upon for messaging, event publication, work-item parameter handling, and SOA integration.

The package is documented with an API classification of OTHER, meaning it is a supporting internal library rather than a published, developer-facing API. It is validated in both 12.1.1 and 12.2.2 and is referenced by nine other database objects, which confirms its role as a central dependency rather than an entry point invoked directly by forms or concurrent programs. It is not itself referenced by any database object, indicating it sits at or near the top of its dependency chain.

Key Procedures and Functions

The ETRM metadata documents 31 procedures and functions in this package body. The following are named explicitly:

SMS_CREATE_PORTED_NUMBER / SMS_DELETE_PORTED_NUMBER — Create and remove ported-number records in the SMS layer as part of number portability processing.
SOA_UPDATE_CHARGING_INFO / SOA_UPDATE_CUTOFF_DATE — Push charging details and cutoff-date changes to the SOA integration layer.
SOA_CREATE_PORTING_ORDER — Initiate a porting order through the SOA interface.
SOA_CHECK_NOTIFY_DIR_SVS / SOA_UPDATE_SV_STATUS / SOA_CHECK_ORDER_STATUS / CHECK_SOA_STATUS_EXISTS — Verify and update service-order and notification status through SOA, including existence checks.
DETERMINE_SP_ROLE / CHECK_PHASE_FOR_ROLE — Determine the service-provider role and validate workflow phase transitions for that role.
SET_ORDER_RESULT — Record the outcome of an order-processing operation.
PUBLISH_EVENT / SUBSCRIBE_FOR_EVENT — Publish business events to the event framework and register subscriptions to those events.
SEND_MESSAGE — Send a message through the XNP messaging subsystem.
SMS_DELETE_FE_MAP — Remove a front-end mapping record used in SMS processing.
GET_WORKITEM_PARAM_VALUE / SET_WORKITEM_PARAM_VALUE / GET_MANDATORY_WI_PARAM_VALUE / SET_MANDATORY_WI_PARAM_VALUE — Read and write work-item parameters on the workflow work item, with variant routines enforcing mandatory parameters.

No parameter signatures are published in the ETRM record; callers should treat the argument lists as internal and always invoke through the documented wrapper APIs of the higher-level XNP packages.

Tables Accessed

Only one table is documented as referenced through APPS synonyms: XNP_SV_SOA. This table stores service-order and SOA integration state, and the SOA_* procedures listed above use it to persist and verify charging information, cutoff dates, porting orders, service-order status, and notification state. All other data access is delegated to the dependent packages.

Usage Notes

XNP_STANDARD is invoked indirectly. It depends on XDP_ADAPTER_CORE_DB, XDP_ENGINE, XNP_CORE, XNP_ERRORS, XNP_EVENT, XNP_MESSAGE, XNP_TIMER_STANDARD, XNP_UTILS, XNP_SV_SOA, FND_MESSAGE, and STANDARD. Customizations should never modify the APPS copy of this package body. Instead, extend behavior by wrapping the higher-level XNP packages, or by calling XNP_STANDARD procedures from custom code only after confirming the signature at runtime, since ETRM does not publish the parameter lists.

PACKAGE BODY: APPS.XNP_STANDARD 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:XNP_STANDARD, status:VALID,
PACKAGE: APPS.XNP_STANDARD 12.2.2
owner:APPS, object_type:PACKAGE, object_name:XNP_STANDARD, status:VALID,
PACKAGE: APPS.XNP_STANDARD 12.1.1
owner:APPS, object_type:PACKAGE, object_name:XNP_STANDARD, status:VALID,
PACKAGE BODY: APPS.XNP_STANDARD 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:XNP_STANDARD, status:VALID,
SYNONYM: APPS.XNP_SV_SOA 12.2.2
owner:APPS, object_type:SYNONYM, object_name:XNP_SV_SOA, status:VALID,
SYNONYM: APPS.XNP_SV_SOA 12.1.1
owner:APPS, object_type:SYNONYM, object_name:XNP_SV_SOA, status:VALID,
PACKAGE: APPS.XNP_CORE 12.1.1
owner:APPS, object_type:PACKAGE, object_name:XNP_CORE, status:VALID,
PACKAGE BODY: APPS.XDP_OM_UTIL 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:XDP_OM_UTIL, status:VALID,
PACKAGE BODY: APPS.XDP_OM_UTIL 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:XDP_OM_UTIL, status:VALID,
PACKAGE: APPS.XNP_TIMER_STANDARD 12.1.1
owner:APPS, object_type:PACKAGE, object_name:XNP_TIMER_STANDARD, status:VALID,
PACKAGE: APPS.XNP_TIMER_STANDARD 12.2.2
owner:APPS, object_type:PACKAGE, object_name:XNP_TIMER_STANDARD, status:VALID,
PACKAGE BODY: APPS.XNP_CSENIUPD_U 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:XNP_CSENIUPD_U, status:VALID,
PACKAGE BODY: APPS.XNP_DOCUMENTS 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:XNP_DOCUMENTS, status:VALID,
PACKAGE BODY: APPS.XNP_DOCUMENTS 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:XNP_DOCUMENTS, status:VALID,
PACKAGE: APPS.XNP_CORE 12.2.2
owner:APPS, object_type:PACKAGE, object_name:XNP_CORE, status:VALID,
PACKAGE BODY: APPS.XNP_CSENIUPD_U 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:XNP_CSENIUPD_U, status:VALID,
PACKAGE BODY: APPS.XNP_CONTROL_U 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:XNP_CONTROL_U, status:VALID,
PACKAGE BODY: APPS.XNP_CONTROL_U 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:XNP_CONTROL_U, status:VALID,
PACKAGE BODY: APPS.XNP_CSENICRT_U 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:XNP_CSENICRT_U, status:VALID,
PACKAGE BODY: APPS.XNP_CSENICRT_U 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:XNP_CSENICRT_U, status:VALID,
PACKAGE BODY: APPS.XNP_FA_CB 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:XNP_FA_CB, status:VALID,
PACKAGE BODY: APPS.XNP_FA_CB 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:XNP_FA_CB, status:VALID,
PACKAGE: APPS.XNP_UTILS 12.1.1
owner:APPS, object_type:PACKAGE, object_name:XNP_UTILS, status:VALID,
PACKAGE: APPS.XNP_UTILS 12.2.2
owner:APPS, object_type:PACKAGE, object_name:XNP_UTILS, status:VALID,
PACKAGE: APPS.XDP_ADAPTER_CORE_DB 12.1.1
owner:APPS, object_type:PACKAGE, object_name:XDP_ADAPTER_CORE_DB, status:VALID,
PACKAGE BODY: APPS.XDP_ORDER_SYNC 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:XDP_ORDER_SYNC, status:VALID,
PACKAGE BODY: APPS.XNP_WF_STANDARD 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:XNP_WF_STANDARD, status:VALID,
PACKAGE BODY: APPS.XNP_WF_STANDARD 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:XNP_WF_STANDARD, status:VALID,
PACKAGE: APPS.XDP_ADAPTER_CORE_DB 12.2.2
owner:APPS, object_type:PACKAGE, object_name:XDP_ADAPTER_CORE_DB, status:VALID,
PACKAGE BODY: APPS.XDP_ORDER_SYNC 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:XDP_ORDER_SYNC, status:VALID,
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
PACKAGE BODY: APPS.XNP_UTILS 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:XNP_UTILS, status:VALID,
PACKAGE BODY: APPS.XNP_UTILS 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:XNP_UTILS, status:VALID,
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
PACKAGE: APPS.XDP_ENGINE 12.1.1
owner:APPS, object_type:PACKAGE, object_name:XDP_ENGINE, status:VALID,
PACKAGE: APPS.XDP_ENGINE 12.2.2
owner:APPS, object_type:PACKAGE, object_name:XDP_ENGINE, status:VALID,
PACKAGE: APPS.XNP_EVENT 12.2.2
owner:APPS, object_type:PACKAGE, object_name:XNP_EVENT, status:VALID,
PACKAGE: APPS.XNP_EVENT 12.1.1
owner:APPS, object_type:PACKAGE, object_name:XNP_EVENT, status:VALID,
PACKAGE: APPS.XNP_ERRORS 12.1.1
owner:APPS, object_type:PACKAGE, object_name:XNP_ERRORS, status:VALID,
PACKAGE: APPS.XNP_ERRORS 12.2.2
owner:APPS, object_type:PACKAGE, object_name:XNP_ERRORS, status:VALID,
PACKAGE: APPS.XNP_MESSAGE 12.2.2
owner:APPS, object_type:PACKAGE, object_name:XNP_MESSAGE, status:VALID,
PACKAGE: APPS.XNP_MESSAGE 12.1.1
owner:APPS, object_type:PACKAGE, object_name:XNP_MESSAGE, status:VALID,
PACKAGE: APPS.XNP_STANDARD 12.1.1
PACKAGE: APPS.XNP_STANDARD 12.2.2
APPS.XNP_CONTROL_U dependencies on XNP_STANDARD 12.1.1
APPS.XDP_OM_UTIL dependencies on XNP_STANDARD 12.1.1
APPS.XNP_CONTROL_U dependencies on XNP_STANDARD 12.2.2
APPS.XNP_WF_STANDARD dependencies on XNP_STANDARD 12.1.1