Search Results psb_acct_position_set_line_pvt




Overview
Explore in AI Chat

Overview

The APPS.PSB_ACCT_POSITION_SET_LINE_PVT package is a private PL/SQL API within the Oracle E-Business Suite Public Sector Budgeting (PSB) module, part of the Enterprise Technical Reference Model (ETRM) for releases 12.1.1 and 12.2.2. Its purpose is to encapsulate the low-level data manipulation logic for the individual line records that comprise an account position set. Account position sets define the groupings of accounting flexfield combinations and position criteria used during budget preparation, worksheet generation, and position control processing. By isolating insert, update, delete, and locking operations for position set lines into a dedicated private package, the PSB module enforces consistent validation and concurrency behavior across all callers. The _PVT suffix indicates this is a private package: it is not intended to be called directly by external or customer code, but rather serves as the internal implementation layer consumed by public PSB APIs and their corresponding _I_PVT, _L_PVT, and _O_PVT (inbound, locking, outbound) companion packages. The package is documented as VALID in the APPS schema and depends on the Oracle Application Object Library FND_API package, confirming that it participates in the standard EBS API error-handling and message-stack conventions.

Key Procedures and Functions

The ETRM metadata documents four procedures exposed by this package, each corresponding to a standard CRUD operation on the account position set line entity:

  • INSERT_ROW — Creates a new account position set line record, populating the base table and the associated _S (sequence/primary key) table for the position set line entity.
  • LOCK_ROW — Acquires a row-level lock on an existing line record, supporting optimistic concurrency control before an update or delete is attempted.
  • UPDATE_ROW — Modifies the attributes of an existing line record, applying the changes in a controlled manner consistent with the PSB data model.
  • DELETE_ROW — Removes a line record from the account position set, along with any dependent details.

Consistent with EBS API design, these procedures are expected to raise and propagate errors through the FND_API message stack rather than using unhandled exceptions. Parameter lists are not enumerated in the ETRM extract; callers must reference the package specification for exact signatures.

Tables Accessed

The package operates on the following tables, referenced through APPS synonyms:

Usage Notes

This package is invoked indirectly. The ETRM dependency data shows it is referenced by six other packages, including PSB_ACCOUNT_POSITION_SET_PVT, PSB_ACCT_POS_SET_LINE_I_PVT, PSB_ACCT_POS_SET_LINE_L_PVT, PSB_ACCT_POS_SET_LINE_O_PVT, PSB_POSITION_CONTROL_PVT, and PSB_WORKSHEET_CONSOLIDATE. Consequently, routine maintenance of account position set lines flows from Public Sector Budgeting forms, budget worksheet consolidation, and position control concurrent programs. Custom code should never call this private package directly; instead, it should use the corresponding public or inbound (_I_PVT) API, which delegates here after performing validation. Direct invocation risks bypassing concurrency locking and FND_API error handling.