Search Results pa_billing_amount




Overview
Explore in AI Chat

Overview

PA_BILLING_AMOUNT is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM object registry as an "OTHER" API. It forms part of the Project Billing module's calculation engine, providing the core amount-derivation logic used when Oracle Projects determines billable values on project contracts, agreements, and funding arrangements. The package encapsulates the arithmetic and lookup rules that convert raw project transactions — expenditures, events, and revenue distributions — into the monetary figures consumed by the billing generation process.

Rather than exposing a single entry point, the package serves as a library of computation routines invoked by higher-level billing programs. Its dependent objects confirm this role: PA_BILLING, PA_BILLING_PUB, PA_BILL_PCT, and PA_BILLING_AMOUNT itself (internal recursive calls) all reference it. The package is reported as VALID in ETRM, and its only external dependency at the schema level is SYS.STANDARD, indicating that all application-level dependencies are resolved through APPS synonyms rather than direct schema references.

Key Procedures and Functions

ETRM documents seven procedures and functions within the package. Their names indicate the amount categories they compute:

  • COSTAMOUNT — Derives the cost-based amount associated with billing, typically aggregating expenditure items for use as the basis of a bill line or funding limit check.
  • REVENUEAMOUNT — Calculates revenue-related amounts, drawn from revenue distribution data, for comparison against or inclusion in billing calculations.
  • POTEVENTAMOUNT — Computes the potential (unbilled or not-yet-invoiced) event amount, supporting event-based billing where billable milestones generate invoice lines.
  • INVOICEAMOUNT — Returns the amount already invoiced, allowing callers to determine remaining billable value.
  • LOWESTAMOUNTLEFT — Identifies the smallest remaining billable amount across the candidate basis, a common requirement when a funding limit or contract ceiling restricts the amount that may still be billed.
  • RDL_AMOUNT — Computes an amount from revenue distribution lines (RDL), the revenue counterpart used in billing-to-revenue reconciliation logic.
  • GET_BASELINE_BUDGET — Retrieves the baseline budget amount for a project or task, supporting budget-versus-actual comparisons that feed billing limits or percentage-complete calculations.

Parameter lists are not exposed in the ETRM extract; callers should obtain signatures from the package specification in the APPS schema.

Tables Accessed

The package reads from and writes to fifteen documented PA tables through APPS synonyms, spanning the billing, revenue, costing, and budgeting sub-models:

Usage Notes

PA_BILLING_AMOUNT is not intended for direct end-user invocation. It is called programmatically by Oracle Projects billing forms, by concurrent programs that generate draft invoices and revenue, and by the public billing APIs. The three packages documented as referencing it — PA_BILLING, PA_BILLING_PUB, and PA_BILL_PCT — perform the orchestration, validation, and persistence work around these amount computations. Custom extensions should follow the same pattern: call the documented routines for amount derivation rather than reimplementing billing arithmetic, since funding-limit, ceiling, and agreement logic is centralized here. Because the package is maintained by Oracle and its specification may change between releases, custom code should avoid depending on undocumented elements and should be regression-tested across EBS 12.1.1 and 12.2.2 upgrades.