Search Results per_asg_shd




Overview
Explore in AI Chat

Overview

PER_ASG_SHD is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite, addressing the Assignments entity within Oracle Human Resources (PER). The suffix "SHD" denotes a shadow package, a design pattern Oracle uses to encapsulate and route Data Manipulation Language (DML) operations that would otherwise be performed directly by the Oracle Forms-based Assignments form or by other programmatic callers. Rather than allowing direct INSERT, UPDATE, and DELETE statements against the base assignment table, the shadow package intercepts those operations, applies consistency and validation logic, and dispatches the work through the formal HR API layer.

The package depends on the DATE-TRACK (DT_API) and HR_API infrastructure, both of which are central to effective-dated entity management in EBS. This confirms that PER_ASG_SHD operates within Oracle's DateTrack framework, where changes to assignments are recorded as dated rows rather than destructive in-place updates. The package is classified under the "OTHER" API category in the ETRM registry, indicating it is an internal supporting package rather than a published, customer-facing business API. Its status is VALID in the documented environment.

Key Procedures and Functions

The package exposes eight documented procedures and functions:

  • RETURN_API_DML_STATUS — Returns the DML status of the API call, allowing callers to determine whether the preceding operation succeeded, failed, or was skipped.
  • CONSTRAINT_ERROR — Handles integrity exceptions raised during DML, typically translating low-level constraint violations into meaningful application errors.
  • API_UPDATING — Indicates or tracks that an API-driven update is in progress, supporting recursive-call detection and coordination.
  • FIND_DT_DEL_MODES — Resolves the applicable DateTrack delete modes for the assignment record, determining how removal of a dated row should be interpreted (for example, end-dating versus purge).
  • FIND_DT_UPD_MODES — Resolves the applicable DateTrack update modes, distinguishing correction, update, and future-dated change semantics.
  • UPD_EFFECTIVE_END_DATE — Adjusts the effective end date of the assignment record, a core DateTrack operation when superseding or terminating a dated row.
  • LCK — Performs row-level locking against the assignment record to serialize concurrent modifications.
  • CONVERT_ARGS — Normalizes and converts incoming arguments into the format expected by the underlying HR API layer.

Tables Accessed

The package references three documented tables through APPS synonyms. PER_ALL_ASSIGNMENTS_F is the primary subject table, holding the effective-dated assignment rows that the package inserts, updates, and end-dates. HR_COMMENTS stores associated comment text, allowing annotations to be attached to assignment changes. ALL_CONSTRAINTS is queried to interrogate constraint definitions, supporting the CONSTRAINT_ERROR handling routine in identifying and interpreting violated constraints. The package also references itself (PER_ASG_SHD), consistent with internal procedure calls, and relies on the DT_API, HR_API, HR_UTILITY, and STANDARD packages.

Usage Notes

PER_ASG_SHD is an internal package and is not referenced by any database object in the ETRM dependency listing, meaning it is not exposed as a dependency of other stored objects in that snapshot. However, the documented metadata states it is referenced by 33 other packages, indicating broad consumption within the HR product family. It is typically invoked indirectly: the Assignments form, other HR forms, and higher-level HR APIs call the shadow layer so that DateTrack semantics and validation are enforced consistently regardless of entry point. Custom code should not call this package directly; developers requiring assignment maintenance should use the supported public HR assignment APIs, which in turn route through this shadow implementation. Direct invocation risks bypassing intended validation and DateTrack mode resolution.