Search Results get_level

Overview

ARP_PHON_PKG is a PL/SQL package body owned by the APPS schema in Oracle E-Business Oracle Receivables. Its responsibility is the maintenance of telephone information associated with the customer, address, and contact entities of the Receivables data model. The package encapsulates the low-level insert, update, delete, and locking operations against the phone records that back the Customer Standard and related customer-facing forms. It also contains a private helper that resolves the ownership level of a phone entry and a public helper that enforces the single-primary-telephone rule.

The header comment block identifies the source file as AROPHONB.pls, version 120.1, last amended 11-Aug-2005. The package is classified under ETRM as a generic OTHER API rather than a formal public interface, and it is not referenced by any other documented package. This indicates it is an internal implementation unit consumed directly by the Receivables forms layer rather than a documented extension point for third-party integration.

Key Procedures and Functions

• get_level (private) — Determines the level to which a given telephone record is attached, that is, whether the phone belongs to a customer, an address, or a contact. It accepts identifiers for customer, address, and contact and returns the resolved type and identifier through its OUT parameters. In the shipped source the body is a no-op stub (NULL), indicating that the level determination was either relocated or is performed elsewhere; callers should not rely on it returning a meaningful value.
• check_primary (public) — Enforces the business rule that a customer, address, or contact may hold only one telephone flagged as primary. It accepts the phone identifier, the owning entity type (CUST, ADDR, or CONT), and the owning entity identifier. As shipped, the body is also a stub, so enforcement is delegated to the forms or table-level logic.
• Insert_Row — Standard table-handler insert for a telephone record. It populates all WHO columns (creation and last-update audit fields, last-update login), the phone number, area code, extension, status, phone type, primary flag, the customer, address, and contact foreign keys, and the descriptive flexfield attribute columns. Rowid, phone identifier, and original system reference are passed by reference so the caller receives the generated values.
• Lock_Row — Standard table-handler lock, used to serialize concurrent modification of a phone row before an update or delete is attempted.
• Update_Row — Standard table-handler update that writes the mutable phone attributes and refreshes the WHO audit columns for an existing row.
• Delete_Row — Standard table-handler delete that removes a telephone record.

Tables Accessed

ETRM records no table references for this package through APPS synonyms, because the underlying SQL operates on the base AR_PHONES table directly within the Receivables schema. All access is confined to that single telephone entity; the package does not join to customer, address, or contact tables in the documented metadata.

Usage Notes

The package is invoked from the Oracle Receivables customer maintenance forms, which call the table-handler procedures to persist telephone changes and invoke check_primary to preserve the single-primary invariant. It is not a registered concurrent program and no scheduled job references it. Custom code in 12.1.1 or 12.2.2 may call the documented table handlers, but should avoid get_level and check_primary, whose shipped bodies are empty stubs and therefore perform no work.