Search Results get_tax_description
Overview
AR_BPA_UTILS_PKG is a utility package in the Oracle E-Business Suite Receivables (AR) module, owned by the APPS schema and validated in both EBS 12.1.1 and 12.2.2. The package supports Oracle Bill Presentment Architecture (BPA), the framework that renders billing and transaction documents for external presentation to customers. BPA relies on configurable templates composed of content areas, items, and layout definitions; the utility package provides the shared programmatic services that these templates and their generating programs call upon to resolve transactional, customer, and tax-related data at runtime.
The package is classified as OTHER in the ETRM metadata, indicating that it is not a published public API but an internal support layer consumed by BPA components. Its 23 documented functions and procedures cover three functional clusters: extraction of header and line level values from customer transactions, resolution of tax attributes (rates, names, codes, and printing options), and retrieval of customer contact details such as name, phone, and fax. It also includes utility logic for duplicating content areas and managing flexfield items used by the BPA administrative configuration screens.
Key Procedures and Functions
The documented callable units fall into several groups:
- Transaction-level accessors: FN_GET_HEADER_LEVEL_SO and FN_GET_HEADER_LEVEL_CO return header-level sales order and customer order references; FN_GET_BILLING_LINE_LEVEL returns billing-level line attributes; FN_TRX_HAS_GROUPS indicates whether a transaction contains grouped lines.
- Tax resolution functions: FN_GET_LINE_TAXRATE, FN_GET_LINE_TAXNAME, and FN_GET_LINE_TAXCODE return tax attributes at the transaction line level, while FN_GET_GROUP_TAXRATE, FN_GET_GROUP_TAXNAME, FN_GET_GROUP_TAXCODE, and FN_GET_GROUP_TAXYN return the equivalent values for grouped lines and indicate whether tax applies to the group. FN_GET_TAX_PRINTING_OPTION resolves the configured tax printing setting, and GET_TAX_DESCRIPTION returns the descriptive text for a tax.
- Descriptive and contact accessors: FN_GET_LINE_DESCRIPTION returns line narrative text; FN_GET_CONTACT_NAME, FN_GET_PHONE, and FN_GET_FAX return customer contact information.
- Configuration utilities: FN_GET_PROFILE_CLASS_NAME returns a customer profile class name; CREATE_DUP_AREAS duplicates BPA content areas; DELETE_FLEXFIELD_ITEMS removes flexfield-based items from BPA definitions.
Tables Accessed
The package reads and writes through APPS synonyms across two domains. The BPA configuration repository comprises AR_BPA_AREA_ITEMS, AR_BPA_AREA_ITEMS_S, AR_BPA_CONTENT_AREAS_B, AR_BPA_CONTENT_AREAS_S, AR_BPA_CONTENT_AREAS_TL, AR_BPA_ITEMS_B, AR_BPA_ITEMS_S, and AR_BPA_ITEMS_TL — the base, translation, and sequence tables that define content areas and items. CREATE_DUP_AREAS and DELETE_FLEXFIELD_ITEMS operate directly against these. Receivables setup tables include AR_SYSTEM_PARAMETERS (for profile-level defaults such as tax printing). Customer data is sourced from the TCA model via HZ_PARTIES, HZ_CUST_ACCOUNT_ROLES, HZ_CONTACT_POINTS, HZ_CUSTOMER_PROFILES, HZ_CUST_PROFILE_CLASSES, and HZ_RELATIONSHIPS, supporting the contact name, phone, fax, and profile class functions.
Usage Notes
AR_BPA_UTILS_PKG is referenced by ARBPA_CUSTOMER_TRX_HEADER, ARBPA_CUSTOMER_TRX_LINE, and AR_BPA_SHUTTLE_PKG, and is itself referenced by three other packages. This confirms that it is invoked indirectly whenever BPA renders a billing document: the shuttle and transaction view packages call these utilities to populate template fields with resolved values. It also logs diagnostic information through FND_LOG. Customizations should treat it as an internal BPA utility layer rather than a stable public interface; direct calls are appropriate only within BPA-related extensions, and any logic should be validated against both 12.1.1 and 12.2.2 since the metadata is identical across releases.