Results for “get_worksheet_flag”

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

Overview

PSB_POSITIONS_PVT is a private PL/SQL package body in the APPS schema that supports the Oracle E-Business Suite position budgeting and control functionality delivered through the Public Sector Budgeting (PSB) modules and the related position management framework. It functions as the internal engine behind the externally exposed positions API, encapsulating the row-level logic for creating, maintaining, validating, updating, and deleting position records and their associated assignments, payroll distributions, and budget worksheet entries. The package operates as part of the broader PSB_*_PVT family of private packages and depends heavily on generic EBS utility packages such as FND_API, FND_MSG_PUB, FND_MESSAGE, FND_GLOBAL, and FND_FLEX_KEYVAL, indicating that it participates in the standard EBS API error-handling, multi-org, and key flexfield validation conventions. Because the object is classified as a PVT (private) package body, it is not intended to be invoked directly by end users but is called by other packages and forms to complete transactional work.

Key Procedures and Functions

The package exposes 25 documented procedures and functions that govern the lifecycle of a position record. Initialization and context utilities include INITIALIZE_VIEW, GET_START_DATE, GET_END_DATE, GET_SELECT_DATE, GET_WORKSHEET_FLAG, GET_WORKSHEET_ID, and GET_DEBUG, which set up the working context and retrieve date and worksheet-related values. Row manipulation routines include INSERT_ROW, LOCK_ROW, UPDATE_ROW, ADD_ROW, and DELETE_ROW, providing the core DML operations on position data. Assignment-specific logic is handled by DELETE_ASSIGNMENTS, DELETE_ASSIGNMENT_EMPLOYEES, MODIFY_ASSIGNMENT, and CREATE_DEFAULT_ASSIGNMENTS, supporting the management of employees tied to positions. Validation and business-rule enforcement are provided by VALIDATE_SALARY, POSITION_WS_VALIDATION, and REV_CHECK_ALLOWED. DEFINE_WORKSHEET_VALUES supports worksheet value definition. These procedures collectively implement position budgeting, assignment maintenance, salary validation, and worksheet processing within the position management flow.

Tables Accessed

The package reads and writes a broad set of PSB and related tables through APPS synonyms. Position master data is stored in PSB_POSITIONS, PSB_BUDGET_POSITIONS, and PSB_POSITION_ASSIGNMENTS, while assignment attributes and values are held in PSB_ATTRIBUTES and PSB_ATTRIBUTE_VALUES. Assignment and entity relationships are managed through PSB_ENTITY_ASSIGNMENT, PSB_ENTITY_SET, and PSB_SET_RELATIONS. Payroll-related data flows through PSB_PAY_ELEMENTS, PSB_PAY_ELEMENT_DISTRIBUTIONS, and PSB_POSITION_PAY_DISTRIBUTIONS. Budget structure and defaults are supported by PSB_BUDGET_GROUPS, PSB_BUDGET_PERIODS, PSB_BUDGET_REVISIONS, PSB_BUDGET_YEAR_TYPES, PSB_DEFAULTS, PSB_DEFAULT_ACCOUNT_DISTRS, and PSB_DEFAULT_ASSIGNMENTS. Worksheet data resides in PSB_WORKSHEETS, PSB_WS_POSITION_LINES, and PSB_WS_ACCT1. Employee reference data is drawn from PSB_EMPLOYEES, and account validation relies on GL_CODE_COMBINATIONS and FND_ID_FLEX_SEGMENTS. It also calls peer private packages such as PSB_POSITIONS_I_PVT, PSB_POSITION_ASSIGNMENTS_PVT, PSB_POSITION_PAY_DISTR_PVT, PSB_BUDGET_POSITION_PVT, PSB_VALIDATE_ACCT_PVT, and PSB_HR_POPULATE_DATA_PVT.

Usage Notes

PSB_POSITIONS_PVT is invoked internally by the position management forms and by the public private-API layer (PSB_POSITIONS_I_PVT and related packages) rather than by external custom code. The metadata confirms that it is referenced by 23 other packages and is not referenced by any database object in the reverse direction, consistent with its role as a mid-tier orchestrator invoked at runtime. It is typically reached during position creation, maintenance, assignment updates, salary validation, and worksheet processing within Public Sector Budgeting and related position-control workflows. Customizations should call the supported public API packages instead of this private package body, since its interface is subject to change between releases such as 12.1.1 and 12.2.2. Understanding its dependencies is valuable when troubleshooting position budget errors, since failures propagate through FND_MSG_PUB and are surfaced by the calling forms or concurrent programs.