Search Results check_unique_orig_system_ref

Overview

ARP_CONT_PKG is a PL/SQL package in the APPS schema that supports the Oracle Receivables customer contact entity, which corresponds to the HZ_CONTACTS / RA_CONTACTS data model used by Oracle EBS 12.1.1 and 12.2.2. The package encapsulates the DML and validation logic that the Receivables customer and contact maintenance forms invoke when creating, changing, or locking a contact record, and it exposes a single paired validation routine for the unique original system reference. Its design follows the standard EBS "table handler" pattern: a thin API layer that performs row-level inserts, updates, and locks against the underlying contact table while delegating validation to dedicated check procedures that post messages onto the Forms or PL/SQL message stack via FND_MESSAGE and return a warning or failure indicator to the caller.

This document describes the package body source file AROCONTB.pls, whose header version string indicates the last shipped revision was 120.1, dated August 2005. In the 12.2.2 ETRM metadata the package is classified as OTHER rather than as a public, fully supported API.

Key Procedures and Functions

• CHECK_UNIQUE_CONTACT_NAME — Verifies that a contact name is unique for a given customer before the record is saved. When the name is not unique the procedure posts a message on the stack and returns a warning flag so the caller can continue, subject to user confirmation. As shipped, the body of this procedure contains only a NULL statement.
• CHECK_UNIQUE_ORIG_SYSTEM_REF — The procedure matching the user's search term. It checks that ORIG_SYSTEM_REFERENCE is unique, and if it is not, it sets a message on the stack and signals failure to the caller. The signature exposes only x_rowid and x_orig_system_reference, so uniqueness is evaluated without a customer filter. The shipped body likewise contains only a NULL statement, meaning the routine is a stub.
• INSERT_ROW — Inserts a new contact row, accepting the full set of contact attributes including contact ID, customer ID, first and last name, job title, status, address ID, contact key, original system reference, and audit columns. The contact ID and rowid are returned to the caller as IN OUT NOCOPY parameters.
• UPDATE_ROW — Updates an existing contact row identified by rowid, applying the supplied attributes and audit columns and refreshing the orig_system_reference value.
• LOCK_ROW — Acquires a row-level lock on a contact record identified by rowid, used by the form to serialize concurrent edits before an update.

Tables Accessed

The documented metadata does not enumerate specific tables referenced through APPS synonyms. Based on the procedure semantics and the ARP_CONT_PKG naming, the package operates against the Receivables contact table exposed as RA_CONTACTS (and, in the later multi-org data model, the corresponding HZ contact tables) plus its associated contact-role and contact-point children where applicable, along with standard audit columns. Validation procedures such as CHECK_UNIQUE_ORIG_SYSTEM_REF read the same contact table to test for a pre-existing ORIG_SYSTEM_REFERENCE value. No other package in the ETRM inventory references ARP_CONT_PKG, confirming it is an internal form-support package rather than a shared API.

Usage Notes

ARP_CONT_PKG is invoked indirectly from the Oracle Receivables customer and contact maintenance forms, which call INSERT_ROW, UPDATE_ROW, and LOCK_ROW during commit and navigation processing, and call the check_unique_* procedures during field validation. It is not intended for direct invocation by concurrent programs or external integration. Custom code that calls it must account for the fact that the validation procedures are empty in the shipped version and therefore emit neither a message nor a failure indicator; meaningful uniqueness enforcement must be implemented in custom logic or handled by database constraints. Because the package is not classified as a supported public API in 12.2.2, any custom dependency on its signature should be treated as risky across upgrades of the AROCONTB.pls source.