Search Results get_commit_this_invoice




Overview
Explore in AI Chat

Overview

APPS.AR_INVOICE_SQL_FUNC_PUB is a public PL/SQL package in the Oracle E-Business Suite Receivables (AR) module, defined with AUTHID CURRENT_USER. It provides a set of SQL-based helper functions used primarily in the context of invoice and commitment reporting and processing. The package header header comment ($Header: ARTPSQS.pls 115.6 99/10/11) indicates that it originated as a support library associated with the RAXINV.rdf invoice report, consolidating reusable query logic that would otherwise be duplicated as report-local functions. It is classified as a PUB (public) API in the ETRM registry for both 12.1.1 and 12.2.2, and is referenced by eight other packages, which confirms its role as a shared utility for invoice, tax, and commitment data retrieval.

Key Procedures and Functions

The package exposes ten documented functions. Their purposes are as follows.

  • GET_DESCRIPTION — Returns a description for a given customer transaction line. The header notes the implementation populates multi-lingual (MLS) lexicals.
  • GET_INV_TAX_CODE_NAME — Returns the invoice tax code name, taking bill-to site, bill-to customer, tax printing option, printed tax name, and tax code as inputs to resolve the correct display value.
  • GET_COM_TOTAL_ACTIVITY — Returns the commitment total activity for a customer transaction, simulating the local "commitments" function previously embedded in the RAXINV.rdf report.
  • GET_COM_AMT_UNINVOICED — Returns the commitment amount that has not yet been invoiced.
  • GET_COM_BALANCE — Returns the remaining commitment balance.
  • GET_COMMIT_THIS_INVOICE — Returns the commitment amount attributable to the current invoice.
  • UPDATE_CUSTOMER_TRX — Performs updates against the customer transaction record.
  • GET_TAXYN — Returns a tax indicator (Y/N) value.
  • GET_REMIT_TO_GIVEN_BILL_TO — Resolves a remit-to address for a supplied bill-to.
  • GET_REMIT_ADDRESS_ID — Returns the remit-to address identifier.

Tables Accessed

The package reads and writes through APPS synonyms. Transaction and line data are sourced from RA_CUSTOMER_TRX and RA_CUSTOMER_TRX_LINES, with transaction types resolved via RA_CUST_TRX_TYPES. Receivables adjustments and payment schedules are accessed through AR_ADJUSTMENTS and AR_PAYMENT_SCHEDULES, supporting the commitment balance and activity calculations. Customer and site context is drawn from HZ_CUSTOMER_PROFILES, HZ_CUST_ACCT_SITES, HZ_CUST_SITE_USES, HZ_PARTY_SITES, and HZ_LOCATIONS. Remit-to data is retrieved from RA_REMIT_TOS. DUAL is used for scalar returns in the SQL function bodies.

Usage Notes

These functions are typically invoked from Oracle Reports (notably the invoice report family derived from RAXINV.rdf), from Receivables forms, and from custom PL/SQL that needs invoice tax or commitment values without duplicating query logic. Because the package is declared AUTHID CURRENT_USER, execution depends on the privileges of the calling schema, so grants and synonym access must be verified for custom integrations. For the specific search term get_com_total_activity, the function returns commitment total activity keyed by customer transaction and commitment parent identifiers; it is the direct SQL replacement for the legacy report-local commitment calculation.