Search Results per_assignments_f2_pkg




Overview
Explore in AI Chat

Overview

APPS.PER_ASSIGNMENTS_F2_PKG is a PL/SQL package body in the Oracle E-Business Suite APPS schema that supports the maintenance of employee assignment records within Oracle Human Resources. It operates alongside the related packages PER_ASSIGNMENTS_F_PKG and PER_ASSIGNMENTS_F3_PKG, which collectively manage the PER_ASSIGNMENTS_F and PER_ALL_ASSIGNMENTS_F entity tables. This package is classified as an OTHER API in the ETRM metadata, indicating that it is not intended for direct external integration use but rather functions as an internal implementation layer. It provides the lower-level validation and lifecycle logic that surrounds assignment creation, update, and deletion, complementing the high-level business logic in the companion packages.

Key Procedures and Functions

The package exposes five documented procedures and functions:

  • INITIATE_ASSIGNMENT — Primes and initializes an assignment record prior to persistence, establishing default and derived values required for a valid assignment.
  • PRE_UPDATE_BUNDLE — Executes pre-update processing for a bundle of assignment changes, typically invoked through the Oracle Forms update path before the DML is committed.
  • IU_NON_PAYROLL_CHECKS — Performs insertion and update validation logic for assignments that are not payroll-relevant, applying checks appropriate to non-payroll assignment contexts.
  • PRE_DELETE — Runs validation and cleanup logic before an assignment record is removed.
  • KEY_DELREC — Handles deletion of a record identified by its primary key, invoked when an assignment is removed from the user interface.

Tables Accessed

The package reads and writes the core HR assignment tables, principally PER_ALL_ASSIGNMENTS_F and its related entity PER_ASSIGNMENTS_F. It also references supporting attribute sources such as PER_PAY_BASES, PER_VALID_GRADES, PER_SPINAL_POINT_PLACEMENTS_F, PER_PERIODS_OF_PLACEMENT, and PER_PERIODS_OF_SERVICE, which supply grading, pay basis, and placement context. Assignment status is validated against PER_ASSIGNMENT_STATUS_TYPES, PER_ASSIGNMENT_STATUS_TYPES_TL, PER_ASS_STATUS_TYPE_AMENDS, and PER_ASS_STATUS_TYPE_AMENDS_TL. People and position context is drawn from PER_PEOPLE_F, HR_ALL_POSITIONS, and PER_BUSINESS_GROUPS. Payroll localization rules are checked via PAY_LEGISLATION_RULES and PAY_LEGISLATIVE_FIELD_INFO, while key flexfield and segment validation use FND_ID_FLEX_STRUCTURES_VL and FND_SEGMENT_ATTRIBUTE_VALUES. System context is obtained from FINANCIALS_SYSTEM_PARAMETERS, FND_PRODUCT_INSTALLATIONS, FND_INSTALLATION, GL_SETS_OF_BOOKS, FND_MESSAGE, and HR_LOOKUPS. Utility routines are shared from HR_UTILITY, HR_ASSIGNMENT, HR_PERSON_TYPE_USAGE_INFO, and STANDARD.

Usage Notes

PER_ASSIGNMENTS_F2_PKG is not referenced by any database object and is not a public integration API. It is invoked indirectly through the Oracle HR forms (Assignment, Position, and related windows) and the internal date-track maintenance logic orchestrated by PER_ASSIGNMENTS_F_PKG and PER_ASSIGNMENTS_F3_PKG. Because the procedures carry no documented parameter lists in the ETRM metadata and are classified as OTHER, custom code should not call them directly; any extension should be developed against the supported PER_ASSIGNMENTS_F_API or equivalent public interfaces. The package remains marked VALID and is present in both 12.1.1 and 12.2.2 installations.