Search Results per_assignments_s




Overview
Explore in AI Chat

Overview

APPS.PER_ASSIGNMENTS_V7_PKG is a versioned PL/SQL package body that encapsulates the core business logic for maintaining employee assignment records in Oracle E-Business Suite Release 12.1.1 and 12.2.2. The package is owned by the APPS schema and is classified under the "OTHER" API category within the ETRM repository, though functionally it operates as a low-level data-maintenance layer beneath the higher-level HR_ASSIGNMENT_API and the public PER_ASSIGNMENTS_API family. Its principal role is to provide row-level insert, update, delete, and locking operations against the assignment tables, together with auxiliary lookups such as location address resolution, primary-assignment validation, and retrieval of historical versus future-dated changes.

The package is a legitimate, VALID object and forms part of the internally generated backend used by Oracle Forms (notably the Assignment and Grade forms) and by other PL/SQL packages that require direct manipulation of assignment rows without going through the enforced business rules of the public APIs. It is not referenced by any other database object at the API exposure layer, which confirms its role as a supporting, non-public utility package.

Key Procedures and Functions

  • INSERT_ROW — Creates a new assignment row in the underlying assignment entity, establishing effective-dated assignment attributes.
  • LOCK_ROW — Acquires a row-level lock on an existing assignment record, typically used to serialize concurrent updates before an edit transaction.
  • UPDATE_ROW — Modifies an existing assignment record, applying the changed columns supplied by the caller.
  • DELETE_ROW — Removes an existing assignment record from the datastore.
  • GET_LOCATION_ADDRESS — Returns the formatted address associated with a location, resolving address formatting via the HR_LOCATIONS and HR_GENERAL utilities.
  • CHECK_PRIMARY — Validates whether the assignment under consideration qualifies as (or conflicts with) the primary assignment for the person.
  • GET_PREVIOUS_CHANGES — Retrieves backward-looking (historical) modifications made to an assignment, supporting audit and change-tracking requirements.
  • GET_FUTURE_CHANGES — Retrieves forward-dated modifications scheduled against an assignment, supporting future-dated effective changes.

Tables Accessed

All base tables are referenced through APPS synonyms. PER_ALL_ASSIGNMENTS_F is the primary effective-dated datastore targeted by INSERT_ROW, UPDATE_ROW, and DELETE_ROW, and is queried by GET_PREVIOUS_CHANGES and GET_FUTURE_CHANGES to distinguish past from future versions. PER_ASSIGNMENTS_S is the corresponding non-dated surrogate-key table that the package uses in conjunction with the _F table; this is the object users commonly search for as "per_assignments_s." PER_ASSIGNMENT_STATUS_TYPES supplies valid assignment status values, and PER_ASS_STATUS_TYPE_AMENDS defines which status changes are permitted and how one status amends another. Supporting reference data is drawn from HR_LOCATIONS (address lookup), PER_BUSINESS_GROUPS (business-group context), and DUAL.

Usage Notes

PER_ASSIGNMENTS_V7_PKG is normally invoked indirectly rather than by custom code. It is called during Oracle Forms processing of assignment maintenance screens, and by other PL/SQL packages that need direct write access to assignment rows. Because it bypasses much of the validation enforced by the public HR_ASSIGNMENT_API, Oracle strongly recommends that developers use the supported public APIs rather than the V7 package. Where direct invocation is unavoidable — for example in conversion scripts or narrowly scoped customizations — callers must ensure that effective-dating rules, primary-assignment constraints, and status-type amendments are respected manually. The package reports errors through FND_MESSAGE and APP_EXCEPTION, and relies on HR_SECURITY_INTERNAL for row-level security enforcement.