Results for “pa_output_tax”

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

Overview

The APPS.PA_OUTPUT_TAX package body supports Oracle Projects billing by deriving and applying output tax (indirect tax) information during the project invoice generation and transfer cycle. Its principal business role is to determine the correct tax classification, exemptions, and default tax information for project-related customer transactions before those transactions are passed to Oracle Receivables and the E-Business Tax (ZX) engine. The package operates at the intersection of Oracle Projects (PA) and Oracle Receivables (AR), resolving customer, site, and project agreement context so that taxes are computed on draft invoices and their distribution lines.

The package is classified as OTHER (not a public open interface), status VALID, owned by APPS. It is documented with eight procedures/functions and is referenced by nine other database objects, while itself referring to no external database object (it is a leaf dependency in the reverse graph). Its dependencies include both PA and non-PA schemas, reflecting its cross-module tax integration role.

Key Procedures and Functions

• GET_DEFAULT_TAX_INFO — Retrieves the default tax information applicable to a given project billing context, used to seed tax attributes on draft invoice lines.
• GET_DEFAULT_TAX_INFO_ARR — The array/bulk counterpart of the above, returning default tax information for multiple lines in a single call, supporting set-based processing.
• MARK_CUST_REV_DIST_LINES — Marks customer revenue distribution lines with the correct tax indicators, ensuring downstream tax calculation and reporting identify the taxable lines.
• IS_AR_INSTALLED — Determines whether Oracle Receivables is installed, allowing the package to conditionally execute AR-dependent logic.
• GET_DRAFT_INVOICE_TAX_AMT — Returns the tax amount associated with a project draft invoice.
• TAXID_2_CODE_CONV — Converts a tax identifier into its corresponding tax code, bridging internal ID references and ZX code values.
• GET_BTCH_SRC_TRANS_TYPE — Retrieves the batch source transaction type used when creating or transferring invoice transactions.
• GET_MEANING — Returns the descriptive meaning for a given lookup code, used for tax classification and reporting values.

Tables Accessed

The package reads and writes against several core EBS tables via APPS synonyms. Within Oracle Projects, it accesses PA_DRAFT_INVOICES, PA_CUST_REV_DIST_LINES_ALL, PA_EXPENDITURE_ITEMS_ALL, PA_AGREEMENTS_ALL, PA_IMPLEMENTATIONS, PA_PROJECTS, PA_PROJECTS_ALL, and PA_PROJECT_CUSTOMERS to establish the billing context and taxable amounts. It references Oracle Receivables tables AR_SYSTEM_PARAMETERS and RA_CUSTOMER_TRX_LINES to read tax and billing parameters and to align project invoice data with receivables transactions. Customer data is sourced from HZ_CUST_ACCOUNTS and HZ_CUST_ACCT_SITES for the tax-relevant party and location. E-Business Tax configuration is drawn from ZX_ID_TCC_MAPPING_ALL and related ZX objects, and FND_LANGUAGES and PLITBLM support multilingual and bulk collection handling.

Usage Notes

PA_OUTPUT_TAX is invoked during project billing and invoice transfer processing rather than directly by end users. It is called from within PA billing and multi-currency billing logic (as evidenced by dependencies such as PA_BILLING, PA_MULTI_CURRENCY_BILLING, PA_MCB_INVOICE_PKG, and PA_INVOICE_XFER) and from the tax client extension driver PA_TAX_CLIENT_EXTN_DRV. Because it is referenced by nine objects and references none, it should be treated as an internal utility that customers modify with caution; customization is generally performed through its supported extension hooks rather than by altering the package itself. When Oracle Receivables is not installed, the IS_AR_INSTALLED check prevents AR-dependent code paths from executing. All invocations require valid APPS credentials and standard EBS security context.