Search Results served_number_ranges

Overview

XNP_CVU_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM repository as an "OTHER" API. The prefix XNP identifies it as part of the Oracle Telecommunications Service Fulfillment / Provisioning application family in EBS. The "CVU" mnemonic is commonly associated with Custom Validation Utility logic within the XNP module. Functionally, the package serves as a validation and data-generation utility layer that supports the configuration of service fulfillment elements, geographic service coverage, service providers, adapter types, and fulfillment actions. It provides reusable procedures and functions that validate user-entered or imported setup data and populate supporting lookup and reporting structures.

The package operates in the Oracle EBS 12.1.1 and 12.2.2 releases and is registered as VALID in the APPS schema, confirming that it compiles and is current. Its dependency footprint is deliberately narrow at the schema level, referencing only SYS and the STANDARD package, which indicates that the package does not depend on other APPS-level PL/SQL packages and can therefore be invoked safely by forms, concurrent programs, or custom code without creating circular dependencies.

Key Procedures and Functions

ETRM documents thirty-four procedures and functions within XNP_CVU_PKG. The main verification and setup routines include:

• INITIAL_STATUS_OF_SV — establishes or derives the initial status of a service (SV) record during fulfillment processing.
• SINGLE_GEO_TREE — resolves or validates a single geographic hierarchy tree used for service coverage modeling.
• FULFILL_ACTIONS, FULFILL_ELEMENT_VALIDITY, FULFILL_ELEMENT_REFERENCES — validate fulfillment actions and verify that fulfillment elements are correctly defined and referenced before provisioning.
• NEW_ADAPTER_TYPES, SERVICE_PROVIDERS — support validation and registration of adapter types and service provider definitions.
• NUM_RANGE_GEO_AREA, INVALID_NUMBER_RANGES, POOLED_NUMBER_RANGES, NON_PORTED_PORTABLE_NUM_RANGES, SERVED_NUMBER_RANGES — a family of number-range validation routines that check geographic area assignments, detect invalid ranges, and classify pooled, ported/portable, and served telephone number ranges.
• PHASE_IND_NO_STAT_TYPE — determines phase indicator and number status type information used in number administration.
• GETGEOCODE, GETFENAME, GETMSGTXT — retrieval functions for geocodes, feature names, and message text (typically sourced from FND_NEW_MESSAGES).
• PRINT, PRINTREPORTDETAILS — output routines that render validation results or report detail lines.
• HANDLEERROR, LOCAL_SP_NAME — centralized error handling and resolution of the local stored procedure name for diagnostic messages.

Tables Accessed

The package reads and writes through APPS synonyms, including: FND_LOOKUP_VALUES (validation of lookup codes and meanings), FND_NEW_MESSAGES (message text retrieval), XDP_FE_TYPES, XDP_FES, XDP_FE_GENERIC_CONFIG, and XDP_FE_SW_GEN_LOOKUP (fulfillment element type and configuration validation); XDP_ADAPTER_REG and XDP_FULFILL_ACTIONS (adapter and fulfillment action definitions); XDP_FA_FULFILLMENT_PROC and XDP_PROC_BODY (fulfillment processing logic); and the Oracle Workflow tables WF_ACTIVITIES, WF_ACTIVITY_ATTR_VALUES, WF_ACTIVITY_TRANSITIONS, WF_ITEM_ATTRIBUTES, and WF_PROCESS_ACTIVITIES, which are consulted to validate workflow activity and process definitions associated with fulfillment.

Usage Notes

XNP_CVU_PKG is invoked from XNP setup forms during entry and validation of service fulfillment configuration, from concurrent programs that validate number ranges and geographic coverage data, and from custom code requiring the same validations. Because no other APPS packages reference it, it functions as a leaf utility; Oracle support notes it should be called through its published procedures rather than modified. In 12.2.2 it remains valid without editioning or dependency issues.