Search Results first_active_position_row

Overview

HR_PSF_BUS is the business-layer PL/SQL package that supports the Position / Position Setup Functionality (PSF) framework within Oracle E-Business Suite Human Resources. The package name convention follows the standard Oracle HRMS pattern in which a "_BUS" suffix denotes the business rules layer that sits between the user interface (Forms) and the underlying table-handling or shadow logic. In this architecture, the corresponding "_INS", "_UPD", "_DEL" and "_SHD" packages handle physical row manipulation and date-tracked shadow records, while HR_PSF_BUS encapsulates the validation, business-rule enforcement and cross-entity consistency checks that must be applied whenever a position or position-related record is created, modified or removed.

Operating in the APPS schema and reported as VALID in both release 12.1.1 and 12.2.2, HR_PSF_BUS is classified under the ETRM as an "OTHER" API object. It is not an open, externally supported interface in the sense of a public API such as HR_POSITION_API; rather it is an internal component of the position management stack, invoked by Oracle's own Forms and by sibling packages. It exposes thirteen documented procedures and functions.

Key Procedures and Functions

• INSERT_VALIDATE, UPDATE_VALIDATE, DELETE_VALIDATE — the principal entry points that enforce business rules before a position row is inserted, changed or deleted. They are called by the corresponding HR_PSF_INS, HR_PSF_UPD and HR_PSF_DEL packages.
• SET_SECURITY_GROUP_ID — establishes the security group context so that subsequent validation honours the correct business group and security profile.
• FIRST_ACTIVE_POSITION_ROW / ALL_PROPOSED_ONLY_POSITION — helper functions that interrogate position data to locate the first active position row or to determine whether only proposed (non-active) positions exist.
• CHK_REF_INT_DEL — referential-integrity check performed prior to deletion.
• CHK_DDF / CHK_DF — validation routines relating to descriptive flexfield handling for position records.
• DE_UPDATE_PROPERTIES — manages updates to date-effective properties on the position.
• CHK_AVAILABILITY_STATUS_ID — validates the availability status assigned to a position.
• CHG_DATE_EFFECTIVE — supports changing the effective date of a position record while preserving date-track integrity.
• CHK_PERMANENT_SEASONAL_FLAG — validates the permanent/seasonal indicator used to classify position tenure.

Tables Accessed

The package reads and writes through APPS synonyms across both HR and Payroll tables. Position and organization data is drawn from HR_ALL_POSITIONS_F and HR_ORGANIZATION_INFORMATION. Assignment, vacancy and budget context comes from PER_ALL_ASSIGNMENTS_F, PER_ALL_VACANCIES, PER_ASSIGNMENT_STATUS_TYPES and PER_BUDGET_ELEMENTS. Grade and job evaluation logic references PER_GRADES, PER_GRADE_SPINES_F, PER_JOB_EVALUATIONS and PER_JOB_REQUIREMENTS. Payroll-related validation touches PAY_ELEMENT_LINKS_F, PAY_GRADE_RULES_F, PAY_ORG_PAY_METHOD_USAGES_F and PAY_PERSONAL_PAYMENT_METHODS_F, and PER_MM_POSITIONS supports mass position operations. The package also references HR_PSF_SHD, the shadow table that holds the date-tracked history of position rows, and calls utility routines in HR_UTILITY.

Usage Notes

HR_PSF_BUS is invoked indirectly. Oracle's Position and Assignment Forms call the HR_PSF_INS/UPD/DEL packages, which in turn invoke the validation entry points in HR_PSF_BUS. It is also referenced by HR_PFT_BUS, PE_POI_BUS and by HR_PSF_BUS itself (recursive calls), and it depends on HR_POSITIONS and the shadow table HR_PSF_SHD. Because it is an internal "_BUS" layer rather than a published API, custom code should generally not call it directly; developers extending position management should prefer the supported public APIs, reserving HR_PSF_BUS for diagnostics or dependency analysis.