Search Results get_legalentityname_pid
Overview
XLE_UTILITIES_GRP is the central utility package within the Oracle E-Business Suite Legal Entity Configurator (XLE) module. It provides a consolidated library of group-type (GRP) application programming interfaces that resolve legal entity, establishment, registration, and party information for other EBS products and custom code. Rather than forcing each calling module to reconstruct complex joins across Human Resources, Trading Community Architecture (TCA), and Legal Entity tables, XLE_UTILITIES_GRP exposes a stable set of PL/SQL functions and procedures that return that information consistently. The package is owned by APPS and is referenced by 34 other packages, confirming its role as a foundational dependency in the Legal Entity infrastructure of both 12.1.1 and 12.2.2.
Key Procedures and Functions
The package exposes 21 documented procedures and functions organized around several functional themes:
- Legal entity resolution: GET_LEGALENTITY_INFO, GET_LEGALENTITYID_OU, GET_LEGALENTITYNAME_PID, GET_LEGALENTITY_LGER_BSV, ISLEGALENTITY_LEID, and IS_INTERCOMPANY_LEID identify, validate, and classify legal entities by operating unit, party ID, ledger, or legal entity ID.
- Registration and tax data: GET_REGISTRATION_INFO, GET_REGISTERNUMBER_PID, GET_FP_VATREGISTRATION_LEID, and GET_FP_COUNTRYCODE_LID / GET_FP_COUNTRYCODE_OU retrieve registration numbers, VAT registrations, and first-party country codes for legal entities and operating units.
- Establishment and party classification: GET_ESTABLISHMENT_INFO, ISESTABLISHMENT_PID, ISTRANSENTITY_PID, GET_PARTYID_OU, and GET_ME_PARTYID_LEID determine whether a party is an establishment or transacting entity and return associated party identifiers.
- Legal context and stamping: GET_LE_INTERFACE, GET_DEFAULTLEGALCONTEXT_OU, GET_DLC_LE_OU, and GET_LEGALENTITYID_OU support the stamping of transactions with the correct legal entity and default legal context.
- History: GET_HISTORY_INFO returns audit history records from XLE_HISTORIES.
The package additionally declares strongly typed PL/SQL record and table structures (RegNum_Rec, PartyClass_Rec, CountryCode_Rec, LegalEntity_tbl_type, History_Rec, and their associated collection types) that callers use to receive multi-row results.
Tables Accessed
The package reads and writes a broad set of APPS-synonym tables. Legal entity and establishment data comes from XLE_ENTITY_PROFILES and XLE_ETB_PROFILES, with associations resolved through XLE_ASSOCIATIONS. Registration information is drawn from XLE_REGISTRATIONS and ZX_REGISTRATIONS. Audit history is retrieved from XLE_HISTORIES. Party and organizational data is obtained from HR_ALL_ORGANIZATION_UNITS, HR_ORGANIZATION_INFORMATION, HR_LOCATIONS_ALL, HZ_PARTIES, HZ_PARTY_SITES, HZ_LOCATIONS, HZ_CLASS_CATEGORIES, and HZ_GEOGRAPHIES. Ledger–legal entity relationships are resolved through GL_LEDGER_LE_BSV_GT.
Usage Notes
XLE_UTILITIES_GRP is intended for programmatic use rather than direct end-user invocation. It is typically called from other PL/SQL packages, from Legal Entity Configurator forms, and from custom extensions that need to stamp transactions with legal entity context or validate party classifications. The GET_LE_INTERFACE function in particular is commonly used when integrating external or subledger data with the Legal Entity model. Because the package is referenced by 34 other packages, changes to its signatures can have wide-reaching impact, and callers should rely on the documented interfaces rather than on internal implementation details. In 12.1.1 and 12.2.2 the package remains backward compatible, and custom code should always pass the required API version and initialization parameters when invoking the public procedures.