Search Results arp_phon_pkg

Overview

ARP_PHON_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. Its name follows the AR (Accounts Receivable) module prefix convention and the "PHON" token strongly indicates it manages phone or contact telephone information associated with Receivables entities, principally customers and customer contacts held in the HZ (Trading Community Architecture) and AR tables. Within the ETRM metadata the package is classified as an API of type OTHER, meaning it is not one of the published, externally-supported Receivables APIs but is nevertheless a structured, callable program unit that supports insert, update, delete and locking operations against phone records. The package exists in a VALID state in the APPS schema and is composed of a package specification and a package body.

Key Procedures and Functions

The documented interface exposes five procedures, each reflecting a standard row-level data-manipulation pattern used throughout EBS foundation packages:

• CHECK_PRIMARY — likely verifies or enforces the primary-phone designation for a contact or customer, ensuring only one record carries the primary flag.
• INSERT_ROW — creates a new phone record, populating the underlying table with the supplied telephone attributes.
• LOCK_ROW — obtains a row-level lock on an existing phone record, used to serialize concurrent updates within a form or batch transaction.
• UPDATE_ROW — modifies an existing phone record, typically following a LOCK_ROW call within the same transaction.
• DELETE_ROW — removes a phone record, subject to the package's internal validation rules.

These procedures are not independently documented with parameter lists in the ETRM metadata; consumers should derive signatures from the package specification on the target instance rather than assuming argument order.

Tables Accessed

The ETRM extract lists no tables accessed through APPS synonyms, which indicates the dependency listing was truncated or that the package operates through private or fully qualified references. Based on the package's purpose in the Receivables and Trading Community model, it would ordinarily read and write the phone-number tables used by Oracle Receivables customer and contact maintenance, including the phone entity stored under the HZ party/contact schema and any AR-specific denormalized phone columns. Because no table list is documented here, this section should be treated as inferred rather than confirmed against the shipped metadata.

Usage Notes

The package is referenced by zero other packages according to the ETRM dependency data, which suggests it is invoked directly rather than through a broader API chain. The internal dependency reference of APPS.ARP_PHON_PKG upon itself reflects the standard specification-to-body relationship rather than a recursive call. In practice, packages of this shape are called from Oracle Forms-based maintenance screens (the Phone or Contact windows in Receivables), from concurrent programs that load or migrate telephone data, or from custom PL/SQL that needs to apply the same validation and primary-flag logic the standard forms use. Because it is classified as OTHER rather than a public API, direct invocation from custom code carries upgrade and support risk; the recommended approach is to use supported Trading Community or Receivables public APIs where an equivalent exists, and to treat ARP_PHON_PKG as an internal implementation detail of the module.