Search Results assignment_fte

Overview

PQH_PSF_BUS is an Oracle EBS PL/SQL business-layer package owned by the APPS schema and classified as an "OTHER" API in the ETRM repository for release 12.2.2. It belongs to the Public Sector/Position Management family (PQH) and serves as the server-side validation engine supporting position and assignment business rules. Its central role is to validate and enrich records that pass through the HR and PER datetracked business layers, particularly those touching position control, funding, FTE, and assignment budget values.

The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking user rather than as the definer. This design permits calling forms and concurrent programs to inherit the caller's security context. The package header (pqpsfbus.pkh, header revision 120.1.12010000.1, dated 2008/07/28) confirms it is an established component spanning the 11i through R12 lineages, and it exposes seventy-five documented procedures and functions. It is referenced by twelve other packages, indicating it is embedded in a wider call network for Human Resources and Public Sector position management.

Key Procedures and Functions

The documented entry points include the following:

• POSITION_CONTROL_ENABLED — Returns a VARCHAR2 flag indicating whether position control is active for a given organization at an effective date, and optionally for a specific assignment. It is the gatekeeper consulted before position-related validations apply.
• HR_PSF_BUS_INSERT_VALIDATE — Validates a new HR position/PSF record passed in as a record type prior to insertion.
• HR_PSF_BUS_UPDATE_VALIDATE — Validates changes to an existing HR position/PSF record, accepting the effective date plus validation start and end dates and the datetrack mode.
• PER_ASG_BUS_INSERT_VALIDATE — Validates a new assignment record within the PER business layer.
• PER_ASG_BUS_UPDATE_VALIDATE — Validates an updated assignment record, with datetrack-aware parameters.
• PER_ASG_BUS_DELETE_VALIDATE — Validates that an assignment may be deleted, guarding against conditions where removal would violate position or funding integrity.
• PER_ABV_INSERT_VALIDATE and PER_ABV_UPDATE_VALIDATE — Validate inserts and updates to assignment budget values, which link assignments to their funding pools.
• FUNDED_STATUS — Determines the funded position status used during position and budget evaluation.
• SUM_ASSIGNMENT_FTE, ASSIGNMENT_FTE, and DEFAULT_ASSIGNMENT_FTE — Calculate total, individual, and default full-time-equivalent values for assignments, supporting FTE-based budget and headcount checks.
• FUTURE_APPROVED_ACTIONS — Identifies approved position or assignment actions with future effective dates.
• OPEN_STATUS, RESERVED_STATUS, REVIEW_STATUS, and VACANCY_STATUS — Return position lifecycle status indicators (open, reserved, in review, vacant) used for position administration.
• OVERLAP_PERIOD — Detects date overlaps between effective records.
• PERMIT_EXTENDED_PAY and PERMIT_EXTENDED_PAY_POI — Determine whether extended pay is permitted, including a point-of-interface variant.

Tables Accessed

The package reads and writes through APPS synonyms. HR_ALL_POSITIONS_F stores the datetracked position definitions validated by the HR_PSF routines. PER_ALL_ASSIGNMENTS_F holds assignment history examined and validated by the PER_ASG routines. PER_ASSIGNMENT_BUDGET_VALUES_F and PER_PAY_PROPOSALS carry budget and pay proposal data used in funding and extended-pay decisions, while PER_PAY_BASES supplies pay basis definitions. PER_ASSIGNMENT_STATUS_TYPES and PER_POSITION_EXTRA_INFO provide status and position-specific attributes. Organization structure context comes from PER_ORGANIZATION_STRUCTURES, PER_ORG_STRUCTURE_ELEMENTS, and PER_ORG_STRUCTURE_VERSIONS, supported by HR_ORGANIZATION_INFORMATION. PAY_ELEMENT_TYPES_F_TL, PAY_INPUT_VALUES_F, and PAY_INPUT_VALUES_F_TL resolve payroll element names and input values, and FND_SESSIONS supplies session context.

Usage Notes

PQH_PSF_BUS is not intended for direct end-user invocation. It is called by the HR and PER business-layer packages during DML on positions, assignments, and assignment budget values, most commonly triggered from EBS forms such as the Position and Assignment windows or through concurrent programs performing mass position and budget processing. Its validation routines fire on insert, update, and delete operations, and its FTE, status, and funding functions are used to derive default values or to enforce business rules before the datetracked tables are modified. Because it is referenced by twelve other packages, customizations should avoid overriding its documented logic; instead, reference the public functions and procedures from custom code where equivalent validations are required. The AUTHID CURRENT_USER declaration means callers must hold appropriate privileges on the underlying tables and invoker's rights objects.