Results for “psb_ws_position_cpc_pvt”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PSB_WS_POSITION_CPC_PVT is a private PL/SQL package in the Oracle EBS Applications (APPS) schema associated with the Public Sector/Project Billing positioning and worksheet functionality (PSB module). The suffix "CPC" refers to Cost Position Calculation, and the package serves as the calculation engine that computes the cost of a position line on a worksheet. It is classified in the ETRM repository as a PVT (private) API, meaning it is intended for internal consumption by Oracle's own forms, packages, and concurrent programs rather than as a supported public integration interface.

The business function addressed by this package is the recalculation of cost for a specific position line whenever the underlying worksheet data changes. In the EBS Worksheet framework, position lines represent detailed cost or revenue elements, and their cost values must be kept consistent with the source data. This package provides the runtime logic that performs that recalculation on demand.

Key Procedures and Functions

The ETRM metadata documents a single procedure:

• Calculate_Position_Cost — The sole documented entry point. Its purpose is to compute and store the cost associated with a given position line on a worksheet. The procedure accepts a standard PL/SQL API parameter envelope (API version, initialization flag, commit flag, validation level, return status, message count, and message data) together with the two business keys: the worksheet identifier and the position line identifier. It therefore operates as a self-contained, transactional API that reports success or failure through the standard FND_API return status and message stack.

No other procedures or functions are exposed in the documented specification.

Tables Accessed

The ETRM excerpt for this object does not enumerate the tables referenced through APPS synonyms, and no referenced tables are listed in the documented metadata. Based on the naming convention and the procedure's purpose, the package is expected to read the position line and worksheet tables within the PSB schema and write the computed cost value back to the position line record. Because the object is a private package, its table access is implementation detail and is not published as part of a supported interface.

Usage Notes

According to the source header comment, the procedure is "Called from Forms when the worksheet is changed." This confirms the typical invocation path: an Oracle Forms-based worksheet screen triggers a recalculation of the position cost whenever the user modifies worksheet data, and the form calls PSB_WS_POSITION_CPC_PVT.Calculate_Position_Cost to refresh the affected position line. The default commit flag of FND_API.G_FALSE indicates that the procedure participates in the caller's transaction and does not commit independently unless requested.

Because the package is classified as PVT and referenced by zero other documented packages in the ETRM repository, it is not intended as a public or supported API. Customizations should avoid direct dependency on this package, as its signature and behavior are subject to change without notice across releases such as 12.1.1 and 12.2.2. The relevant search term "charging pt" is consistent with the cost-charging nature of the calculation performed here, though the documented object name uses "Position Cost" terminology rather than a literal charge point.