Search Results pa_rev_ca




Overview
Explore in AI Chat

Overview

PA_REV_CA is a PL/SQL package owned by the APPS schema within Oracle E-Business Suite. Its name reflects its functional role: PA_REV denotes the Revenue component of Oracle Projects, while the CA suffix indicates Cost Accrual processing. The package therefore serves as a supporting technical utility within the revenue generation and cost accrual cycle of Oracle Projects. It is classified under the ETRM API classification of OTHER, indicating it is not an externally published open interface API but rather an internal package invoked by other Oracle Projects programs and, where required, by extensions.

Within the Oracle Projects architecture, revenue generation depends on the correct interpretation of project status, billing assignments, event revenue distributions, and draft revenue records. PA_REV_CA supplies validated calculations and status checks that support these activities, particularly around determining whether cost accrual is applicable and how accrual amounts are computed. The package is registered as VALID in the APPS schema for both Oracle EBS 12.1.1 and 12.2.2, and it references only the SYS.STANDARD package externally, relying otherwise on the APPS schema objects listed below.

Key Procedures and Functions

The ETRM metadata documents four procedures or functions within PA_REV_CA. Parameter lists are not published in the available metadata and are therefore not reproduced here.

  • CALC_CA_AMT — Calculates the cost accrual amount. This routine is the core computational element of the package, deriving the accrual value from the supplied project, task, and period context.
  • GET_PSI_COLS — Retrieves Project Status Inquiry (PSI) related columns or values. This routine supports status reporting by exposing the relevant PSI attributes for downstream consumers.
  • VERIFY_PROJECT_STATUS_CA — Verifies that the project status permits cost accrual processing. This validation guard prevents accrual calculations from proceeding against projects in statuses that should not accrue.
  • CHECK_IF_COST_ACCRUAL — Determines whether cost accrual is applicable for the given context, returning a flag or indication used by calling code to branch its processing logic.

Tables Accessed

The package reads and writes the following Oracle Projects tables through APPS synonyms:

Usage Notes

PA_REV_CA is referenced only by itself within the documented dependency graph and is not referenced by any other package, which confirms its role as a terminal utility that is called rather than one that exposes a broadly shared interface. It is typically invoked by Oracle Projects revenue generation and cost accrual concurrent programs, and indirectly through corresponding forms when users initiate accrual or revenue processing. Custom code should not assume stability of parameter lists, which are not published in the ETRM metadata. Extensions that require accrual determinations should preferably call documented open APIs; where PA_REV_CA is used directly, the four procedures above and the table access pattern described here should be treated as internal implementation detail subject to change across releases.