Search Results psb_acct_position_set_lines_s

Overview

The APPS.PSB_ACCT_POSITION_SET_LINE_PVT package body is a private (PVT) PL/SQL API within the Oracle E-Business Suite Public Sector / Human Resources position management module. It provides the internal implementation logic that allows an account position set line to be created, modified, queried, and removed from the repository of positions associated with a position set. A position set is used to group related positions for budgeting, reporting, and mass-assignment purposes, and the individual line records stored through this package define the specific positions that belong to a given account position set.

Because the object is classified as a private API, it is intended to be called by the corresponding public (PUB) package rather than directly by external code. It encapsulates the row-level data manipulation and validation logic for the PSB_ACCT_POSITION_SET_LINES entity, ensuring that the entity’s integrity constraints and concurrency rules are consistently enforced. The body is valid in the APPS schema and depends on several standard Oracle EBS infrastructure packages, including FND_API, FND_MESSAGE, FND_MSG_PUB, and APP_EXCEPTION, which provide the standard error-handling, message-stack, and API return-status conventions used across EBS application programming interfaces.

Key Procedures and Functions

The documented package body exposes four core procedures that implement the full insert, update, delete, and locking lifecycle for account position set lines:

• INSERT_ROW — Creates a new account position set line record. It performs the initial insert into the base table and the associated secure (“_S”) table, applying defaulting and validation before the row is committed.
• LOCK_ROW — Obtains a row-level lock on an existing account position set line. It is typically invoked before an update or delete to guarantee concurrency control and prevent lost updates when multiple sessions process the same line.
• UPDATE_ROW — Modifies an existing account position set line, updating the applicable base and secure table columns and recording audit information appropriate to the EBS standard.
• DELETE_ROW — Removes an account position set line, typically executed as a logical or physical delete in line with the surrounding business logic and referential dependencies.

Each procedure follows the EBS API conventions delivered by FND_API, returning a standard status and populating the FND_MSG_PUB message stack on error, which allows calling processes to react uniformly to failures.

Tables Accessed

The body reads from and writes to four documented tables through APPS synonyms:

• PSB_ACCOUNT_POSITION_SET_LINES — the base transactional table holding account position set line records; the primary target of INSERT_ROW, UPDATE_ROW, and DELETE_ROW.
• PSB_ACCT_POSITION_SET_LINES_S — the secure (row-level security) companion table, maintained in parallel with the base table so that security-constrained queries return the correct lines.
• PSB_POSITION_SET_LINE_VALUES — stores the attribute values associated with position set lines, read and validated during line processing.
• DUAL — used for single-row queries such as sequence retrieval, defaulting, and existence checks.

Usage Notes

This private package is not intended for direct invocation by custom code. It is referenced by six other database objects and is called primarily by the corresponding public API wrapper, which may in turn be invoked from the Account Position Set maintenance forms, from concurrent programs that mass-maintain position sets, or from other PL/SQL business logic within the position management module. The object’s metadata identifies it as valid, with no database object depending directly on this body, confirming its role as a lower-level implementation layer. When integrating or troubleshooting position set line behavior in either EBS 12.1.1 or 12.2.2, developers should target the public wrapper API and treat PSB_ACCT_POSITION_SET_LINE_PVT as an internal dependency whose logic is subject to change.