Search Results validate_primary_flag

Overview

APPS.PER_ASSIGNMENTS_F3_PKG is a PL/SQL package in the Oracle E-Business Suite Applications schema (APPS), classified under the ETRM as an "OTHER" API rather than a formally published public interface. It belongs to the family of assignment-related packages that support the Oracle Human Resources (PER) product, and it operates against the PER_ALL_ASSIGNMENTS_F date-tracked assignment entity and its associated payroll, grade, and spinal point structures. The package status is documented as VALID in both 12.1.1 and 12.2.2, confirming that it remains a supported internal component of the HR assignment processing stack.

The business function served by PER_ASSIGNMENTS_F3_PKG centres on the validation and lifecycle management of assignment records, particularly the handling of assignment status transitions such as termination and end-dating, the enforcement of primary assignment rules, and the maintenance of proposals and element entries attached to an assignment. The "F3" suffix identifies it as one in a sequence of internal assignment packages, working alongside PER_ASSIGNMENTS_F2_PKG, which the ETRM records as referencing this package.

Key Procedures and Functions

The ETRM documents seven procedures or functions within this package. Their purposes, as reflected by their names, are as follows:

• PROCESS_END_STATUS — Handles processing associated with an end status on an assignment, applying the business rules that determine the outcome when an assignment is brought to an end.
• PROCESS_TERM_STATUS — Processes termination status changes on assignments, coordinating the effects of a termination on the assignment record.
• VALIDATE_PRIMARY_FLAG — Validates the primary assignment indicator, ensuring that primary flag settings conform to the rules governing which assignment is designated primary for an employee.
• TEST_FOR_CANCEL_TERM — Tests whether a termination should be cancelled or reversed, supporting the correction of erroneously applied terminations.
• CHECK_FUTURE_PRIMARY — Checks for the existence of a future-dated primary assignment, guarding against conflicts in primary assignment dating.
• PRE_UPDATE_BUNDLE2 — Performs pre-update processing as part of a bundle of related assignment updates, preparing data before the update is applied.
• UPDATE_AND_DELETE_BUNDLE — Executes the combined update and delete operations for the assignment bundle, applying the changes prepared by the preceding procedure.

Parameter lists are not exposed in the available metadata and are therefore not reproduced here.

Tables Accessed

Through APPS synonyms, the package references the following tables:

• PER_ALL_ASSIGNMENTS_F — The primary date-tracked assignment entity; the principal read/write target.
• PER_ASSIGNMENT_STATUS_TYPES — Supplies valid assignment statuses used in end and termination status processing.
• PAY_ELEMENT_ENTRIES_F and PAY_ELEMENT_ENTRY_VALUES_F — Payroll element entries and their values that must be maintained in step with assignment changes.
• PER_PAY_BASES and PER_PAY_PROPOSALS — Pay basis definitions and salary proposals associated with the assignment.
• PER_GRADE_SPINES_F, PER_SPINAL_POINT_PLACEMENTS_F, and PER_SPINAL_POINT_STEPS_F — Grade and spinal point structures used where assignment changes affect grade progression or placement.

Usage Notes

Because ETRM classifies this package as an "OTHER" API and it is referenced only by one other package (PER_ASSIGNMENTS_F2_PKG), it is an internal implementation component rather than a public, supported integration point. It is typically invoked indirectly by the Oracle HR forms and by higher-level assignment packages when an assignment is created, updated, terminated, or end-dated. Custom code should not call the individual procedures directly; instead, customisations should use the supported public HR APIs, since the internal signing and parameter conventions of PER_ASSIGNMENTS_F3_PKG are not guaranteed across patches or releases.