Search Results pa_efc_bil




Overview
Explore in AI Chat

Overview

PA_EFC_BIL is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and belonging to the Oracle Projects (PA) module family. The package name follows the Enterprise Financial Calculation (EFC) convention used within Oracle Projects for funds and revenue-related computations. Its declared purpose, as reflected by its name and documented signature, is to support billing and revenue inquiry functionality by retrieving and adjusting amounts related to baselined, unbilled, billed, and accrued revenue and invoice figures for a given project, task, and agreement. The package is defined with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking user rather than as definer rights, and its source header indicates a last modification date consistent with release 11i onward maintenance through 12.1.1 and 12.2.2.

PA_EFC_BIL is classified as OTHER in the ETRM inventory rather than as a formal public API, and it is not referenced by any other packages within the documented dependency set. This indicates it functions primarily as an internal helper for Oracle Projects billing and revenue inquiry screens rather than as an integration point exposed to external code.

Key Procedures and Functions

The package exposes four documented program units:

  • Get_B_Ub_Rev_Inv_Amts — The principal retrieval routine. Given a project, task, and agreement identifier, it returns the baselined amount, unbilled (unbaselined) amount, billed amount, and accrued revenue amount for the specified funding combination. It additionally returns an adjustment amount and evaluates a revenue limit flag. The IN OUT NOCOPY parameters allow callers to pass initial values that may be retained or refined during processing.
  • Update_Adjusted_Amount — Writes a revised adjusted amount back for a given project, agreement, and task. This supports correction or user-entry scenarios in which the computed adjustment returned by Get_B_Ub_Rev_Inv_Amts must be persisted.
  • sum_mc_cust_rdl_erdl — A function that aggregates customer-related raw draft revenue and draft revenue line amounts for a specified project, draft revenue number, draft revenue item line number, and set of books. It is declared with PRAGMA RESTRICT_REFERENCES (WNDS), confirming it performs no database writes and can be safely invoked from SQL.
  • sum_mc_cust_rdl_erdl2 — An overloaded variant that performs a similar multi-currency customer draft revenue aggregation at the project and draft revenue level, keyed by project, draft revenue number, and set of books. It is likewise WNDS-restricted.

Tables Accessed

The documented table references identify the core Oracle Projects billing and funding structures used by the package:

All access is performed through APPS synonyms, consistent with the AUTHID CURRENT_USER declaration and standard Oracle Projects coding practice.

Usage Notes

PA_EFC_BIL is typically invoked from Oracle Projects billing and revenue inquiry forms, particularly the Project Funding and Revenue Review windows where users examine baselined versus unbilled and billed balances. It is not documented as a public API and should not be called directly from customer extensions without risk assessment, since its parameter interface and internal logic are not guaranteed stable across patches. Custom code that must invoke it should do so through an APPS-privileged session and treat the output parameters as read-only diagnostics. Because the two sum_mc_cust_rdl_erdl functions are WNDS-restricted, they may be embedded in custom SQL statements for reporting, but the procedures should be called only from PL/SQL contexts. Any modification to funding adjustment values should be routed through Oracle Projects' supported business flows so that the EFC summary tables remain consistent with the transactional funding records.