Search Results pa_mc_billing_pvt




Overview
Explore in AI Chat

Overview

PA_MC_BILLING_PVT is a private PL/SQL package in the Oracle E-Business Suite Projects (PA) module, owned by the APPS schema and declared with AUTHID CURRENT_USER. It belongs to the Multicurrency Billing component of Oracle Projects and supplies the amount-derivation logic used during billing, revenue accrual, and funding reconciliation. The package exposes a set of retrieval routines that compute budget, cost, revenue, and funding amounts for a given project and task combination, resolving those amounts against both the project set of books (PSOB) and reporting set of books (RSOB).

Because the package is classified as PVT (private), it is not a public integration API. It is intended for internal consumption by Oracle Projects billing programs and by other packages within the same product family, one of which is documented as referencing it. The routines return amounts through OUT parameters and report execution outcome through the standard x_return_status, x_msg_count, and x_msg_data error-handling triple used throughout Oracle Application Object Library conventions.

Key Procedures and Functions

  • GET_BUDGET_AMOUNT — Returns the revenue and cost budget amounts for a project/task, along with the resolved cost and revenue budget type codes. It accepts identifiers for the project, task, PSOB, RSOB, and billing extension, with optional budget type code inputs.
  • GET_PROJECT_TASK_BUDGET_AMOUNT — Retrieves raw cost, burdened cost, and revenue totals for a specific budget version, project, and task. The amount parameters are IN OUT, allowing callers to accumulate or carry forward running totals.
  • GET_COST_AMOUNT — Derives the cost amount for a project/task up to a specified accrue-through date, scoped by PSOB and RSOB.
  • GET_POT_EVENT_AMOUNT — Computes the amount associated with a specific potential (POT) event for a project/task, evaluated as of the accrue-through date.
  • GET_LOWEST_AMOUNT_LEFT — Determines the lowest remaining funding amount for a project/task and event combination, supporting funding-limit and floors validation.
  • GET_REVENUE_AMOUNT — Returns the revenue amount for a project/task under the same PSOB/RSOB and accrue-through-date context.

Tables Accessed

  • PA_BILLING_EXTENSIONS — Supplies billing extension definitions that influence how budget and cost amounts are derived for a project.
  • PA_BUDGET_TYPES — Provides the cost and revenue budget type codes used to classify retrieved budget amounts.
  • PA_BUDGET_VERSIONS — Identifies the budget version from which project/task budget totals are drawn.
  • PA_TASKS — Resolves task-level context for amount calculations scoped to a task within a project.
  • DUAL — Used for single-row expressions and default value derivation within the procedural logic.

All tables are referenced through APPS synonyms, consistent with the package's AUTHID CURRENT_USER declaration.

Usage Notes

PA_MC_BILLING_PVT is invoked internally rather than called directly by end users. Typical invocation paths include Oracle Projects billing and revenue concurrent programs, the billing extension execution framework, and other PA packages performing amount validation during invoice generation. The accrue-through-date parameter indicates that callers use the package in time-phased contexts, such as periodic billing runs, where amounts must reflect activity through a cutoff date.

Because private packages may change between releases, custom code should avoid calling PA_MC_BILLING_PVT directly; supported public APIs or views should be used instead. In the context of a search such as "ok agencies total billing aug 2025", the package would be the underlying engine that computes the budget, cost, revenue, and funding amounts aggregated for the reporting period, while the totals themselves are surfaced through higher-level billing and reporting programs. Behavior should be validated in both 12.1.1 and 12.2.2, as file version headers indicate the source predates 12.2 and the package is unchanged in documented procedure count.