Results for “psb_ws_position_fte_i_pvt”

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

Overview

The APPS.PSB_WS_POSITION_FTE_I_PVT package is a private PL/SQL API within the Oracle E-Business Suite (EBS) Human Resources and Grants/Proposals domain, associated with the Public Sector Budgeting (PSB) module. In Oracle EBS 12.1.1 and 12.2.2, PSB is used by public sector and grant-funded organizations to allocate budgets and effort across positions, employees, and funding sources. The "FTE" designation refers to Full-Time Equivalent, a measure used throughout position control and budgeting to quantify labor allocation. The "_I_" infix denotes an "interface" or "insert" oriented package, and the "_PVT" suffix indicates it is a private package body — meaning it is intended for internal consumption rather than direct customer invocation.

This package serves as a low-level worker component that performs physical data manipulation on behalf of a corresponding public-facing interface package. Its primary business function is to support the integration or loading of position FTE data into the PSB schema, allowing position effort records to be inserted and staged for downstream budgeting and position control processing. It participates in the broader Oracle public sector budgeting workflow where FTE values drive salary, benefit, and cost allocation calculations.

Key Procedures and Functions

The ETRM metadata documents a single procedure for this package:

• INSERT_ROW — This procedure performs the core insert operation, adding a single row of position FTE data to the relevant PSB interface or staging table. It encapsulates the column mapping and defaulting logic required to translate an inbound FTE record into the canonical PSB table structure. As a private (PVT) routine, it is designed to be called by companion public APIs rather than directly by end users or external integrations. No parameter details are documented, and no other procedures or functions are recorded in the ETRM catalog.

The presence of only one documented procedure reflects the package's narrow, focused responsibility as an internal insert helper.

Tables Accessed

The ETRM metadata does not explicitly enumerate the tables referenced by this package via APPS synonyms. However, based on its insertion role and its naming convention tied to position FTE data, the package logically operates against PSB position and FTE interface/staging tables (such as those prefixed PSB_WS_POSITION_FTE or similar). It writes incoming FTE rows into these structures, which are later validated and processed by other PSB components. The absence of documented table references should be treated as a metadata limitation rather than evidence that no tables are touched.

Usage Notes

Because PSB_WS_POSITION_FTE_I_PVT is a private package (PVT) and is referenced by only the public package of the same base name (PSB_WS_POSITION_FTE_I_PVT, per the dependency listing), it is not intended for direct invocation by users, concurrent programs, or custom code. It should be invoked exclusively through its corresponding public wrapper package, which supplies validation, error handling, and FND_API-based message stacking.

The dependency on FND_API confirms that it follows Oracle's standard API error and message handling conventions, using the FND message stack for diagnostics. Developers performing troubleshooting should therefore inspect the public caller rather than this package directly. Direct modification or invocation is discouraged, as it bypasses the public contract and may compromise data integrity in PSB position budgeting.