Search Results pa_cost_plus1




Overview
Explore in AI Chat

Overview

PA_COST_PLUS1 is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite releases 12.1.1 and 12.2.2. It belongs to the Oracle Projects (PA) application and supports the burdening and indirect cost calculation infrastructure of the Cost Plus revenue and costing model. The package is classified as OTHER in the ETRM repository, indicating that it is a supporting internal utility rather than a fully published public API.

Its principal business function is to compute indirect cost amounts by applying compiled multipliers held in the indirect cost compiled sets to a supplied set of direct cost inputs. The package resolves the relevant indirect rate schedule revision for a given organization and cost base, derives the compiled multiplier set, and returns the resulting indirect cost totals, denominators, and accounted or project currency amounts. It also provides the logic behind the VIEW_INDIRECT_COST procedure, which is the object most commonly sought by users investigating indirect cost behavior in Oracle Projects.

Key Procedures and Functions

  • GET_INDIRECT_COST_IMPORT — The principal import-oriented calculation routine. It accepts direct cost inputs across functional, denomination, accounted, and project currency dimensions, together with an organization identifier, cost base, and rate schedule revision, and returns the corresponding indirect cost sums along with status and stage indicators used for error and progress tracking.
  • VIEW_INDIRECT_COST — Exposes indirect cost results for inspection, allowing callers to retrieve the computed indirect burden associated with a given cost base and rate schedule revision. This is the procedure users reach when diagnosing why a particular transaction received a specific indirect cost amount.
  • GET_INDIRECT_COST_AMOUNTS — Returns the calculated indirect cost amounts for the supplied context, serving as the general-purpose retrieval entry point for indirect cost values.
  • GET_IND_RATE_SCH_REV — Resolves the indirect rate schedule revision applicable to the organization and cost base being evaluated, which is a prerequisite for locating the correct compiled set.
  • GET_COMPILE_SET_INFO — Retrieves the compiled set information associated with the identified rate schedule revision, providing the multiplier data used in the burdening arithmetic.

Tables Accessed

  • PA_IND_COMPILED_SETS — Holds the compiled indirect cost set definition for a rate schedule revision and organization. The package joins on the compiled set identifier, organization, and the cost base, and filters on an active status before using the set.
  • PA_COMPILED_MULTIPLIERS — Stores the compiled multiplier values applied to direct costs to derive indirect costs. The join between the compiled set and its multipliers supplies the multiplier used in each calculation.
  • PA_IND_RATE_SCH_REVISIONS — Provides the indirect rate schedule revision context, which anchors the lookup of the correct compiled set and multiplier combination.

Usage Notes

PA_COST_PLUS1 is invoked internally rather than directly by end users. It is called from Oracle Projects burdening and cost distribution logic, and it is referenced by two other packages within the application. Typical invocation paths include concurrent programs that process indirect cost allocation and burdening for Cost Plus projects, and internal service routines that must resolve an indirect rate for a given expenditure item.

The procedure is also a common diagnostic point for custom code and support investigations involving indirect cost discrepancies, since it encapsulates the multiplier lookup and rounding behavior applied during burdening. Currency rounding is performed through PA_CURRENCY utilities, so results are sensitive to the currency codes passed by the caller. Because these are internal, non-public routines, customizations should avoid direct dependency where an officially supported Oracle Projects API exists, and any direct call must supply valid organization, cost base, and rate schedule revision identifiers to avoid incomplete indirect cost results.