Search Results get_establishment_info

Overview

XLE_UTILITIES_GRP is a utility package body in the APPS schema that supports the Oracle E-Business Tax (E-Business Tax / ETRM) infrastructure, specifically the Legal Entity and First Party registration data model introduced in Release 12. The "GRP" suffix identifies it as a grouping package, i.e. a procedural container that bundles related helper routines rather than exposing a single functional API. Its role is to centralize frequently required lookups and derivations against legal entities, establishments, registrations, operating units, ledgers and first-party (first party) tax profiles, so that other E-Business Tax and Financials products can retrieve consistent answers without duplicating SQL against the underlying XLE, ZX, HR and HZ tables. Because these are commonly reused derivations (for example, resolving the legal entity behind an operating unit, or determining whether a party identifier represents an establishment), the package is referenced by 34 other packages and is not itself dependent on exotic callers, making it a low-level shared utility. The package body is currently VALID, has no invalid subobjects and is not referenced by any database object (only by PL/SQL packages).

Key Procedures and Functions

The documented interface exposes 21 procedures and functions. They fall into recognizable groups:

• Registration and establishment information — GET_REGISTRATION_INFO, GET_ESTABLISHMENT_INFO, GET_REGISTERNUMBER_PID and GET_FP_VATREGISTRATION_LEID return registration attributes, registration numbers and VAT registration details for a first party, legal entity or party identifier. ISESTABLISHMENT_PID tests whether a given party identifier is an establishment.
• Legal entity information — GET_LEGALENTITY_INFO, GET_LEGALENTITYID_OU, GET_LEGALENTITYNAME_PID, ISLEGALENTITY_LEID and GET_LE_INTERFACE resolve legal entity identity, legal entity identifiers and names. IS_INTERCOMPANY_LEID and GET_ME_PARTYID_LEID support intercompany and multi-entity (ME) determinations.
• First-party and country context — GET_FP_COUNTRYCODE_LID and GET_FP_COUNTRYCODE_OU return the first-party country code by ledger or operating unit; GET_LEGALENTITY_LGER_BSV and GET_LEGALENTITYNAME_PID supply legal entity context keyed by ledger or party.
• Operating unit, ledger and default context — GET_DEFAULTLEGALCONTEXT_OU and GET_DLC_LE_OU return the default legal context for an operating unit or legal entity; GET_PARTYID_OU returns the party identifier associated with an operating unit; GET_LEGALENTITY_LGER_BSV provides the legal entity for a ledger Balancing Segment Value.
• History and transaction entity checks — GET_HISTORY_INFO retrieves historical (date-effective) attribute changes, while ISTRANSENTITY_PID identifies whether a party is a transaction entity.

Because each routine is a small, independently callable helper, callers select only the accessor they need rather than invoking a monolithic API. The package therefore does not raise standard FND_API exception stacks universally; several routines rely on FND_MSG_PUB for messages and FND_API for standard API conventions when a diagnostic is required.

Tables Accessed

The package reads and maintains data across the E-Business Tax and Trading Community foundations:

• XLE tables — XLE_ENTITY_PROFILES, XLE_ETB_PROFILES, XLE_REGISTRATIONS, XLE_HISTORIES, XLE_ASSOCIATIONS, XLE_ASSOCIATION_TYPES, XLE_JURISDICTIONS_B/VL, XLE_LOOKUPS, XLE_REG_FUNCTIONS and XLE_FIRSTPARTY_INFORMATION_V form the core legal entity / establishment / registration model.
• ZX tables — ZX_REGISTRATIONS holds tax registrations used via ZX_API_PUB; these are the tax determining registrations tied to first parties.
• HR tables — HR_OPERATING_UNITS, HR_ALL_ORGANIZATION_UNITS, HR_ORGANIZATION_INFORMATION and HR_LOCATIONS_ALL provide the operating unit and organization hierarchy used to resolve OU-to-legal-entity relationships.
• Trading Community (HZ) tables — HZ_PARTIES, HZ_PARTY_SITES, HZ_LOCATIONS, HZ_GEOGRAPHIES and HZ_CLASS_CATEGORIES supply party and location attributes needed for first-party and establishment determinations.
• Ledger and BSV tables — GL_LEDGER_LE_BSV_GT and GL_LEDGER_LE_BSV_SPECIFIC_V map ledgers to legal entities and balancing segment values, used by GET_LEGALENTITY_LGER_BSV and related LEDGER-keyed routines.
• Other — GL_MC_INFO supports multi-company / multi-org context.

Reads dominate; where writes occur they are typically limited to history/association maintenance supporting legal entity profile changes rather than transactional data.

Usage Notes

XLE_UTILITIES_GRP is a server-side utility intended for invocation from other PL/SQL packages, forms and concurrent programs. Typical callers include E-Business Tax registration and configuration flows, Legal Entity configuration (Legal Entity Configurator), and any Financials process that must determine the legal entity or first party behind an operating unit, ledger or party identifier. Because it is referenced by 34 packages but does not itself reference other application packages for its core derivations, custom code should call it rather than re-implement the same lookups, ensuring consistent results with the seeded E-Business Tax logic. The package is documented as valid in 12.1.1 and 12.2.2; behaviour is understood to be stable across those releases, and any code that reads XLE tables directly should be redirected through these accessors to insulate against underlying view or table changes. Custom callers should expect the routines to consume standard operating unit, party and ledger identifiers as inputs and to rely on documented XLE/ZX views for the returned values.