Results for “get_party_tax_prof_info”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

ZX_TCM_PTP_PKG is an Oracle E-Business Tax (EB Tax / ETRM) package owned by the APPS schema. The package body implements the "Party Tax Profile" (PTP) and tax registration retrieval logic that underpins the Tax Configuration Manager (TCM) layer of Oracle E-Business Tax. Its primary business role is to resolve the correct party tax profile, headquarters or operating-unit registration, and tax subscriber information for a given party, place of supply, or location, and to keep the ZX_REGISTRATIONS registration records synchronized with the underlying party tax profile configuration. In effect it provides the pl底层 plumbing that allows EB Tax to determine which tax registrations apply to a transaction and which tax subscriber (legal entity or operating unit) owns them.

Key Procedures and Functions

• GET_PTP — Returns the party tax profile applicable to a specific party and configuration context (party type, party identifier or tax profile associations), forming the core lookup used by downstream tax determination calls.
• GET_PTP_HQ — Resolves the headquarters-level party tax profile, typically used when upstream logic needs the top-level (parent legal entity or registered party) profile rather than a location- or operating-unit-specific one.
• GET_TAX_SUBSCRIBER — Determines the tax subscriber associated with a profile or registration, i.e. the legal entity or operating unit that is the subscriber of record for tax purposes.
• GET_LOCATION_ID — Resolves the location identifier tied to a party tax profile or registration record so that geography-dependent tax logic can be applied.
• CHECK_TAX_REGISTRATIONS — Validates whether tax registration records exist and are consistent for a given party/profile combination, returning status usable by callers to decide whether synchronization or correction is required.
• SYNC_TAX_REGISTRATIONS — Writes or updates rows in the ZX_REGISTRATIONS registration tables (via the ZX_REGISTRATIONS_S sequence) so that registration data matches the current party tax profile configuration maintained in the XLE_* structures.
• GET_PARTY_TAX_PROF_INFO — Returns consolidated party tax profile attributes, used by other EB Tax packages that need profile-level detail without re-querying the base tables directly.

All procedures follow standard Oracle EBS API conventions, including FND_API return-status handling and FND_MESSAGE / FND_LOG instrumentation for diagnostics.

Tables Accessed

• ZX_REGISTRATIONS / ZX_REGISTRATIONS_S — The core tax registration table and its sequence; read for validation and written during synchronization.
• ZX_PARTY_TAX_PROFILE — Provides party-level tax profile attributes that drive registration resolution.
• XLE_ENTITY_PROFILES, XLE_ETB_PROFILES, XLE_TAX_ASSOCIATIONS — Supply legal entity, establishment/ETB, and tax association configuration needed to map a party to its registrations.
• HR_ALL_ORGANIZATION_UNITS — Resolves organization/operating-unit identity for tax subscriber determination.
• FND_LOG_MESSAGES — Written to via FND_LOG for debug and trace output.
• ZX_GLOBAL_STRUCTURES_PKG, FND_API, FND_GLOBAL, FND_MESSAGE — Supporting infrastructure packages rather than data tables.

Usage Notes

ZX_TCM_PTP_PKG is an internal EB Tax configuration package rather than an end-user-facing API, and it is not referenced by any other database object according to the ETRM dependency record, though it is documented as referenced by thirteen other package units within the EB Tax stack. It is typically invoked from Tax Configuration Manager setup flows, registration-related concurrent programs, and other EB Tax packages that need to resolve the party tax profile or keep registrations synchronized. Because it depends on XLE and ZX registration structures, it must be invoked in a context where FND_GLOBAL is initialized (session and application context set). The package is status VALID in the APPS schema and references only APPS-owned synonyms and standard SYS/PUBLIC utilities such as DBMS_UTILITY and PLITBLM.