Search Results update_association

Overview

The APPS.XLE_ASSOCIATIONS_PUB package body provides the public API layer for creating and maintaining legal associations within the Oracle E-Business Suite legal entity architecture. Legal associations define the relationships between subjects (such as legal entities) and objects within the ETRM (Enterprise Tax, Regulatory, and Finance Management) model, and they form a foundational data structure for legal entity configuration, tax registration, and jurisdictional setup. The package is classified as a PUB (public) API package in release 12.2.2, indicating that it is intended to be called by external consumers rather than being restricted to internal, private use. Its header dates to 2005 and was authored during the initial development of the legal entity model that was introduced across the 12.x product family, remaining a stable interface on both 12.1.1 and 12.2.2.

Key Procedures and Functions

The package body documents two public procedures, both centered on maintaining the legal associations data model:

• CREATE_ASSOCIATION — Creates a legal association record. The procedure accepts standard PL/SQL API parameters for message list initialization (p_init_msg_list), transaction control (p_commit), and the standard return status/message out parameters (x_return_status, x_msg_count, x_msg_data). It also receives the association definition itself: a context, a subject type and subject identifier, an object type and object identifier, an effective-from date, and a flexible set of descriptive association attributes (p_assoc_information_context together with up to twenty p_assoc_information1..20 values). On success it returns the generated x_association_id. This is the primary entry point for establishing a new relationship between a legal subject and object.
• UPDATE_ASSOCIATION — Updates an existing legal association. This is the procedure most relevant to the user's search term update_association. It allows the calling application to modify the descriptive and flexible-field attributes of a previously created association, and typically to adjust the effective dating of the relationship. As with the create procedure, it follows the standard Oracle EBS API conventions for message handling, commit control, and return status reporting.

Tables Accessed

The documented metadata does not enumerate specific base tables accessed via APPS synonyms. Functionally, the package operates against the underlying legal association schema owned by the legal entity model, inserting and updating association records and their associated flexible-field attribute values. Because the API exposes a generic subject/object pattern, the same procedures can be used across multiple association types without requiring type-specific tables. Callers should treat the physical table layer as an implementation detail and interact with it exclusively through this API.

Usage Notes

The package is intended to be invoked from PL/SQL rather than from a dedicated concurrent program or form. It follows the standard Oracle EBS API contract: callers should initialize the message list, invoke the procedure with p_commit set according to their transaction strategy, then inspect x_return_status and drain messages via FND_MSG_PUB before proceeding. Custom code, integrations, and extensions that need to establish or amend legal associations should call XLE_ASSOCIATIONS_PUB rather than performing direct DML, preserving the integrity and validation logic enforced by the API. The metadata records no other packages referencing this one, so it is a top-level public interface consumed directly by external or custom callers, and the same entry points are available and consistent in both 12.1.1 and 12.2.2.