Search Results create_default_assignments

Overview

PSB_POSITIONS_I_PVT is a private PL/SQL API package in the Oracle EBS Public Sector Budgeting (PSB) module. It supplies the low-level processing logic that supports position worksheet operations within the PSB budget preparation cycle. Its central role is the management of position assignments—the link between a budget position, its attributes (such as pay elements, employee, and account distributions), and the worksheet context in which those assignments are defined. Because it is classified as a PVT (private) API, it is not intended for direct invocation by external integrations. Instead, it serves as the internal engine called by public APIs and by the PSB forms and concurrent programs that maintain budget positions and worksheet values.

Key Procedures and Functions

The package exposes ten documented procedures and functions:

• Initialize_View — Prepares worksheet view state for a given worksheet, start date, end date, and optional select date, establishing the context used by subsequent operations.
• Define_Worksheet_Values — Populates or recalculates worksheet values for a position and budget source, returning worksheet identifiers and effective date ranges.
• Modify_Assignment — The procedure associated with the "modify_assignment" search term. It is used for both inserting and modifying position assignments, accepting assignment type, attribute, pay element, effective dating, employee, and primary-employee parameters.
• Create_Default_Assignments — Generates default assignments, typically drawing from the defaults and default assignment tables.
• Get_Select_Date — Retrieves the effective select date used to anchor worksheet and assignment processing.
• Check_Allowed and Rev_Check_Allowed — Perform validation checks controlling whether a requested action or relationship is permitted.
• Modify_Distribution_WS — Maintains worksheet distributions associated with positions and assignments.
• Delete_Row — Removes a worksheet or assignment row.
• Lock_Row — Places a lock on a row to enforce concurrency control during maintenance.

Tables Accessed

The package reads and writes a defined set of PSB tables through APPS synonyms. PSB_POSITIONS and PSB_BUDGET_POSITIONS hold the position and budget position records being maintained. PSB_ENTITY_ASSIGNMENT stores the assignment rows that Modify_Assignment creates or changes, with PSB_DEFAULT_ASSIGNMENTS and PSB_DEFAULTS supplying default assignment data. PSB_POSITION_PAY_DISTRIBUTIONS and PSB_DEFAULT_ACCOUNT_DISTRS hold pay and account distribution detail. PSB_ENTITY_SET and PSB_SET_RELATIONS support entity set and set relationship resolution used during validation and processing, and DUAL provides standard single-row evaluations.

Usage Notes

PSB_POSITIONS_I_PVT is invoked indirectly through PSB forms and public APIs rather than by custom code. Applications that need to create or change position assignments should call the supported public API that wraps Modify_Assignment; calling the private package directly bypasses the validation and messaging contract maintained by the public layer. Custom code that does reference it must follow the standard PL/SQL API conventions reflected in the signature—passing an API version, initializing the message list, honoring the commit and validation-level flags, and inspecting the return status, message count, and message data outputs. Concurrency should be respected through Lock_Row, and the package is referenced by three other packages, confirming its position as a shared internal service for position worksheet processing.