Search Results psb_account_position_set_pvt




Overview
Explore in AI Chat

Overview

PSB_ACCOUNT_POSITION_SET_PVT is a private PL/SQL package in the APPS schema that provides the low-level data access layer for Account Position Sets within Oracle EBS Enterprise Performance Foundation / Profitability Manager. Account Position Sets define named collections of account-position assignments that ETRM uses to drive budgeting, data extraction, and worksheet consolidation. The package is classified as a PVT (private) API, which means it is not intended as a public integration interface; it is invoked internally by other ETRM packages and by the form and concurrent processing infrastructure that maintain position set definitions. It relies on FND_API for the standard EBS API return-status and message-handling conventions, and its documented status is VALID.

Key Procedures and Functions

The package exposes eight documented subprograms that collectively implement standard CRUD plus validation and copy behavior for account position set headers and their lines:

  • INSERT_ROW — creates a new account position set record in the base table, presumably with the standard WHO columns and a surrogate key.
  • LOCK_ROW — issues a SELECT ... FOR UPDATE to serialize concurrent edits against a single position set row before update or delete.
  • UPDATE_ROW — modifies the attributes of an existing position set record.
  • DELETE_ROW — removes an existing position set record.
  • CHECK_UNIQUE — validates that the proposed position set name or identifier does not duplicate an existing set.
  • CHECK_REFERENCES — verifies that no dependent rows exist before a delete, protecting referential integrity against lines, relations, and budget group usages.
  • COPY_POSITION_SET — duplicates a single position set, including header attributes and associated lines and attribute values.
  • COPY_POSITION_SETS — bulk variant of the copy operation, applied to a set of position sets in one invocation.

No parameter lists are documented in the ETRM metadata; callers should reference the actual package specification for signatures.

Tables Accessed

The documented table access reflects the full dependency graph of an account position set. The base and translated tables PSB_ACCOUNT_POSITION_SETS and PSB_ACCOUNT_POSITION_SETS_S hold header and language-specific text; PSB_ACCOUNT_POSITION_SET_LINES and PSB_POSITION_SET_LINE_VALUES store the position assignments and their associated values. PSB_ATTRIBUTE_VALUES captures additional descriptive attribute data. PSB_SET_RELATIONS records hierarchical relationships between sets. PSB_BUDGET_GROUPS and PSB_DATA_EXTRACTS are consulted to detect dependencies during CHECK_REFERENCES. DUAL and PLITBLM are used for PL/SQL-side value handling and bulk collection operations.

Usage Notes

Because the package is private, it is normally invoked indirectly. The Account Position Sets maintenance form calls these routines through its underlying ETRM form-level package, and the copy operations are often driven from concurrent programs that duplicate sets between scenarios or periods. Other ETRM packages — PSB_BUDGET_GROUPS_PVT, PSB_COPY_DATA_EXTRACT_PVT, PSB_ENTITY_SET_PVT, PSB_POSITION_CONTROL_PVT, and PSB_WORKSHEET_CONSOLIDATE — call this package when they need to resolve, copy, or validate position set membership. Custom code should generally target the public ETRM APIs rather than PSB_ACCOUNT_POSITION_SET_PVT directly, since the private API signature is not guaranteed across releases. Behavior is consistent on both 12.1.1 and 12.2.2, as no 12.2-specific table changes affect this object.