Search Results end_contact_roles

Overview

The APPS.XLE_CONTACT_GRP package body is a component of Oracle E-Business Suite's ETRM (Enterprise Tax and Reporting Module) legal entity layer, delivered in the APPS schema across both 12.1.1 and 12.2.2. Its classification as a GRP (group) package indicates that it functions as a coordinating utility rather than a standalone business API. Its documented role is to consolidate, concatenate, and resolve the legal-role assignments associated with contacts registered in ETRM. In the ETRM data model, legal entities and their associated contacts carry one or more legal roles — such as authorized representative, tax contact, or filing signatory — and these roles frequently must be presented as a single concatenated string for downstream tax registration, reporting, and legal-document generation. XLE_CONTACT_GRP encapsulates that aggregation logic, insulating callers from the underlying role table and from lookup-based role descriptions. The package is marked VALID in the ETRM registry and is documented with two public program units, giving it a narrow, well-scoped surface area within the ETRM stack.

Key Procedures and Functions

• CONCAT_CONTACT_ROLES — The primary aggregation routine. It assembles the set of legal roles held by one or more ETRM contacts into a consolidated representation, drawing role definitions from the ETRM lookup infrastructure and the contact legal-role assignments. It is the entry point used when a calling program requires a single readable role string rather than individual role rows.
• END_CONTACT_ROLES — The companion cleanup/finalization routine. It concludes processing of the contact-role assembly, releasing the working structures established by CONCAT_CONTACT_ROLES and completing the group-level operation. Its position in the package body indicates lifecycle control around the concatenation activity rather than independent business logic.

The two units are designed to be invoked in sequence: initiate the contact-role assembly, then signal its completion. No parameter lists are documented in the ETRM metadata, and none are asserted here.

Tables Accessed

• XLE_CONTACT_LEGAL_ROLES — The core ETRM table holding the relationship between contacts and their assigned legal roles. XLE_CONTACT_GRP reads this table to determine which roles are associated with a given contact or legal entity before concatenation.
• XLE_LOOKUPS — Supplies the looked-up role codes and their translated meanings, allowing concatenated output to be rendered in user-facing terminology consistent with ETRM lookup configuration.
• PLITBLM — The PL/SQL table/BLOB utility package referenced in the dependency list, typically used for temporary or buffer storage of aggregated values during string assembly.

Additional dependencies documented by ETRM include FND_API and FND_MSG_PUB, indicating adherence to the standard Oracle Applications error-handling and message-stack conventions, so that failures during role assembly are surfaced through the standard FND message framework.

Usage Notes

XLE_CONTACT_GRP is referenced by three other packages in the ETRM schema and is not referenced by any database object, confirming it as an internal ETRM utility rather than a hooked database trigger target. It is typically invoked from ETRM legal-entity and contact maintenance flows — including OAF-based setup pages and concurrent reporting programs — where a consolidated legal-role string is required for tax registration output, legal document headers, or reporting extracts. Custom extensions integrating with ETRM contact data should call the documented routines rather than querying XLE_CONTACT_LEGAL_ROLES directly, since the package centralizes role resolution and lookup translation. As with all APPS-schema ETRM packages, no direct grants should be issued to custom schemas; access is via APPS synonyms and standard FND security.