Search Results pa_cost1




Overview
Explore in AI Chat

Overview

PA_COST1 is a public PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified in the E-Business Suite Technical Reference Manual (ETRM) with an API classification of OTHER. Its status is VALID, and it appears in both Oracle EBS 12.1.1 and 12.2.2. The package encapsulates core project costing calculations used by the Oracle Projects (PA) application. It provides the programming interface through which burdened cost, raw cost, expenditure cost rates, rate schedules, and currency conversion amounts are derived for project transactions. These are the same calculations that drive the Costing, Burdening, and Distribution processes in Oracle Projects, and they are exposed as callable functions so that other project packages, forms, and custom extensions can reproduce exactly the same results.

Key Procedures and Functions

The documented unit exposes seven callable objects. The descriptions below are drawn from the package's naming semantics; parameter lists are not enumerated because the ETRM metadata does not publish them.

  • CHECK_PROJ_BURDENED — Determines whether a given project is subject to burdening, returning a flag that downstream costing logic uses to decide whether burdened cost should be computed in addition to raw cost.
  • GET_PLAN_ACTUAL_COST_RATES — Retrieves the planned and actual cost rates applicable to a project, supporting comparisons between budgeted and incurred rates.
  • GET_NON_LABOR_RAW_COST — Derives the raw (unburdened) cost of non-labor expenditures such as material and expense items, based on the expenditure type and item or rate source.
  • GET_BURDEN_SCH_DETAILS — Returns the details of a burden schedule, typically the structure that defines the multipliers and tiers applied when burdening eligible costs.
  • GET_RATESCHDETAILS — Returns the details of a cost rate schedule, including the rate lines that map expenditure types or organizations to specific rates.
  • CONVERT_COST_TO_PC_PFC — Converts cost amounts between the project currency (PC) and the project functional currency (PFC), a prerequisite for multi-currency project reporting and accounting.
  • CONVERT_AMOUNTS — A general-purpose currency conversion routine used by the other cost conversion paths to translate an amount from one currency to another using Oracle General Ledger rates.

Tables Accessed

The package reads reference and transactional data from a well-defined set of APPS tables, accessed through public synonyms:

Usage Notes

PA_COST1 is an internal project costing utility package rather than a public integration API. It is referenced by other Oracle Projects packages, including PA_PLAN_REVENUE and PA_PROGRESS_UTILS, and it is listed as referencing PA_COST1 itself, indicating recursive or overloaded internal use. In practice it is invoked by the Oracle Projects costing and burdening concurrent programs, the Project Costing and related forms, and any custom PL/SQL that must reproduce Oracle Projects cost derivation logic. Because the ETRM classifies it as OTHER rather than as a supported API, customizations should call it with care and revalidate all signatures after applying an Oracle Projects patch or upgrading between 12.1.1 and 12.2.2, since signatures and internal table dependencies may change between releases.