Search Results get_psi_cols

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:

PA_PROJECTS_ALL, PA_PROJECT_STATUSES, PA_TASKS — Supply project identity, current status, and task hierarchy required by the status verification and accrual routines.
PA_BILLING_ASSIGNMENTS_ALL, PA_BILLING_EXTENSIONS — Provide billing assignment and extension attributes used to determine revenue and accrual treatment.
PA_BUDGET_TYPES, PA_BUDGET_VERSIONS, PA_FIN_PLAN_TYPES_B — Define the budgetary and financial plan context relevant to cost accrual.
PA_EVENTS, PA_CUST_EVENT_RDL_ALL, PA_DRAFT_REVENUES_ALL, PA_DRAFT_REVENUE_ITEMS — Support event-based revenue processing and draft revenue creation, the outputs of the revenue generation cycle.
PA_EXPENDITURE_ITEMS_ALL, PA_COST_DISTRIBUTION_LINES_ALL — Supply the expenditure and cost distribution detail from which accrual amounts are derived.
PA_PERIODS — Defines the accounting period context for accrual and revenue processing.

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.