Search Results per_job_del




Overview
Explore in AI Chat

Overview

PER_JOB_SHD is an Oracle E-Business Suite shadow (audit/history) package in the APPS schema that supports the Job definition entity within Oracle Human Resources (PER). The suffix "_SHD" denotes a shadow package associated with a corresponding base entity table — in this case PER_JOBS — and is responsible for maintaining the historical or audit representation of job records as changes are applied through the standard HR Job API layer. Jobs are a foundational HR object: they classify positions, feed assignment records, drive compensation and grade validation, and are surfaced throughout HRMS, Payroll, and self-service modules.

The package is documented with an API classification of "OTHER," meaning it is not a public, callable business API but rather an internal supporting component that is invoked indirectly by the Job business logic. Its status is VALID in the ETRM registry, and it carries a dependency classification consistent with an internal shadow/validation package rather than an end-user API.

Key Procedures and Functions

The ETRM metadata documents five procedures/functions on PER_JOB_SHD. Several are internal control utilities rather than business operations.

  • RETURN_API_DML_STATUS — Returns the DML outcome/status associated with the current API invocation, allowing callers to determine whether the last operation resulted in an insert, update, or similar state change.
  • CONSTRAINT_ERROR — Provides controlled handling of constraint violations raised during shadow processing, centralizing error interpretation for the Job entity.
  • API_UPDATING — Indicates whether the API is currently executing an update operation, used to manage conditional logic inside the shadow path.
  • LCK — Performs the locking step required before modifying job data, ensuring concurrency safety during shadow record maintenance.
  • CONVERT_ARGS — Converts or normalizes internal arguments prior to processing, bridging the caller's data shape to the shadow package's expected inputs.

No parameter lists are documented, and none are inferred here.

Tables Accessed

The metadata records two referenced relations, both through APPS synonyms:

  • PER_JOBS — The base Job definition table. The shadow package reads and/or writes against this table to synchronize and maintain the audited representation of job records.
  • ALL_CONSTRAINTS — The data dictionary view used to introspect constraint definitions at runtime, supporting the CONSTRAINT_ERROR logic and preventing invalid shadow operations.

Usage of ALL_CONSTRAINTS indicates the package performs dynamic constraint validation rather than relying solely on static error codes.

Usage Notes

PER_JOB_SHD is never invoked directly by end users. It is referenced by eight other packages, including HR_JOB_API, PER_JOB_BUS, PER_JOB_DEL, PER_JOB_INS, PER_JOB_UPD, PER_JOB_FLEX, PER_PQH_SHR, and PER_JOBS_OVN. This confirms it sits inside the Job API stack: the insert, update, delete, and business-rule packages call into SHD to preserve history and enforce integrity whenever job data changes.

In practice, the package executes whenever a job is created, modified, or deleted through the standard HR Job form or through any custom code that legitimately calls the Job API. This mirrors the user search term "per_job_del," which points to PER_JOB_DEL — the delete handler that depends on SHD. Because this is an internal shadow component, customizations should target the public Job API (HR_JOB_API) rather than PER_JOB_SHD, which may change across EBS 12.1.1 and 12.2.2 without notice.