Search Results per_assignments_f_pkg




Overview
Explore in AI Chat

Overview

PER_ASSIGNMENTS_F_PKG is a core Oracle E-Business Suite PL/SQL package owned by the APPS schema. It encapsulates the principal Data Manipulation Language (DML) logic for the PER_ALL_ASSIGNMENTS_F entity, which stores the dated and effective assignment records that link employees and applicants to their organizational, payroll, and compensation attributes. In Oracle EBS 12.1.1 and 12.2.2, this package functions as the low-level maintenance layer for assignment rows, providing the procedural interface used by higher-level Human Resources APIs and by Oracle Forms-based maintenance screens. The package status is VALID, and its API classification in the ETRM repository is "OTHER," indicating that it is not published as a formal public API but instead serves as an internal repository object supporting dependent packages and application components.

Key Procedures and Functions

The ETRM metadata documents five procedures and functions within this package:

  • INSERT_ROW — Creates a new row in the assignment entity, populating the mandatory and derived columns required for a valid assignment record.
  • UPDATE_ROW — Modifies an existing assignment row, applying changes to the dated assignment attributes maintained by the package.
  • DELETE_ROW — Removes an assignment row from the underlying table, subject to the package's internal referential and integrity checks.
  • LOCK_ROW — Acquires a row-level lock on the target assignment record, ensuring serialized access during concurrent DML operations.
  • DML_PROMOTION — Supports the promotion of dated row changes, propagating the appropriate effective-dated records required by the assignment data model.

These procedures form the standard insert, update, delete, and locking interface typical of Oracle EBS date-tracked ( _F ) table handlers. Parameter lists are not enumerated in the documented metadata.

Tables Accessed

The package reads and writes the following tables, referenced through APPS synonyms:

These references reflect the package's role in keeping assignment and payroll-related records consistent during DML operations.

Usage Notes

PER_ASSIGNMENTS_F_PKG is typically invoked indirectly rather than called directly by end users. Two other packages in the APPS schema reference it — PER_APPLICANT_PKG and PER_PEOPLE9_PKG — as well as the package body itself. This dependency pattern indicates that the package supports higher-level applicant and people maintenance logic. In practice, it is exercised by Oracle Forms-based assignment maintenance, by concurrent processes and Oracle HRMS business logic that manipulate assignments, and by internal package calls that require consistent effective-dated row handling. Because the API classification is "OTHER," customers and implementers should prefer supported public HRMS APIs for custom extensions rather than invoking these procedures directly. Any custom code that calls into the package should account for the dated ( _F ) data model, the LOCK_ROW serialization behavior, and the side effects on payroll element and proposal data documented in the table access list.