Search Results per_job_shd




Overview
Explore in AI Chat

Overview

APPS.PER_JOB_SHD is the date-tracked shadow (SHD) package body associated with the PER_JOBS business entity in Oracle E-Business Suite Human Resources. In the EBS date-tracked table architecture, each transactional entity such as Jobs is paired with a corresponding _SHD table that preserves the full historical record of row changes through effective start and end dates, plus a shadow-only "object version number" column used for concurrent update detection. The package body encapsulates the PL/SQL logic necessary to maintain that shadow representation consistently whenever a job row is inserted, updated, or its date-tracked attributes are modified.

The object is owned by the APPS schema, holds a VALID status, and is classified in ETRM as OTHER rather than as a public or private API. Its primary consumers are other HR packages and the date-tracked maintenance infrastructure that coordinates shadow-table writes. The package is documented in both 12.1.1 and 12.2.2; no functional differences are recorded across those releases.

Key Procedures and Functions

Five documented program units are present in the package body:

  • RETURN_API_DML_STATUS — Returns the DML status tracked by the API invocation, allowing the calling layer to determine whether the most recent operation resulted in an insert, update, or delete against the shadow record.
  • CONSTRAINT_ERROR — Centralized handler for constraint violations raised during shadow-table maintenance, typically translating an Oracle error into a meaningful API-level failure.
  • API_UPDATING — Indicates whether the package is currently executing in an API-driven update context, used to guard shadow-specific logic from being applied twice or from conflicting with direct DML.
  • LCK — Performs the locking routine required to serialize access to the shadow row before modification, preventing lost updates in multi-user concurrency.
  • CONVERT_ARGS — Normalizes and converts the incoming argument set into the internal representation expected by the shadow maintenance routines.

Parameter signatures are not reproduced here; only the documented unit names and their functional intent are stated.

Tables Accessed

The package references two tables through APPS synonyms:

  • PER_JOBS — The base date-tracked Jobs table. The package reads and writes job definitions, including effective dates, to keep the base row aligned with its shadow counterpart.
  • ALL_CONSTRAINTS — Queried to introspect constraint metadata for the shadow table, supporting validation and error handling during shadow maintenance.

In addition, the package body depends on HR_API and HR_UTILITY, which provide the shared date-tracked utility routines and API framework calls used across HR shadow packages.

Usage Notes

PER_JOB_SHD is not intended for direct invocation by end users or custom code. It is invoked indirectly by the HR date-tracked maintenance framework and by callers that manipulate job definitions through supported HR APIs. It is not referenced by any database object per the ETRM dependency record, although eight other packages reference it, indicating that its callers sit in the HR package hierarchy rather than in schema-level database dependencies. Customizations should treat it as an internal implementation package: modifications to Jobs must be performed through supported HR APIs such as HR_JOB_API, not by calling PER_JOB_SHD procedures directly. Because the package participates in the locking and versioning of the PER_JOBS shadow record, bypassing the API layer risks corrupting effective-date history and object version numbers.