Search Results calc_bill_amount




Overview
Explore in AI Chat

Overview

PA_CLIENT_EXTN_BILLING is a client extension package in Oracle Projects (Project Accounting). It is a stub or template package body shipped by Oracle to expose a supported customization point in the Project Accounting billing engine. The package allows customers and partners to override or extend how Oracle Projects derives bill amounts and bill rates for expenditure items, without modifying Oracle's seeded billing logic. The header comments confirm the package belongs to the standard Oracle Projects extension framework (source file PAXICTMB.pls, version 120.1, dated 2005/08/05). Because it is delivered as an empty template with only comments and reset logic, it has no runtime effect until a customer implements the body. It is classified as an "OTHER" API in ETRM rather than a public API, indicating that it is invoked internally by Oracle Projects rather than called directly by external applications.

Key Procedures and Functions

The package body documents a single procedure:

  • CALC_BILL_AMOUNT — The documented extension hook for calculating bill amounts and bill rates. The procedure accepts a transaction type ('ACTUAL' or 'FORECAST'), an expenditure item identifier, and a system linkage function, and returns the calculated amount, a bill rate flag, a status indicator, and, for multi-currency billing (MCB2) support, the bill transaction currency code, bill transaction bill rate, markup percentage, and a rate source identifier. The body resets all output parameters at the start of execution and contains only instructional comments where a customer's calculation logic should be inserted. The comments specify that a customer sets the bill rate flag to 'B' to have Project Accounting populate a bill rate, returns the rate in the bill transaction rate out parameter, returns any markup percentage and a unique rate source identifier, and treats a null or 'N' flag as a markup. The comments also note that the transaction type parameter permits 'ACTUAL' or 'FORECAST' values so the logic can branch accordingly. The body explicitly prohibits COMMIT or ROLLBACK statements, since Oracle Project Accounting controls transaction boundaries, and includes an OTHERS exception handler placeholder for customer error handling.

Tables Accessed

Oracle ETRM does not document any tables referenced through APPS synonyms for this package body. This is consistent with the delivered template: the stub contains no SQL against any table. Any table access occurs only after a customer implements the calculation logic, at which point the implementation typically queries Project Accounting and Oracle Purchasing tables (such as expenditure items, bill rate schedules, and rate source definitions) to derive the bill amount or rate. Because such access is customer-defined, no table dependencies are recorded in the ETRM metadata for the seeded object.

Usage Notes

This package is not invoked by end users or called from forms or concurrent programs directly. It is called by the Oracle Projects billing engine at the point where bill amounts and bill rates are determined, and it is referenced by one other package in the EBS data model. In practice, the extension runs during billing generation and related billing processes handled by Project Accounting, including actual and forecast billing flows. Customers who require custom bill amount or rate derivation implement the CALC_BILL_AMOUNT logic in this package, populate the output parameters as described in the seeded comments, and compile the package in the APPS schema. The same behavior applies across Oracle EBS 12.1.1 and 12.2.2; the deliverable is unchanged between the two releases. Because the package participates in transactions controlled by Oracle Projects, implementations must avoid explicit COMMIT or ROLLBACK statements and should raise errors through the provided exception handler to ensure the caller can process the failure correctly.